Re: [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>     ******

Mike Heins wrote:
> 
> ******    message to minivend-users from Mike Heins <mike@minivend.com>     ******
> >
> > I have not used [if-item-field] at all, only [item-field titel],
> > [item-field autor] and [item-field preis] to display the result.
> 
> Then use [item-param preis], you put it as a return field in your select.
> 
> By the way, I made a couple of optimizations based on your report.
> 
>         1. removed record existence test when there is only one products file,
>            making [item-field name] same as to [item-data ProductFiles->[0] name]
>            in effect.
>         2. fixed deficency where database_field called $db->record_exists
>            instead of $db->test_record
> 
> Both of those should greatly improve SQL performance.
> 
> But the real key is to return the fields in the select and use [item-param name].

I have made select field1, field2 ... from but MV has changed it to
select * from ....


> You can do this in MV searches as well:
> 
>         [area href=scan
>                         arg="
>                                 rf=sku,price,description
>                                 se=foo
>                                 sf=bar
>                         "
>         ]
> 

I shall try this, too.

My ultimate goal is to use JOIN, too. This would also greatly improve
performance. I have, however, not yet succeeded and gotten BAD SQL as a
result.

Thanks for your help and immediate response!
Chris
 

> --
> Mike Heins                          http://www.minivend.com/  ___
>                                     Internet Robotics        |_ _|____
> Any man who is under 30, and is     131 Willow Lane, Floor 2  | ||  _ \
> not liberal, has not heart; and     Oxford, OH  45056         | || |_) |
> any man who is over 30, and is not  <mikeh@minivend.com>     |___|  _ <
> a conservative, has not brains.     513.523.7621 FAX 7501        |_| \_\
>  -- Winston Churchill
> -
> 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
-
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