Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-25 : 09:12:32
|
richard writes "My SQL is
entrySQL="SELECT * FROM Groups WHERE Group = " & inputgroup
where inputgroup is a variable input from a form and converted to an integer within the script.
No matter what combination of " and ' I use I always get a "Syntax error in WHERE clause" error message or an "Unterminated string constant" error message if there is a spare ".
Any suggestions how to filter by an integer ? The Group field in the database is formatted as a long integer.
Thanks,
Richard" |
|
|
|
|
|
Syntax error in SQL WHERE clause