Exactly right:
put "show columns from person" into tQuery
get revDataFromQuery(comma,return,myDBid,tQuery)
Now 'it' contains a list of lines, one per db column, of comma-
delimited items.
Don't know how I'm going to use it yet -- but thanks very much for
helping me get it.
Charles Hartman
On Oct 9, 2005, at 4:20 PM, Dave Cragg wrote:
On 9 Oct 2005, at 19:26, Charles Hartman wrote:
Something I don't understand about the revExecuteSQL command. I
open my MySQL database and get an id. Now, to make later steps
more general purposes, I'd like to ask the database for the
structure of one of its tables (number of columns, column names)
rather than hardwiring that into the Rev front-end. So I should be
able to create a
global myArray
and then with my dbID in hand,
revExecuteSQL dbID, "show columns in myTable", "myArray"
(taking care to put quotes around myArray as the docs say).
Trouble is, nothing shows up in myArray, or anywhere else as far
as I can see. Using a variable (or several) instead of myArray
doesn't help, neither does putting some dummy stuff ("") into
myArray[1], myArray[2], etc., ahead of time.
The variable or array is used to substitute values in the SQL
statement, not to receive data from the query.
Try using revdb_querylist (or revDataFromQuery) to execute SQL that
returns data.
For example
put "show columns in myTable" into tQuery
put revdb_querylist(,, dbID,tQuery) into tData
put tData into field "whatever'
The docs aren't too clear on this. They seem to say use
revdb_execute (or revExecuteSQL) for everything except SELECT
statements. But I think we have to infer that any SQL that returns
data should be treated in the same way as SELECT. (as opposed to
INSERT, UPDATE, etc. where we should use revdb_execute)
Cheers
Dave
_______________________________________________
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
_______________________________________________
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
