<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
