Question
Code Help
Using mysql 5x with lastest coldfusion...any help or ideas is
appreciated...I think I've just looked at it too long.
Here's what I got:
<cfsilent><cfsetting enablecfoutputonly="yes">
<!--- The Calendar Parameters start --->
<cfparam name="url.m" default="#datepart("m", now())#">
<cfparam name="url.y" default="#datepart("yyyy", now())#">
<cfset dateob=CreateDate(URL.y,URL.m,1)>
<cfset ly = #url.y#>
<cfset ny = #url.y#>
<cfset daybuilder = arraynew(1)>
<cfloop index="c" from="1" to="#DaysInMonth(DateOb)#">
<cfset daybuilder[#c#]="no">
</cfloop>
<cfquery name="load_calendar" datasource="#request.dsn#">
SELECT blog_date,(day(blog_date)) AS getthisday
FROM blog_posts
WHERE (blog_date >= #CreateDate(Year(DateOb),Month(DateOb),1)#) and (blog_date <= #CreateDate(Year(DateOb),Month(DateOb),DaysInMonth(DateOb))#)
</cfquery>
<cfoutput query="load_calendar" group="blog_date">
<cfset daybuilder[#getthisday#]="yes">
</cfoutput>
<cfsetting enablecfoutputonly="no">
</cfsilent>
Here's my error:
SELECT blog_date,(day(blog_date)) AS getthisday
14 : FROM blog_posts
15 : WHERE (blog_date >= #CreateDate(Year(DateOb),Month(DateOb),1)#) and (blog_date <= #CreateDate(Year(DateOb),Month(DateOb),DaysInMonth(DateOb))#)
16 : </cfquery>
17 : <cfoutput query="load_calendar" group="blog_date">
--------------------------------------------------------------------------------
SQLSTATE 42000
SQL SELECT blog_date,(day(blog_date)) AS getthisday FROM blog_posts WHERE (blog_date >= {ts '2008-05-01 00:00:00'}) and (blog_date <= {ts '2008-05-31 00:00:00'})
VENDORERRORCODE 1064
Here's what I got:
<cfsilent><cfsetting enablecfoutputonly="yes">
<!--- The Calendar Parameters start --->
<cfparam name="url.m" default="#datepart("m", now())#">
<cfparam name="url.y" default="#datepart("yyyy", now())#">
<cfset dateob=CreateDate(URL.y,URL.m,1)>
<cfset ly = #url.y#>
<cfset ny = #url.y#>
<cfset daybuilder = arraynew(1)>
<cfloop index="c" from="1" to="#DaysInMonth(DateOb)#">
<cfset daybuilder[#c#]="no">
</cfloop>
<cfquery name="load_calendar" datasource="#request.dsn#">
SELECT blog_date,(day(blog_date)) AS getthisday
FROM blog_posts
WHERE (blog_date >= #CreateDate(Year(DateOb),Month(DateOb),1)#) and (blog_date <= #CreateDate(Year(DateOb),Month(DateOb),DaysInMonth(DateOb))#)
</cfquery>
<cfoutput query="load_calendar" group="blog_date">
<cfset daybuilder[#getthisday#]="yes">
</cfoutput>
<cfsetting enablecfoutputonly="no">
</cfsilent>
Here's my error:
SELECT blog_date,(day(blog_date)) AS getthisday
14 : FROM blog_posts
15 : WHERE (blog_date >= #CreateDate(Year(DateOb),Month(DateOb),1)#) and (blog_date <= #CreateDate(Year(DateOb),Month(DateOb),DaysInMonth(DateOb))#)
16 : </cfquery>
17 : <cfoutput query="load_calendar" group="blog_date">
--------------------------------------------------------------------------------
SQLSTATE 42000
SQL SELECT blog_date,(day(blog_date)) AS getthisday FROM blog_posts WHERE (blog_date >= {ts '2008-05-01 00:00:00'}) and (blog_date <= {ts '2008-05-31 00:00:00'})
VENDORERRORCODE 1064
