On mardi 4 novembre 2008, Ron wrote:
> 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
>
&1, &2... are there for quoting SQL values, not SQL table or field names.
Moreover, if you want to insert a table or field name in a SQL request, you
should use the DB.Quote() function:
Main.hDB.Exec("SELECT text FROM " & DB.Quote(sTable) & " ORDER BY rand() LIMIT
1")
Regards,
--
Benoit Minisini
-------------------------------------------------------------------------
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
