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#>
______________________________________________________________________
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=coldfusiona
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
