Trying to return results from a query run on the database

Fred Giannetto fgiannet at hotmail.com
Tue Nov 1 18:03:35 CST 2005


Hello,

I am trying to create a list of data entered into the database.

I have recently tried

get revDataFromQuery(tDatabaseEnroll,"SELECT lname, fname, ID from 
usrev.results")
  --revQueryDatabase(tDatabaseEnroll,select "lname", "fname", "ID" from 
usrev.results")
  --revQueryDatabase(tDatabaseEnroll,"select `lname`, `fname`, `ID` from 
usrev.results")
  answer it

for the first line I keep getting the error
Type	Function: error in function handler
Object	Button
Line	get revDataFromQuery(tDatabaseEnroll,"SELECT lname, fname, ID from 
usrev.results")
Hint	revDataFromQuery


for the second I keep getting
Type	Expression: missing ')' before factor
Object	Button
Line	revQueryDatabase(tDatabaseEnroll,select "lname", "fname", "ID" from 
usrev.results")
Hint	lname

for the third
Type	Function: error in function handler
Object	Button
Line	get revDataFromQuery(tDatabaseEnroll,"SELECT `lname`, `fname`, `ID` 
from usrev.results")
Hint	revDataFromQuery

when I put single quotes on the variables I get an error that states it 
can't find the handler.

I would think the first statement would work, does anyone see what I am 
missing?

Also, what does the "cant find handler" statement mean?

Thank you
All best Always
Fred





More information about the use-livecode mailing list