mysql query Syntax error

[DavJans]

I've spend 2 hours trying to find the right syntax and everything has failed or led me to believe this is correct...

Code: Select all

put "SELECT * FROM " & tTableName & "WHERE tcertn = " & tCertN & ";" into tSQL
put revDataFromQuery(Tab, cr, gConnectionID, tSQL) into tData

The error I'm getting wants the right syntax near '= 3'

tCertN = 3

[SparkOut]

Put tSQL before running the query and check it looks ok. It looks like you need a space after the tTablename variable and before the WHERE to me. You could also check that the SQL query really needs the trailing semicolon.

[DavJans]

Thank you, getting rid of the ; fixed it

I had a space before the WHERE in my code but forgot it when I retyped the code here on the forum