Richard Cooper wrote: > So for example would this be an exmaple of a required and not required > situation
I am getting the impression what you really want is for us to confirm that you don't need them for text datatypes. You do need them. In both cases. And I would strongly suggest that until you are certain you fully understand the subtle interactions of datatypes, (inplicit) character set conversions and non-standard escape sequences for every database your application may ever use you use cfqueryparam. And trust me, by the time you fully understand that for just one database you will have lost all desire not to use cfqueryparam. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

