need help on revdb_querylist
janschenkel at yahoo.com
Thu Aug 1 15:12:01 EDT 2002
I must admit I found it a bit strange that you could
omit params at the front when you can have a variable
number of parameters at the end.
However, the documentation shows as first example the
syntax Sylvain used ; and the error message was rather
unhelpful, I might add.
Anyway, thanks for the pointer.
"As we grow older, we grow both wiser and more foolish
at the same time." (De Rochefoucald)
--- Tuviah Snyder <tuviah at runrev.com> wrote:
> > 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)
> > 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
Do You Yahoo!?
Yahoo! Health - Feel better, live better
More information about the Use-livecode