Can I do it like this? <cffunction access="public" name="qry_cart_check_item_quantities" output="no" returntype="void" hint="Verifies that items in user's cart are still available."> <cfargument name="cf_user_id" type="string" required="no" default=""> <cfargument name="app_user_id" type="numeric" required="no" default="0"> <cfif not len(arguments.cf_user_id) and arguments.app_user_id eq 0> <cfabort showerror="qry_cart_check_item_quantities: you must pass either arguments.cf_user_id or arguments.app_user_id"> </cfif> <cfquery name="qry_cart_check_item_quantities" datasource="#request.dataSource#"> exec [proc_rhkprod_cart_check_item_quantities] <cfif len(arguments.cf_user_id)> @cf_user_id = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#arguments.cf_user_id#"> <cfelse> @cf_user_id = <cfqueryparam value="#arguments.cf_user_id#" cfsqltype="CF_SQL_VARCHAR" null="yes"> </cfif> , <cfif arguments.app_user_id neq 0> @app_user_id = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#arguments.app_user_id#"> <cfelse> @app_user_id = <cfqueryparam value="#arguments.app_user_id#" cfsqltype="CF_SQL_INTEGER" null="yes"> </cfif> </cfquery> </cffunction>
Or do I need to use CFSTOREDPROC? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm