quote:

---

quote:

---

Why am I getting this error whenever it tries to disply an ad?

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

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

/forum/inc_functions.asp, line 1136

---

Found the reason to the prob. If you are
using SQL Server, you need to place fields of type TEXT, NTEXT etc as the last retrieved fields in your SQL statement.
e.g. in file classifieds_detail.asp the following lines of code line 60 should be coded as:


gsSQL = "Select ADS_CONTENT.ID as content_id, Topic_ID, ad_title, price, _image_url, added_By, city, state, email, date_posted, "gsSQL = gsSQL & "link, ADS_CATEGORY.ID, category_name, content FROM ADS_CONTENT _inner join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.ID _WHERE ADS_CONTENT.ID = " & iadID

Somehow, there's some memory flow error when you used NTEXT fields in the middle of a sql field selection.

---

My stats: Win2k Server, MSSQL 7, IIS, Current/updated release of Snitz

I tried the fix, and now I get an error on the line above. When I go to the front page of the classifieds ( http://webdev.som.yale.edu/forums/classifieds.asp ) the space where it shows the most recent ads has this error in it:

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

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

/forums/inc_functions.asp, line 1135

It's a hyperlink and when I click on it, I get this...

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

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

/forums/pop_profile.asp, line 96

HELP! PLEASE!

gsSQL = "Select ADS_CONTENT.ID AS ADSCONTID, Topic_ID, ad_title, price, image_url, added_By, city, state, email, date_posted, "
gsSQL = gsSQL & "link, ADS_CATEGORY.id, category_name, content FROM ADS_CONTENT inner join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.id WHERE ADS_CONTENT.ID = " & iadID

quote:

---

what are the _ in front of inner and where ? your query should be

gsSQL = "Select ADS_CONTENT.ID AS ADSCONTID, Topic_ID, ad_title, price, image_url, added_By, city, state, email, date_posted, "
gsSQL = gsSQL & "link, ADS_CATEGORY.id, category_name, content FROM ADS_CONTENT inner join ADS_CATEGORY on ADS_CONTENT.topic_id = ADS_CATEGORY.id WHERE ADS_CONTENT.ID = " & iadID

---