Sorry for the late reply. Just got back from lunch.
I've made the change to BeginDate in your code as an
example. You'll have to do the same thing to your
other dates
> <cfset MonthsToDisplay = 2>
> <cfset BeginDate = "#Month(now())#/1/#Year(now())#">
<cfset BeginDate =
CreateDate(Year(now()),Month(now()),1)>
> <cfset EndDate = "#Month(DateAdd("m",
> MonthsToDisplay,now()))#/#DaysInMonth(DateAdd("m",
> MonthsToDisplay,now()))#/#Year(DateAdd("m",
> MonthsToDisplay, now()))#">
>
> <cfquery name="getupcomingevents"
> datasource="events">
> SELECT eventid, eventdate, to_char(eventdate,'YYYY')
> AS eventYear, to_char(eventdate,'MM') AS eventMonth,
> longtitle, location
> FROM whatson
> WHERE eventdate BETWEEN
#CreateODBCDate(BeginDate)# AND
> trunc(#CreateODBCDate(EndDate)#)
> ORDER BY eventdate asc
> </cfquery>
--- [EMAIL PROTECTED] wrote:
> Do you have a code example of the process you have
> just specified?
>
=====
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
