Hi,
I'm replacing my buggy mysql query's for correct ones...
All is well except for this one...
DIM sTable as String = "remarks_tags"
Main.hDB.Exec("SELECT text FROM " & sTable & " ORDER BY rand() LIMIT 1")
This works ok...
Replaced by...
Main.hDB.Exec("SELECT text FROM &1 ORDER BY rand() LIMIT 1", sTable)
Which results in an SQL query syntax error, is this correct behavior?
Any ideas?
Regards,
Ron_2nd
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
