AH.... the AS part was holding me up!
Thanks! I didnt see anything about AS in my SQL books...
Maybe someone needs to write a book about databases command structure for
CF.. :)
At 05:37 PM 11/29/00 -0500, you wrote:
>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
