urlEncodedFormat() the date variable when adding it to the link ??
or in the query <cfqueryparam cfsqltype="CF_SQL_DATE" value="#URL.date#"> ?? cheers barry.b -----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
