NateUNI
|
Posted: 12/09/2003, 8:31 PM |
|
I am getting the following error when i click on a column header to sort a grid.
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Priority Number'., SQL state 37000 in SQLExecDirect in c:\program files\easyphp\www\webstat\db_odbc.php on line 81
Database error: Invalid SQL: SELECT [Tracking Number], [Priority Number], Description, [Reported Date] FROM BugTracking WHERE [Institution Initials] = 'CMARSHALL' ORDER BY Priority Number
ODBC Error: 1 (General Error (The ODBC interface cannot return detailed error messages).)
Session halted.
I know the error is caused by the Priority Number not being in []. How do I fix this? Thanks!!
|
|
|
ryan
|
Posted: 12/09/2003, 10:10 PM |
|
you are right on your data source, the ORDER BY textbox below, try to type
[Priority Number]
instead of
Priority Number
|
|
|
|