I fail at cfabort. disregard. Sorry. On Mon, Apr 5, 2010 at 5:56 PM, Matthew Smith <chedders...@gmail.com> wrote:
> Still stumped on this. It seems that cart_check_item_quantities is somehow > stopping the second recordset from existing. What is going on here? > > This: > <cfcase value="start"> > <!--- <cfobject component="redhotkittiescfcs.cart" name="cart" /> > <cfset cart_check_item_quantities = cart.check_item_quantities( > cf_user_id="#cfid#_#cftoken#") /> > <cfdump var="#cart_check_item_quantities#"> > <cfif cart_check_item_quantities.recordcount> ---> > <cfobject component="redhotkittiescfcs.qry" name="qry" /> > <cfset qry_cart_adjustments_get = qry.qry_cart_adjustments_get( > cf_user_id="#cfid#_#cftoken#") /> > <!--- </cfif> ---> > <cfdump var="#qry_cart_adjustments_get#"> > <cfabort> > </cfcase> > Works properly and gives me this: > query RESULTSET query ADJUSTED ADJUSTEDQUANTITY CFUSERID > ORIGINALQUANTITY REMOVED TABLEPK TBLPEOPLEFK TBLPRODUCTSFK 1 1 -1 > 1506_18149772 > 1 0 21 [empty string] 281 > CACHED false EXECUTIONTIME 0 SQL SELECT * FROM rhkProd_tblCartAdjustments > WHERE 1 = 1 AND cfuserid = ? SQLPARAMETERS array 1 1506_18149772 > > But this(not commented): > <cfcase value="start"> > <cfobject component="redhotkittiescfcs.cart" name="cart" /> > <cfset cart_check_item_quantities = cart.check_item_quantities( > cf_user_id="#cfid#_#cftoken#") /> > <cfdump var="#cart_check_item_quantities#"> > <cfif cart_check_item_quantities.recordcount> > <cfobject component="redhotkittiescfcs.qry" name="qry" /> > <cfset qry_cart_adjustments_get = qry.qry_cart_adjustments_get( > cf_user_id="#cfid#_#cftoken#") /> > </cfif> > <cfdump var="#qry_cart_adjustments_get#"> > <cfabort> > </cfcase> > > Only gives me this, one recordset dumped, not both: > query RESULTSET query ADJUSTED ADJUSTEDQUANTITY CFUSERID > ORIGINALQUANTITY REMOVED TABLEPK TBLPEOPLEFK TBLPRODUCTSFK 1 1 -1 > 1506_18149772 > 1 0 21 [empty string] 281 CACHED false EXECUTIONTIME 15 SQL exec > [proc_rhkprod_cart_check_item_quantities] @cf_user_id = ? , @app_user_id = ? > SQLPARAMETERS array 1 1506_18149772 2 [empty string] > On Mon, Apr 5, 2010 at 10:52 AM, Matthew Smith <chedders...@gmail.com>wrote: > >> <cfobject component="redhotkittiescfcs.cart" name="cart" /> >> <cfset cart_check_item_quantities = cart.check_item_quantities( >> cf_user_id="#cfid#_#cftoken#") /> >> <cfif cart_check_item_quantities.recordcount> >> <cfobject component="redhotkittiescfcs.qry" name="qry" /> >> <cfset qry_cart_adjustments_get = cart.qry_cart_adjustments_get( >> cf_user_id="#cfid#_#cftoken#") /> >> </cfif> >> >> The if is not running. >> >> Also, I was dumping the recordset with this: >> <cfcase value="start"> >> <cfobject component="redhotkittiescfcs.cart" name="cart" /> >> <cfset cart_check_item_quantities = cart.check_item_quantities( >> cf_user_id="#cfid#_#cftoken#") /> >> <cfif cart_check_item_quantities.recordcount> >> <cfobject component="redhotkittiescfcs.qry" name="qry" /> >> <cfset qry_cart_adjustments_get = cart.qry_cart_adjustments_get( >> cf_user_id="#cfid#_#cftoken#") /> >> </cfif> >> <cfdump var="#qry_cart_adjustments_get#"> >> <cfabort> >> </cfcase> >> >> Here is the output: >> query RESULTSET query ADJUSTED ADJUSTEDQUANTITY CFUSERID >> ORIGINALQUANTITY REMOVED TABLEPK TBLPEOPLEFK TBLPRODUCTSFK 1 1 -1 >> 1506_18149772 >> 1 0 21 [empty string] 281 CACHED false EXECUTIONTIME 0 SQL exec >> [proc_rhkprod_cart_check_item_quantities] @cf_user_id = ? , @app_user_id = ? >> SQLPARAMETERS array 1 1506_18149772 2 [empty string] >> Why am I seeing: >> SQLexec [proc_rhkprod_cart_check_item_quantities] @cf_user_id = ? , >> @app_user_id = ? >> Shouldn't it be the other sp? >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
