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
