CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 SQL Error when Sorting Grid in Access

Print topic Send  topic

Author Message
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

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.