[mv] MV4.0alpha11 mySQL stragnge behaviour

["Christian J. Müller" <cmueller@polinet.ch>]

******    message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch>     ******

Installation is MV4.0alpha11 on Linux SuSE 6.3 with mySQL 23.8 alpha.
I use the following query:
[page href=scan arg="st=db/sq=select code,isbn,titel,autor,verlag,preis
from products whrere suchkrit1='Architektur']architektur</A>
As an initial step, I use only three [item-field ...] tags in the
results page.
This query returns 93 results. The display of the [item-field field]
looks correct.
My mySQL log, however, shows some 400 queries (!!) as a result. The
entries are as follows:

24 Query	select * from products WHERE suchkrit1 = 'Architektur'  <-- my
query
24 Query	select * from products where code = '2038510'           <-- MV 
24 Query	select code from products where code = '2038510'
24 Query	select code from products where code = '2038510'
24 Query	select code from products where code = '2038510'
24 Query	select * from products where code = '2357615'
24 Query    	select code from products where code = '2357615'
24 Query	select code from products where code = '2357615'
24 Query	select code from products where code = '2357615'

and so on, four entries for each record found with the initial select
query.

MV is changing my field selection into "*" and seems to make a new
select for each result again! But not enough, there is one additional
select for each [item-field field] in the form of "select code from
products where code = ..." (doesn't make any sense at all!).

Is my query or my results handling wrong? Or is my interpretation of the
log not what it should be? Are these really individual MV queries?
Any help and/or clarification would be highly appreciated.
Chris
-
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