....
<CFSET a = DateFormat(now(),"dd")>
....
is variable 'a' a date or a number now?
Why dont u add to the date first and then get the day afterwards
----- Original Message -----
From: Schwartz, Paul <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 6:03 PM
Subject: Date Query problem.
> I have a query of a database that I am doing so that it shows the
> results for the next seven days.
> this script works up until the end of the month. when it just adds on
> to the end of the month.
> for example. may 27,28,29,30,31,32,33 instead of changing to the next
> month and starting over again at the next month. any Ideas would be
> helpful.
>
>
> database table format
> month,day,name
>
>
> thanks,
>
> <!---code for showing Oncall personel for the next seven
> days-----------
> <CFSET thismonth = DateFormat(now(),"mm")>
> <CFSET a = DateFormat(now(),"dd")>
> <cfset b = #a# + 1>
> <cfset c = #b# + 1>
> <cfset d = #c# + 1>
> <cfset e = #d# + 1>
> <cfset f = #e# + 1>
> <cfset g = #f# + 1>
> <cfquery name="oncall" datasource="rml_lab">
> select month,day,year,who
> from on_callmic
> where month = #thismonth# and day = #A# OR
> month = #thismonth# and day = #B# OR
> month = #thismonth# and day = #C# OR
> month = #thismonth# and day = #D# OR
> month = #thismonth# and day = #E# OR
> month = #thismonth# and day = #F# or
> month = #thismonth# and day = #g#
> order by month
> </cfquery>
> -------------------------------------------------------------------->
> <marquee scrollAmount=5 direction=left width=100% height=5
> style="background-color:white;border:none">
> <CFOUTPUT query="oncall"><cfset td1 = #oncall.month# & "/" &
> #oncall.day# & "/" & #oncall.year#><font face="Arial" size="2"><b> on
> #Dateformat(td1, "dddd - mmm/dd/yyyy")# #who# is Manager in
> Charge. </b></font></CFOUTPUT></marquee>
>
>
> Paul Schwartz
> Information Systems Technician / Webmaster
> Regional Medical Lab
> mailto:[EMAIL PROTECTED]
>
> 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
