The % wildcard needs like, rather than = Maybe try
<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 like '#URL.category#%' </cfquery> ----- Original Message ----- From: "rob" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, May 06, 2004 10:03 AM 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
