[Gambas-user] Mysql query question

[Ron]

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