do a check before outputting the data:
cfif results.recordcount
your current code
cfelse
Sorry - no records found matching xxxxx
/cfif
----- Original Message -----
From: "David Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 07, 2000 4:11 PM
> 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
>
> ----------------------------------------------
>
> <!--RowBreak is number of columns per row--->
> <CFSET RowBreak = 3>
>
> <TABLE BORDER=0 CELLPADDING=5 CELLSPACING=0 WIDTH="98%">
> <TR>
> <CFOUTPUT QUERY = "results">
>
> <CFSET ModValue = results.CurrentRow MOD RowBreak>
> <TD WIDTH="25%" ALIGN=center>
>
>
> <A HREF="stone.cfm?ID=#ID#"><img src = "#smallimage#"
> border = "0"></A><BR>
>
> <A HREF="stone.cfm?ID=#ID#">#name#</A><BR>
>
> <CFIF #ceramicseries# IS "NOT CERAMIC">
> <CFELSE>#ceramicseries#<BR>
> </CFIF>
>
> <CFIF #material# IS "Ceramic Tiles">
> <CFELSE> #material#<BR>
> </CFIF>
> #finish#
>
>
>
>
> </TD>
>
> <CFIF ModValue IS 0>
> </TR><TR>
> <CFELSE>
> </CFIF>
>
> </CFOUTPUT>
> </TR>
> </TABLE>
>
> --------------------------------------------
> David Ryan - Minister of Information and Culture
> CRUMBLING EMPIRE PRODUCTIONS
> 134 W.26th St. 12th Floor
> New York, NY 10001
> (212) 247-0296
> --------------------------------------------------------------------------
----
> 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.
------------------------------------------------------------------------------
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.
