First of all it looks strange to have a assign condition in
the SELECT part of the query, e.g "ID = max(ID)".
You might like to do it this way instead:
SELECT ID,Date,TimeIn,TimeOut,StationIP
FROM Clocks
WHERE ID = (
SELECT MAX(ID)
FROM Clocks)
-Original Message-
From: Gene
should be something like :
select max(is) as id, ...
- Original Message -
From: "GeneralX" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 11:46 PM
Subject: [PHP-WIN] ODBC Query max()
> I'm trying to extract one record that has largest sequence ID number for
a
