SQL error
Brought to you by:
nclark
It would be could if it was possible to prevent an SQL error when a table has a name with an SQL operator like a minus character.
My table's name was interpeted as an SQL string minus string substraction witch isn't logical and breaks the original query we want to have.
Debbuged using this line (69) in file viewTableFrame.asp
response.write("<p><span>Debug code: the SQL query is</span> <span style='color:#F20C0C;'>SELECT * FROM " & strTableName & strOrderSql & "</span></p>")
(I normally dont put anything that would mess up the SQL but I imported from somebody else's stuff so it took me a while to understand the problem.)
strSql = "SELECT * FROM [" & strTableName & "]" & strOrderSql
solves the problem