Benoit Minisini wrote: > 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") > >
Ok got it, works ok now. Thanks. ------------------------------------------------------------------------- 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