Logs shows the error on this line
<cfset nb_keys_list = ListSort(StructKeyList(res_struct),"numeric") />
if i change numeric to "Text" the page loads.if i use numeric i get
this error.
Data not supported: Cannot convert to number ({ts '2010-07-29
00:00:00'}).
lines from the code that uses the date functions are as follows
<cfif survey_info.su_type IS "survey" AND
DateCompare(survey_info.su_opendate,Now(),"d") GT 0>
<cfelseif survey_info.su_type IS "survey" AND
DateCompare(survey_info.su_opendate,Now(),"d") LTE 0 AND
DateCompare(survey_info.su_closedate,Now(),"d") GTE 0>
<br /><strong>Open Date: </strong>
#DateFormat(survey_info.su_opendate, "mmmm d, yyyy")#
<br /><strong>Close Date: </strong>
#DateFormat(survey_info.su_closedate, "mmmm d, yyyy")#
<br /><strong>First Submission: </strong>
#DateFormat(survey_info.first_submit,"mmmm d, yyyy")# at
#TimeFormat(survey_info.first_submit,"hh:mm tt")#
<br /><strong>Last Submission: </strong>
#DateFormat(survey_info.last_submit,"mmmm d, yyyy")# at
#TimeFormat(survey_info.last_submit,"hh:mm tt")#
<!--- code to get Date value
--->
SELECT
DISTINCT res_date,
(SELECT COUNT(r2.res_id) FROM responses AS r2 WHERE
r2.res_date = r1.res_date AND r2.res_qu_id = r1.res_qu_id)
total_number
ORDER BY res_date
<cfset highest_date= 0
/>
<cfset temp =
structInsert(res_struct, res_date,
total_number) />
<cfif res_date
GT highest_date><cfset highest_date = res_date /
></cfif>
<cfchartdata item="#DateFormat(key,"mm-dd-yyyy")#"
value="#res_struct[key]#" />
#TimeFormat(usr_created, "h:mm tt")#,
#DateFormat(usr_created, "mmm d, yyyy")#
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
