On Jan 21, 2008 8:27 AM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > So it is actually returning multiples? And MSDN gave you that as the > example... heh... that's kinda funny. It's been a little while since I > worked with scope_identity() -- at my day job currently we're using > mostly MS variety of GUID values.
The example that actually works - without my stuff-up putting the alias after the FROM cause - was from MSDN, yeah. > Also if you're using CF8, you might also want to consider switching to > using CF for your identity values instead of doubling up your query Unfortunately this one's CF7, although I have used CF8's return structure on another project. In fact I was so excited I blogged about it, lol: http://kay.smoljak.com/index.php/yet-another-example-of-how-coldfusion-makes-coders-lives-easier/ Cheers for your help Isaac. K. -- Kay Smoljak business: www.cleverstarfish.com standards: kay.zombiecoder.com coldfusion: kay.smoljak.com personal: goatlady.wordpress.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
