> Pre-existing database - I've got to deal with what's there, unfortunitely.
Well first I'd tell the client that it should really be fixed...because it will cost more in the long run for maintenance....and will continue to effect performace until fixed. When they tell you where to go and how to get there, then you can try this: ;-) 1) create a new query <cfset MyQuery = QueryNew()> 2) loop over the color list that you had used in your IN clause 3) run a query for each color seperately (one for each pass of the loop) 4) add the records returned from each query to "MyQuery" 5) run a query of a query on MyQuery so you can re-order the results It's clumsy and inefficient, but if that's what your client wants...that's what they can have ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
