Oh no.. seems like no one had such an encounter before.... sigh...
----- Original Message ----- From: "han peng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 9:24 AM Subject: help! cant use multiple transaction > hihi... funny things happening... > this query works fine for past few days.. > but yesterday suddenly wanted to take a break... > anyone know wats the cause..?? > hmm.. i can insert the values successfully.. but cant retrieve the new > ID inserted.. > > Error msg saying this #INSERTNEWCUSTOMER.intCustomerID#> > not found. > > > > <CFQUERY NAME="INSERTNEWCUSTOMER" datasource="#application.DSN#"> > INSERT INTO tblCustomer > Values > ( > '#session.prospect.strTitle#', > '#session.prospect.strCustomerName#', > '#session.prospect.strStreetName#', > '#session.prospect.strFloorNumber#', > '#session.prospect.strUnitNumber#', > '#session.prospect.strBlockNumber#', > '#session.prospect.strBuildingName#', > '#session.prospect.strPostalName#', > '#session.prospect.strNRICNo#', > '#session.prospect.strHomeNo#', > '#session.prospect.strMobileNo#', > '#session.prospect.strPagerNo#', > '#session.prospect.strOfficeNo#', > '#session.prospect.strEmail#', > 'P', > '#session.prospect.strAddressType#', > NULL > ); > SELECT @@IDENTITY as intCustomerID; > SET nocount off; > </CFQUERY> > <CFSET session.prospect.intCustomerID = > #INSERTNEWCUSTOMER.intCustomerID#> > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
