why not try sorting by dayofyear?
e.g.:
WHERE datepart('dy', dateofbirth) > #dayofyear(now())#
Haven't tested, so am not sure how the order by would work, but this should
give you the recordset you're looking for.
HTH
D
-----Original Message-----
From: Carlo van Wyk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 9:32 AM
To: CF-Talk
Subject: RE: Event List
I have adjusted my code, but the output I get is not as desired. It sorts
the people by year instead of sorting them just by dd/mm.
I also don't want to display the whole list of birthdays after today, I just
want to display the next or upcoming 2 birthdays after today.
Like for instance:
Michael Smith - Fri 01 Apr 1955
Carlo van Wyk - Tue 19 Apr 1966
Remington Steele - Sat 02 Feb 1974
Jean Durand - Tue 19 Apr 1977
instead of:
Michael Smith - Fri 01 Apr 1955
Jean Durand - Tue 19 Apr 1977
herewith my code:
<cfquery name="test" datasource="trams_local" dbtype="ODBC">
select *
from BirthDay
where dateofbirth > #dateformat(now(), "DD/MM")#
order by dateofbirth ASC
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Date of Birth</title>
</head>
<body>
<cfoutput query="test">
#FirstName# #LastName# - #dateformat(DateofBirth, "DDD DD MMM YYYY")# <br>
</cfoutput>
</body>
</html>
-----Original Message-----
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:20 PM
To: CF-Talk
Subject: RE: Event List
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
