need help on revdb_querylist
Tuviah Snyder
tuviah at runrev.com
Thu Aug 1 12:52:01 EDT 2002
> on mouseUp
>
> put empty into field "result"
> put revdb_connect ("MySQL", "myHost", "myBase",
> "mySelf", "myPass") into id_dbConnection
> put "select * from myTable" into myQuery
> put revdb_querylist(id_dbConnection, myQuery) into
> field "result"
>
> end mouseUp
You need to pass four parameters to revdb_querylist, the first two being the columndelimiter and rowdelimiter..if the column and rowdelimiter are left empty then tab and return are used.
on mouseUp
put revdb_connect ("MySQL", "myHost", "myBase",
"mySelf", "myPass") into id_dbConnection
put "select * from myTable" into myQuery
put revdb_querylist(,,id_dbConnection, myQuery) into
field "result"
get revdb_disconnect(dbConnection)
end mouseup
Tuviah
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.runrev.com/pipermail/use-livecode/attachments/20020801/e9ee0b0b/attachment.html>
More information about the use-livecode
mailing list