On 11/29/00, Chad Gray penned:
>
>I would like to get all the data with a value of 1234 in the field
>JobNum. Once i collect these records i would like to get the Record with
>the highest ACTLOGID value.
>
>Can you do a :
>
>SELECT max(ACTLOGID), JobNum
>FROM activitylog
>Where Jobnum='1234'
Absolutely, except you need to use AS.
SELECT max(ACTLOGID) AS something, JobNum
FROM activitylog
Where Jobnum='1234'
Then, ACTLOGID would be called as #queryname.something#
Note: Remove the quotes if Jobnum is a number field.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
