Re: Last row inserted

2001-04-18 Thread Gene Kraybill
. - Original Message - From: "Joshua Tipton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:34 AM Subject: Last row inserted I know this has been asked a million times but what is the best way to pull the id of the row last in

Re: Last row inserted

2001-04-17 Thread Michael Lugassy
If u'r using CF (and that's the forum, right?) AND YOU HAVE a colum where you put the date of each INSERT just use this: cfquery name="x" datasource="y" MAXROWS="1" SELECT colum from table ORDER by columthatholds_date DESC/cfquery If u'r not holding the date of the insert, the MAX idea is good.

Last row inserted

2001-04-16 Thread Joshua Tipton
I know this has been asked a million times but what is the best way to pull the id of the row last inserted. Isnt select (column name)MAX as (whatever)? ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: Last row inserted

2001-04-16 Thread Howie Hamlin
configurable mail server - Original Message - From: "Joshua Tipton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:34 AM Subject: Last row inserted I know this has been asked a million times but what is the best way to pull th

Re: Last row inserted

2001-04-16 Thread Kevin Mansel
SELECT MAX(Row) AS MaxRecord WHERE MaxRecord = @@IDENTITY i believe that is the correct syntax beat me over the head if i'm wrong :P kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at