quote:

---

Here the best free classifieds:
http://eawuy.brinkster.net/demo/

---

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

For some reason, if I add the line
if not rsAds.EOF then why=rsAds("added_by")
it can at least get the added_by variable from the query, but it is still missing other information from the query. Seems really goofy..

ww.sumofx.com/

---

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.

Cheers

Tiki

Edited by - Tiki on 15 May 2001 07:02:16

quote:

---

Here's the link to where I did this so that you can see it:
http://www.sumovw.com/forum/classifieds_detail.asp

---

quote:

---

when you change the Connection of:

strConnString = "Provider=SQLOLEDB;Data Source=(Local);Initial Catalog=musicfox;User ID=sa;Password=a##m" '## MS SQL Server 2000

---

quote:

---

Hi All..

I'm hoping this isn't as far as this mod is going... this could be an awesome feature of many sites using Snitz.. providing its taken to the next level. (auto)Moderation, upload of images, unlimited categories, auctions??.. etc. I'd guess that a robust classifieds system could even become a more popular attraction than the forums.. in applicable web apps. I am anxious to see this mature..as I hope others are too.. My site (which i hope to show-off soon) will cater to small aircraft enthusiasts around the world.. I'm planning to feature a classifieds app that, could likely, be a primary destination for many.

Please, any takers??

---