I usually handle this type of situation in the <cfoutput>, not in the query.
Like this:
<CFOUTPUT query="GetResults">
<cfif Event is not "">
...output records...
<cfif>
</cfoutput>
This way I do a simple query, then filter out the records that have an empty
or NULL value in a field, in this case the Event field.
Eric Davis
Webmaster, Worthington Public Library
820 High St.
Worthington, Ohio 43085
E-mail: [EMAIL PROTECTED]
WWW: http://www.worthingtonlibraries.org
<http://www.worthingtonlibraries.org/>
Phone: 614-645-2620 Ext. 236
Fax: 614-645-2629
-----Original Message-----
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Friday, September 26, 2003 3:52 PM
To: CF-Talk
Subject: OT: SQL Question
I know this is a little off list but I'm stumped, so if some guru out
there could please give me a hand...
I've got two tables, tblDates and tblEnt. tblEnt uses the intDateID
field of tblDates. I am trying to pull the next 7 days where there is
entertainment scheduled. tblEnt has a row for each day, but each day
does not necessarily have entertainment. How can I go about this? It's
easy when everyday has entertainment, but when there are one or two
"dark" days it get's confusing. Any help is greatly appreciated.
Cutter
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
