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