Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Syntax error in ASP code results page

Syntax error in ASP code results page

Thread began 10/16/2012 5:05 am by YellowCircleWeb | Last modified 10/16/2012 8:03 am by YellowCircleWeb | 521 views | 1 replies

10/16/2012 5:05 amYellowCircleWeb

Syntax error in ASP code results page

Hi,

I'm using the DataAssist 2 wizard for an old ASP website I have been asked to work on.

I'm getting a syntax error on the results page:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Company Name'.
/db-admin/tblRecommendedRetailers_Results.asp, line 67

I think this is due to the database field name containing spaces - I cannot change this unfortunately as the database is also used by my client.

Can anyone provide any suggestions as to how to go about fixing this issue? The problem is being caused in the WHERE clause too, when searching for records. I've attached a copy of my page in zip format to this post.

***** UPDATE - FIXED IT MYSELF *****
I found the problem, it was to do with the ORDER BY part of the SQL statement. I needed to add square brackets around the field [Company Name] in this part of the SQL query. That fixed it.

Attached Files

tblRecommendedRetailers_Results.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.