Or
<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'
<cfif isdefined("URL.category")>
AND event_category = '#URL.category#'
</cfif>
</cfquery>
----- Original Message -----
From: "Phil Evans" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 10:07 AM
Subject: [cfaussie] Re: something to do with a where clause
> 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
>
---
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
