Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jenmer
-
Multiple Select Issue again
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. -
Multiple Select Issue again
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... -
Multiple Select Issue again
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 -
Multiple Select Issue again
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... -
Multiple Select Error
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.. -
Multiple Select Error
Hi Thanks for sending me on a reply unfortunatly I tried the code and gives the same error?? Any other ideas? Jennifer -
Multiple Select Error
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...
