Erika, Can you make this process a stored procedure? If so you can make use of the @@identity variable in SQL Server. This will give you the unique index of the value that was just inserted, so you wouldn't have to requery the database at all.
I don't know if you can use this variable outside of a stored procedure (like in a regular cfquery block). On Jan 31, 2008 12:03 PM, Erika L. Walker <[EMAIL PROTECTED]> wrote: > got to be CF then .. because like I said, it's a simple select statement. > there's nothing to work on. > I'll go take a looksee in CFAdmin ... > > Thanks! > > On 1/31/08, William Bowen <[EMAIL PROTECTED]> wrote: > > > > Run your SQL in Query Analyzer and see if it times out. > > > > If it doesn't time out then the issue is probably a CF setting. If it > > does time out, then you'll need to work on the query a bit... > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Community/message.cfm/messageid:252829 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
