What database is it? SQL/Access/MySQL?
-----Original Message-----
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: 04 June 2004 16:34
To: CF-Talk
Subject: Datebase Question!
Database question.
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]
- Datebase Question! cf coder
- RE: Datebase Question! Philip Arnold
- Re: Datebase Question! John Beynon
- Re: Datebase Question! cf coder
- Re: Datebase Question! Mark Drew
- Re: Datebase Question! cf coder