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

The column "productid" is "int"...

So this "str" would be a collection of integers:
----
str = str & rsprod("productid") & ","
----

I converted "str" to a string using "cstr" function...but I keep getting this error:
-------
Microsoft OLE DB Provider for SQL Server (0x80040E07)
The data type int is invalid for the charindex function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.
-------

How can I make it work?

Thanks,
Mircea