select firstname
from tbl_whatever
where dateofbirth > #createodbcdate(now())#
order by dateofbirth DESC
i think this should do ya.... but if not, then it is something real
similiar...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
> -----Original Message-----
> From: Carlo van Wyk [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 7:35 AM
> To: CF-Talk
> 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
