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
