Basically what I would do (based on your db structure)
but why would you store the date as separate fields?
<cfset BeginDate = now()>
<cfset endDate = dateAdd("m",6,BeginDate)>
<cfquery name="oncall" datasource="rml_lab">
select month,day,year,who
from on_callmic
where (month >= #month(begindate)# and day >= #Day(begindate)# and year >=
#Year(begindate)#)
AND
(month <= #month(enddate)# and day <= #Day(enddate)# and year <=
#Year(enddate)#)
order by year, month, day
</cfquery>
-------------------------------------------------------------------->
<marquee scrollAmount=5 direction=left width=100% height=5
style="background-color:white;border:none">
<CFOUTPUT query="oncall">
<b>#Dateformat(CreateDate(year,month,day), "dddd - mmm/dd/yyyy")#
#who# is Manager in
Charge. </b></font></CFOUTPUT></marquee>
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 10:17 AM
To: CF-Talk
Subject: RE: Date Query problem.
CF doesn't deal with variables in this way. If you do <CFSET a =
DateFormat(now(),"dd")> then a is neither a string, number or date. CF
decides what type the variable is once you combine it with an operand For
example if you tried to do a mathematical function on it (say add it to
another number) then this would be fine. If you tried to concatenate it to
a string then this would also be ok.
-----Original Message-----
From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]]
Sent: 07 June 2001 15:32
To: CF-Talk
Subject: Re: Date Query problem.
......
<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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists