Trying to return results from a query run on the database
shaosean at hotmail.com
Wed Nov 2 10:50:18 CST 2005
Hi Fred, as Trevor pointed out the proper syntax for the revDataFromQuery
You'll notice that the first two parameters are optional, but the "commas"
are not, so you're command should be something like so:
get revDataFromQuery(,, databaseID, "SELECT * FROM table")
put revDataFromQuery(TAB,, databaseID, "SELECT name, email FROM users
I found in the database project I've been working on, that there is no need
for quotes around the field names, only needed around that data you are
inserting or updating.
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
More information about the use-livecode