On Dec 27, 2005, at 8:34 PM, Scott Kane wrote:
What I'm trying to do is:
put "SELECT * FROM users" into tSQL
--> EXECUTE SQL
put revdb_querylist(,,gConID,tSQL) into tList
handleRevDBerror tList
if the result is not empty then
answer warning the result
exit mouseUp
end if
put tList into fld "Users"
---------------------------
That works fine. What I need to do is add the tList
elements to a group of normal Fields (edit boxes for
clarity). In the example there would be three of
these:
edName
edEmail
edSubscribed
Hi Scott,
The revdb_querylist function is just returning tab/cr delimited text
so you can loop through all results like this:
set the itemDelimiter to tab
repeat for each line tResult in tList
put item 1 of tResult &cr after tNames
put item 2 of tResult &cr after tEmails
put item 3 of tResult &cr after tSubscribed
end repeat
I'm not quite sure how your edit boxes are being used. Are you
trying to just put one of the records from the tList result into the
edit boxes? Or are you trying to edit all of the names, emails, etc.
at once? If you are just trying to edit one result at a time then I
would probably modify the query to return the specific record you are
after.
If you just want to work with all resorts at once then you could do
this to get at record 3:
put item 1 of line 3 of tList into field "edName"
put item 2 of line 3 of tList into field "edEmail"
put item 3 of line 3 of tList into field "edSubscribed"
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution