.
- 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
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.
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
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
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
5 matches
Mail list logo