thanks guys
On 06/05/2004, at 10:07 AM, Phil Evans wrote:
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
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
