> Hi all...I have a stored procedure that works. I have > modified it so it back the identity of the column I just > inserted. Unfortunately, I keep getting an undefined error > with my variable. newident is the variable name. > > ... > > SET @newident = @@IDENTITY; > GO > > ... > > <cfprocparam type="Out" cfsqltype="CF_SQL_NUMERIC" > variable="newident" null="yes"> > > ... > > record number is #newindent#
Are you sure it's not just a typo? The output block says "newindent". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
