> > You should be using PLSQL statements. Use CASE statements and > proper PLSQL and see what happens then. >
Could you provide an example of how you would go about writing these PLSQL statements, then? Isn't there still a problem when attempting to pass an empty string via the <cfqueryparam> tags where the cfsqltype is not specified as cf_sql_varchar? Example: INSERT INTO MYTABLE ( MYCOLUMN ) VALUES ( <cfqueryparam value="" cfsqltype="cf_sql_numeric"> ) generates an exception. How do you get around this? Allen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
