its an internal app, that has no chance of mal intent and not to mention i havent spent a minute cleaning up the code i usually code cfqueryparams after i get EVERYTHING working... as its quicker for me to type everything in straight sql, then go back and make it cfqueryparammed up :)
and trimmin... who needs trimmin, it aint christmas! tw On Mon, 7 Mar 2005 23:59:31 -0500, dave <[EMAIL PROTECTED]> wrote: > 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:197773 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
