[ic] [more] / [more-list] Alpha Numeric

Brian Kosick interchange-users@interchange.redhat.com
Tue Oct 9 16:51:00 2001


<snip>

At 09:27 PM 10/9/01 +0200, you wrote:

>I think no one tried it yet and you definitely found a bug. A first
>fix to Interpolate.pm which should work with the above query:
>
>diff -u -r2.9.2.2 -r2.9.2.3
>--- Interpolate.pm      2001/10/07 12:56:32     2.9.2.2
>+++ Interpolate.pm      2001/10/09 19:23:36     2.9.2.3
>@@ -5327,6 +5327,11 @@
>         if($opt->{ma}) {
>                 # Find the sort field and alpha options....
>                 Vend::Scan::parse_profile_ref($object, $opt);
>+               # Contents of mv_return_fields must be of the same type
>+               # (numeric here) as the contents of mv_sort_field
>+               @{$object->{mv_return_fields}} = map {$nh->{$_}} 
>@{$object->{mv_return_fields}};
>+               # We need to turn the hash reference into a search object
>+               $object = new Vend::Search (%$object);
>                 # Delete this so it will meet conditions for creating a more
>                 delete $object->{mv_matchlimit};
>         }
>
>But don't nail me on this. We have to take to look closer at it,
>anyway.
>
>Ciao
>         Racke
>
>--
<snip>

Racke,
The patch applied fine, and doesn't appear to have a adverse affect on the 
rest of the site.

Here's my code:
[query list=1 ml=50 more=1 st=db ma=yes mc=1 
rf=p.code,p.name,p.short_desc,p.price,p.qty,p.new_plant,p.disc tf=p.name sql=|
         SELECT p.code, p.name, p.short_desc,
         p.price, p.qty, p.new_plant, p.avail,
         p.disc, z.zone
         FROM products AS p, zip_zone AS z
         WHERE z.zip = '[value search_zip]'
         AND p.zones ~ z.zone
         AND p.disc != '0'
         ORDER BY p.name;
         |
]

I've tried putting the rf values in double quotes and single quotes, I've 
added and removed the "p."

I displays the Alpha more list now, however the search returns an empty set.
No errors in the logs though.

I will create a simpler query, and get back to you/the list my results.