[ic] search-region/query conflict?

Thomas J.M. Burton tom at globalfocusdm.com
Thu Jun 17 16:43:00 EDT 2004

Joachim Schubert wrote:

> Thomas J.M. Burton wrote:
>>Hi IC Users,
>>I have the following query and perl code (work in progress) in a file 
>>that I'm including in my page template regions. The perl code is 
>>executed completely in all pages except results.html.
>>As far as I can tell, there's some kind of conflict between the 
>>query/perl and the search-region in the results page. If I include the 
>>code at the bottom of the page (after the search-region tags), it works. 
>>But it breaks if included at the top (before the search-region tags) 
>>where it needs to be in order to do what I want it to do.
>>Any ideas? Any other improvements to the perl code are welcome too.
>>IC v5.0
>>Default DB
>>[query arrayref="discountref" sql="SELECT * FROM promotions
>>                 ORDER BY type,active_month"][/query]
> Try insert in the query-tag: 'table=promotions'
>>From the docs:
> ---------------
> table
> The table attribute sets the database to use for the query. 
> The default will typically be the database containing the 'products' table 
> (unless you have changed the first entry in $Vend::Cfg->{ProductFiles}).
> ---------------
> Regards
> Achim

Tried adding table="promotions" to the query tag, didn't work. Meant to 
mention in my original post that in the results page, the promotions 
query only returns two results when it should be returning more than 
that (and does so in all other pages).

Any other suggestions?


Thomas J.M. Burton
Design & Production Director
Global Focus Digital Media, LLC

More information about the interchange-users mailing list