On Nov 1, 2005, at 4:03 PM, Fred Giannetto wrote:
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
Hi Fred,
First statement: Your parameters are wrong. The parameters for
revDataFromQuery are:
revDataFromQuery([columnDelim],[rowDelim],databaseID,SQLQuery
[,varsList])
Second statement: Two things - revQueryDatabase is a function and
quotes are wrong. You need to wrap your entire string in double
quotes. If you want to embed double quotes in the string you can use
the format function or something like:
get "SELECT "& quote& "fname"& quote&", "& quote& "ID"& ...
Third Statment: revQueryDatabase is a function. The examples in the
docs are incorrect. Call it like this (the transcript should all be
on one line):
put revQueryDatabase(tDatabaseEnroll,"select `lname`, `fname`, `ID`
from usrev.results") into tRecordSetID
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
