G Allen R Souliere wrote: >> 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?
I am no Oracle guru, but I assume it is something like this. <cfquery> INSERT INTO MYTABLE ( MYCOLUMN, MYACOLUMN ... ) VALUES ( <cfqueryparam value="#myValue#">, CASE WHEN Length(TRIM(myAValue)) = 0 THEN <cfqueryparam value="#myAValue#" ...> ELSE NULL END, ... ) </cfquery> -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) CFinNC: http://cfinnc.com/ ColdFusion Conference in Raleigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:329565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
