True! I can certainly do this as well. On Tue, Jul 22, 2008 at 10:40 AM, morgan l <[EMAIL PROTECTED]> wrote:
> 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:309466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
