ASP trying to access SQL Table..

Trying to access an SQL Table....

'ATTACHMENT'

I have a form that is set up to search the table and attached is the code that is trying to get data from that table.
Need help please, if anyone has any ideas.

This is the error Im getting:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '2003'.

/pub/property/tpp/SearchRes.asp, line 124


I cant figure it out.

Thanks in advance!

Post line 124 and a few lines around it, sorting through all the code in the attachment is a huge pain.

Or simply make a Response.Write of your SQL Query

*** BEFORE *** *** BEFORE *** *** BEFORE *** *** BEFORE ***

You execute it.

then COPY/PASTE the result that YOU see in your BROWSER and PASTE it inside QueryAnalayzer of your SQL Server!

You'll see your error!

Hope this helps!
Sincerely

Vlince

in an add on to vlince's statement

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server

these errors are sql errors. 99% of these are because people don't know how to write them. This is what you do, get them working in sql first in the strait up db command line. Step 2 is when you get the sql line working, to THEN past it into asp and run it, if there's errors, then you write the sql code to the screen and see if it matches your actual query from the DB. and if not, you fix it approp.