Database Queries

Retrieving Single Values from Databases

If you have a query that returns a single string value and want to display it on the page use the following syntax:

#stringValueOfQuery("dbnickname","query")

For example:

#stringValueOfQuery("SampleDB","Select Name From Agency Where ID = 6")

Similarly the following notations can be used for retrieving integer and double values from database and displaying them on the page:

#integerValueOfQuery("dbnickname","query")
#doubleValueOfQuery("dbnickname","query")

Retrieving Tables from Databases

See Tables Help