The query is just horrific..

use structs for checkboxes.. where.. the key is the value.. there are
other ways to do it.. but.. I think this be easier to understand down
the road..

<cfscript>
     colorCodes = StructNew();
     StructInsert(colorCodes, "W", "White");
     StructInsert(colorCodes, "U", "Blue");
     StructInsert(colorCodes, "B", "black");
     <!--- and so on --->
</cfscript>

    then loop over the collection to build your check boxes.. and name
the checkbox.. one thing..

    then you can simpley do...

     AND tblColor.colorCode IN (CHECKBOXNAME)

--
Umer Farooq
Octadyne Systems
[EMAIL PROTECTED]
+1 (519) 772-5424 voice
+1 (519) 635-2795 mobile
+1 (208) 275-3824 fax

LOOKING FOR A USED CAR IN IOWA VISIT: http://www.IowaMotors.com

WARNING: ------------------------------- The information contained in
this document and attachments is confidential and intended only for the
person(s) named above. If you are not the  intended recipient you are
hereby notified that any disclosure, copying, distribution, or any other
use of the information is strictly prohibited.  If you have received
this document by mistake, please notify the sender immediately and
destroy this document and attachments without making any copy of any kind.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to