2. ASPRunnerPro General questions
  3. error: Syntax error in ORDER BY clause
This topic is locked

error: Syntax error in ORDER BY clause

 		4/13/2005 8:19:03 AM
ASPRunnerPro General questions
author

I have installed ver. asprunnerpro32 and started working with that, when trying to get the _list page, I am getting the error: -2147217900

Error description:[Microsoft][ODBC Excel Driver] Syntax error in ORDER BY clause.

SQL query: select [ID], [Customer Name], [Customer_Link], [Region], [Field TSE], [FT_Link], [Account SE], [AS_Link], [A-1001 Ver], [A-1002 Ver], [A-1003 Ver], [A-1004 Ver], [Last Updated], [Comments] From [All_Customers] ORDER BY [Customer Name] ASC asc
How to fic that?
Thanks a lot
501160 4/13/2005

spelling error in original post, meant: How to fix that?
Thanks
Sergey Kornilov admin 4/13/2005

Hi,
please download updated version at http://www.asprunner.com/files/asprunnerpr...pro32-setup.exe
501161 4/13/2005

That's the version that I have, I downloaded it yesterday.
Thanks
501162 4/13/2005

Try with 3.1a
501163 4/14/2005

I know it works on 3.1a, I prefer using 3.2 to win the new features.
Thanks
501164 4/14/2005

additional information: after 1 or more refreshes of the error page, the page is usually displayed correctly.

Admin: can you please suggest a solution so the error won't appear?
Thanks a lot
Sergey Kornilov admin 4/14/2005

We put updated beta version to the Web every day during beta-testing period. Just download fresh update where this problem already fixed.
501165 4/14/2005

2 questions:

  1. Is there a way to fix that orderby issue manually? I have made a lot of updates and I prefer to solve that manually.
  2. When I download an updated version, do I have always to recreate the project from the beginning - not to use a saved project from previous version (In the past when I used saved project in different version than the one it was created, I had problems)?
    Thanks a lot
Sergey Kornilov admin 4/14/2005

Hi,
it's safe to open your existing project with the latest update. I won't recommend to fix ORDER BY issue manually.