David
ahhh, your crafty ploy of posting without a subject has sparked my
curiosity and forced me to read your message! ;)
If you are concerned about your query not returning any records - resulting
in an empty table - do something like the following:
<cfif results.recordcount GT 0>
---do all your table stuff here ---
<cfelse>
Sorry, your search returned no records...etc.etc.
</cfif>
A couple extra notes - added at no extra cost to the consumer:
-You don't need #'s in your CFIF's
Example: <cfif CeramicSeries IS "NOT CERAMIC">...
-You can use NOT within a CFIF to reverse the test and avoid a CFELSE
Example: <cfif NOT material IS "Ceramic Tiles">
#material#
</cfif>
hth,
Kevin
At 04:11 PM 4/7/00 -0400, you wrote:
>Fellow CF scriptors --
>
>I am using the following code to "pour" search query results into a
>three column layout.
>
>I can't for the life of me figure out how to deliver a "no matching
>items found" when there are no matching items found.
>
>I've tried IFs and SWITCHES and others, but it's no use.
>
>What I am missing?
>
>TIA,
>
>David
snip
>--------------------------------------------
>David Ryan - Minister of Information and Culture
>CRUMBLING EMPIRE PRODUCTIONS
>134 W.26th St. 12th Floor
>New York, NY 10001
>(212) 247-0296
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
