no trimmin or queryparams!! shame on u ! ---------------------------------------- From: Tony Weeg <[EMAIL PROTECTED]> Sent: Monday, March 07, 2005 11:04 PM To: CF-Talk <[email protected]> Subject: cftransaction... it wasnt safe?
hi there... i have this section of code... that is enrobed in a cftransaction block that somehow today, was caught in a race condition... meaning... i have two records with the same acctNo, and there should only be one! my first thought, now that i look over the code... would it be better for me to use the request scope for the setting of the newAcctNo? help... thanks! tony select max(acctNo) as thisAccountNumber from accts insert into accts (acctNo, clientNumber, debtorNumber, dateIncurred, dateAssigned, dateLastPayment, amountLastPayment, attyFee_actual, principal, preJudgementInt, countyId, balance, attyFeeClaimed, csrId) values (#newAcctNo#,#form.clientNumber#,#form.debtorNumber#,'#form.dateIncurred#','#form.dateAssigned#','#form.dateLastPayment#',#form.amountLastPayment#,#request.attyFee_actual#,#form.principal#,#form.preJudgementInt#,#countyId#,#form.principal#, #form.attyFeeClaimed#, #form.csrId#) select @@identity as newAcctId from accts select acctNo from accts where id = #getNewId.newAcctId# -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com "He who makes a beast of himself saves himself the pain of being a man..." --Hunter S. Thompson. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
