[ic] [no-match] is not returned when using [query sql ...]

Aaron Hazelton interchange-users@icdevgroup.org
Thu Sep 5 12:59:01 2002


Bill Carr wrote:
> 
> On Thu, 2002-09-05 at 12:17, Aaron Hazelton wrote:
> > Hi All,
> > 
> > On IC 4.8.6 has anyone else seen this:  when using regular 
> > results pages, you get the [on-match] , [no-match] just fine.
> > But, when using the [query] tag (which is soooooo much
> > faster) the [no-match] doesn't work.  all you get is a blank
> > content on the page.  the results return just fine if there are
> > matches.  I checked all of the obvious and the same exact
> > no-match code shows up on regular results pages??
> > oh, and the mysql version is 3.23.52
> > 
> > any ideas??
> Wild guess: Something to do with list=1 in query param or 
> [list][/list]
> in query container.
> 

thought I would add the code, just in case....

>  
> -- 
> Bill Carr
> Worldwide Impact
> bill@worldwideimpact.com
> 413-253-6700
> 
===========================
[query sql="SELECT sku, title, price, description
			FROM products
			WHERE description
			LIKE '%[value mv_searchspec]%';"
	type=list
	more=1
	ml=10]

[on_match]
<heading bar stuff>
[list]
< [sql param stuff] >
[/list]
[/on_match]

[no-match]
<no match stuff>
[/no-match]

[more-list]
<the more list works too>
[/more-list]

[/query]
===============================
thanks again,
Aaron