Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
I am newer to Appian and in the cloud database in the SQL window trying figure out how to do a Parameter Query. I need to have the parameters in the query so it can be ran by other people as well on the fly.
I have this:
SELECT * FROM `accounts` WHERE `state` = :state and `county` = :county and `servcode` = :servcode and `area` = :area
How do I add these before the SELECT statement and give them the values?
so basically I want to be able to do something like this
@state = "IL",
@county = "Jackson",
@servcode = 2568
etc....
Then the query use those to run
Thank you Bill
Discussion posts and replies are publicly visible
If found this in the documentation of phpMyAdmin
docs.phpmyadmin.net/.../faq.html
Yes found that and the bind parameters work just fine, but I need to be able to save these queries to a .sql file so anyone can run them as needed. The parameters need to be set in each sql file for the select statement. So I am trying to figure out how to write the sql to set the parameters and run the sql so it can be save in a .sql file so others can run the files when needed.
Found this: subscription.packtpub.com/.../bookmark-parameters
docs.phpmyadmin.net/.../bookmarks.html