Recent content by jenmer

I use the quotes Like and CVBook.mBASectorID in ('#form.mbasectorid#') But when i use and CVBook.mBASectorID in (#form.mbasectorid#) It gives me this error [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '10,12,13,3,4,6,7,9' to a column of data type int.

Hi and CVBook.mBASectorID in (<cfqueryparam cfsqltype="cf_sql_integer" value="#Form.mbasectorid#" list="Yes">) gives me the following error [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '10,12,13,3,4,6,7,9' to a column of data type int. The...

Hi Yes i think so, the Field MBASectorID has 1,2,3 entered, which is a Look up for the MBASector Table. The values of 1,2,3 are Accounting, Advertising, Consulting which are belong to MBASector Table. I hope this makes sense Jennifer

Hi If a sector has more than two items assigned to it, it omits it from the search result Back again.. This multiple select has been a real pain one thing solved to find another thing wrong with it. In the search results it omits any entry that has two items or more assigned to it. For...

I still get the same error.. but after all of this it wasnt down to the code it was the database at fault. Thanks for your help. Just wished i had found this out last week not to waste so much time on it..

Hi Thanks for sending me on a reply unfortunatly I tried the code and gives the same error?? Any other ideas? Jennifer

Hi I am using a query below for a multiple select and it is giving me the error below. I am supposed to use the IN statement below but it still is giving me this error. I have been at this for days and it's driving me mad. <select multiple="multiple" name="mbasectorid"> <option...