View Single Post
  #4 (permalink)  
Old June 16th, 2005, 04:49 PM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Leon,

Looks like either CHARINDEX's return value or param is of other type which doesn't match with that of the comparable value. I would like to see the response.write output of the SQL statement that had resulted from this code too. Just curious to see if that has something fishy.

Also I am not sure if you got to use "[]" in here
Code:
strList=Request.Form("fields_of_interest[]")
Let me know how you are naming the check boxes in the html form. I would suggest you name them all as fields_of_interest, hope you have done so. But while requesting, you dont have to use "[]". Also do a response.write strList to see if the values CHECKED are coming fine. Let me know if that helps. This time if something is wrong you should be getting some other error and not the same.

Cheers

_________________________
- Vijay G
Strive for Perfection
Reply With Quote