On Jan 21, 2008 7:29 AM, Michael Traher <[EMAIL PROTECTED]> wrote: > HI Kay, It looks to me like the select should be > > select scope_identity() as formatid from format > > i.e. the 'as' refers to the column rather than the table which is how I read > your sql.
Haha - all I can say is "d'oh!". The reason I was sure it was working before is that the FROM is not required at all - SELECT SCOPE_IDENTITY() AS FormatID works fine. Thanks for your sharp eyes! 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:296936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4