Hi use 'like' when the category contains a '%'
ie. event_category like <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#URL.category#"> and always try to use cfqueryparam - so people can't do stuff "<page>?category=3'' Drop table users" or something otherwise nasty Elliot "rob" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > <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
