You could utilize the MIN function to return just the one record:
SELECT MIN(DateOfBirth) as NextBirthDay
FROM TableName
WHERE DateOfBirth > #CreateODBCDate(Now())#
HTH
Brian
----- Original Message -----
From: "Carlo van Wyk" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 6:34 AM
Subject: Event List
> I have a Staff Table in SQL with the following columns:
> FirstName, LastName, DateofBirth
>
> I would like Coldfusion to select the name of staffmembers birthday that
> will be next, and on which day it will be.
>
> How would one go about it?
> Perhaps there is an example on the web somewhere?
>
> Regards
> Carlo
>
> 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
