Re: [mv] Search differences

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Stefan Hornburg (racke@linuxia.de):
 > > 
> > > Looking into the code Vend::More_in_progress is reset to undef
> > > on the first invocation.
> > > 
> > > Any hints ?
> > 
> > This is a case of having the products database not in SQL, but the 
> > target table in SQL.
> > 
> > In that case, you need to say [query base=table_that_is_sql sql="...."]
> > so the SQL is not touched by SQL::Statement.
> 
> Probably I've described my problem not properly. The [query is working
> (all relevant databases in this case are SQL) and the sql code within
> [query isn't touched by SQL::Statement.
> 
> My problem with [query is, that in the second, third ... call to query
> the "more" state is forgotten, so there comes the results of the
> first page in.
> 
> I think if have to code it in [perl to avoid this traps.

Oops, *I* was the one who read this wrong. I knew I stuck it in my
todo-list folder for some reason. 8-}

I will be looking at this one -- it is hard to do and keep state
for all of the lists, but I don't see that it is impossible. Quite
possibly, we will have to assign a label to each search and keep
a has of $More_in_progress variables.

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.8220 fax 7501 <heins@akopia.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list