For those of us in <cf_cutteeth> * Do not use 'client' as the name of a variable. Try to avoid the word 'client' as a database field name - alias it if you have to. Client is a Coldfusion Variable scope and can cause strangeness when used as a variable.
* valuelist() and quotedvaluelist() can save you from doing a lot of stupid lists and concatenation. You can immediately get a list (and a string) of the elements of a column in a query using these two handy functions. PreserveSingleQuotes is helpful in league with quotedvaluelist to prevent single quotes from being stripped. * Learning a language is easy, mastering one takes time. </cf_cutteeth> Nathan Smith McKee, Voorhees & Sease, P.L.C. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
