Hi list,
I'm trying to write a specific SQL request but get only exec errors...
here's the basic request :
put "SELECT id, col_1, col_2 FROM myTable WHERE id < 100" into
myREQUEST
but in the results, I would like each id value to appear like "$12$"
therefore I tried :
put "SELECT "$"+toString(id)+"$", col_1, col_2 FROM myTable WHERE id
< 100" into myREQUEST
but it doesn't work, while the following works :
put "SELECT 1+id, col_1, col_2 FROM myTable WHERE id < 100" into
myREQUEST
but it only adds 1 to each id value...
id is a primary key, positive integer, auto-increment.
Thanks for any help,
JB
_______________________________________________
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
