um... I'd really watch out for a field called "date". in lots of cases (eg: particular db's) it's a reserved word
how about "event_date"? just a thought barry.b -----Original Message----- From: rob [mailto:[EMAIL PROTECTED] Sent: Thursday, 6 May 2004 10:04 AM To: CFAussie Mailing List Subject: [cfaussie] something to do with a where clause <cfparam default="%" name="URL.category"> <cfquery datasource="brokenhill" name="all_day_cal"> SELECT date, event_category, event_description FROM mlc_cal WHERE date = <cfqueryparam cfsqltype="CF_SQL_DATE" value="#URL.date#"> AND event_type = 'special' AND event_category = '#URL.category#' </cfquery> what am i doing wrong?? so if url.category is not defined give it a default of % that should give me all results right? i am using mysql in the back end thanks people 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
