What's wrong with using: <cfquery ...> exec sps_testproc <cfif whichvar = "A"> @aid=<cfqueryparam value="123" cfsqltype="cf_sql_integer"> <cfelse> @bid=<cfqueryparam value="456" cfsqltype="cf_sql_integer"> </cfif> </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:309464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4