[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.
>>
>>USING
>>IC v5.0
>>Default DB
>>
>>
>>CODE IN INCLUDED FILE:
>>
>>[query arrayref="discountref" sql="SELECT * FROM promotions
>> ORDER BY type,active_month"][/query]
>
> Try insert in the query-tag: 'table=promotions'
>
>>From the docs:
> ---------------
> 4.57.2.4. 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?
Thanks,
Tom
________________________________________
Thomas J.M. Burton
Design & Production Director
Global Focus Digital Media, LLC
www.globalfocusdm.com
More information about the interchange-users
mailing list