Typeless huh!
Intersting
----- Original Message -----
From: Andy Ewings <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 5:17 PM
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