odbcDateFormat() odbcDateTimeFormat() ??
-----Original Message-----
From: rob [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 April 2004 2:25 PM
To: CFAussie Mailing List
Subject: [cfaussie] dateadd mysql and the flu!!!
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
---
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
