Now I am having one of those <v8>Aha!</v8> moments. Thank you... ~David Judah wrote: > Ah, sorry, didn't explain fully. I did a StructKeyExists and a Len to make> sure that the field you are going to evaluate really exists in the form. If> it doesn't, you don't want your cfquery to throw a gnarly error (most> likely) so if the assertion is false, the WHERE clause becomes WHERE 1 = 0> which is always false so the query completes and returns 0 records.> Alternatively, you could wrap your query in a try/catch and catch any db> errors and display them back to the user telling them that they forgot to> put in a field to search on.> > Cheers,> Judah> _________________________________________________________________ Stay up to date on your PC, the Web, and your mobile phone with Windows Live. http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4