hey people just one last question before friday nears to a end
date=#DateAdd("d", 1, URL.date)#this is doing what i want but when i do the query
<cfquery datasource="brokenhill" name="all_day_cal"> SELECT date, event_category, event_description FROM mlc_cal WHERE date = #URL.date# </cfquery>
it wouldn't deliever any records until 2004/5/5
when i realised this was the case
/index.cfm?date={ts%20'2004-05-01%2000:00:00'}i noticed if i switch the 05 and 01 round it works
eg
/index.cfm?date={ts%20'2004-01-05%2000:00:00'}if i throw as <cfset mysql_date #dateformat(URL.date, 'yyyy-mm-dd')#>
that don't work...
any ideas i am stuck
Robert Shaw Online Learning [EMAIL PROTECTED] MLC School Rowley Street Burwood 2134 Phone: 97471266 Mobile: 0422222515 Fax: 97453254
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
