so, in one cfquery tag you'd have
<cfquery name="foo">
INSERT INTO table
(col1, col2)
VALUES
(val1, val2);
SELECT SCOPE_IDENTITY() as ID;
</cfquery>
Then foo.id has your last inserted id.
DK
On 10/4/06, Jeff Howard <[EMAIL PROTECTED]> wrote:
So I got access to the CF Admin this morning and between that and Profiler I can see what is causing my issue and can resolve. Thanks for everyone's help once again. It was a comination of advice that got me to this point.Now I was wondering if anyone could tell me why this issue is happening to try and avoid/combat it in the future.When I add a new record to the db I immediately pull that id back out with this query:SET ROWCOUNT 1
SELECT id
FROM table
ORDER BY id DESCThis seems to set the rowcount for ALL queries after this one. When I uncheck "Maintain connections across client requests" it works fine, but as long as the box is checked the 'rowcount' remains one for all requests to this db.Can anyone give a brief explaination of the 'why' for me on this.thanks for all the help,Jeff
Stay in the know. Pulse on the new Yahoo.com. Check it out.
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------