You prefix it with the name of your query... So if you have <cfquery name="newrecord" datasource="blah">
You can do: #newrecord.ident# HTH, K. "Koo Pai Lao" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > hey guys, I have inserted a record into a table, > and did the SELECT @@identity as Ident thing. the thing is > > how do I display it on the page? i did a #ident# but coldfusion > doesn't > recognize the variable. the reason I am doing this is because I dont want > to have to do another query just to get the latest ID. is it just possible > to get it right after the insert and pass it to coldfusion? PLEASE HELP! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
