View Single Post
  #4 (permalink)  
Old July 16th, 2004, 12:01 PM
mircea mircea is offline
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The full SQL where the error appears is:
---------
sql = "SELECT products.productid, products.Nr, products.Author, products.Title, products.Subtitle, products.Sonder, products.Price, products.Old_price, products.FilePath, products.FileName, products.featured FROM products WHERE products.Featured=1 and not_shown=0 and (((charindex(1,'" & str & "',(',' & [productid] & ',')))<>0)) group by products.productid, products.Nr, products.Author, products.Title, products.Subtitle, products.Sonder, products.Price, products.Old_price, products.FilePath, products.FileName, products.featured"
----------

As I said, the column "productid" is "int"...and the rest:
- Nr: nvarchar
- Author, Title, Subtitle: ntext
- ISBN, Sonder: nvarchar
- other fields are: but, money, tinyint
Reply With Quote