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>     ******
> 
> Then use [item-param preis], you put it as a return field in your select.

I have just tried the [item-param field] tag, but it returns a different
value than [item-field field].
[item-field field]returns the correct value, whereas [item-param field]
returns the value of the code of the record.
I have included the field in the select statement.

Chris
> 
> 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].
> You can do this in MV searches as well:
> 
>         [area href=scan
>                         arg="
>                                 rf=sku,price,description
>                                 se=foo
>                                 sf=bar
>                         "
>         ]
> 
> --
> 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