I have a insert statment. I'm inserting a new record
in the table. The table has a primary key (empID)
Here is the code
<cftransaction action=""> <cfquery name="addNewEmp" datasource="db">
INSERT INTO ASSETS
(
empName,
empDesk,
empAsset
)
VALUES
(
'blog',
'1,
'ast10'
)
</cfquery>
</cftransaction>
I want to retreive the primary key (empID) value
immediately after this statement. I tried this:
<cfoutput>#addNewEmp.empID#</cfoutput> but get an
error msg
"Element empID is undefined in addNewEmp
Can somebody please help
Best Regards,
cfcoder
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
