Re: [mv] Coordinated search - two problems - Update: fixed [more] problem

[Randy Moore <ramoore@axion-it.net>]

Hello again,

Sorry to follow up my own post, but I found a work around the to the second 
problem I talk about below.

Using [scratch] variables in my coordinated search definition was causing 
problems for the [more] tag.  I used the [substitute] tag to replace these, 
and that fixed the problem.

I have no idea why the [scratch] variables caused a problem.

BUT, I still haven't been able to get two numeric checks on the same field 
to work.  Either one or the other works just fine, but when I put in both, 
the second check is ignored.

Does anyone have an example of a coordinated search that tests a numeric 
range (that works<grin>)?

Or, is this known to not work? Should I give up on this method and move 
these tables to an SQL server and use real SQL queries?

FYI, I'm using Minivend 3.14-3 on a Linux RedHat 6.0 machine.

My search now looks like:

[substitute name="CUSTCODE" value="[scratch customer_code]"]
[substitute name="START" value="[scratch start_time]"]
[substitute name="STOP"  value="[scratch stop_time]"]

<TABLE BORDER=1>
[search-region arg="
                 ml=4
                 sp=manage/custorders.html
                 co=yes
                 tf=code
                 fi=Orders.txt
                 sf=customer_code
                 sf=time
                 sf=time
                 se=~~CUSTCODE~~
                 se=~~START~~
                 se=~~STOP~~
                 op=rm
                 op=gt
                 op=lt
                 nu=no
                 nu=yes
                 nu=yes
           "]
[/substitute]
[/substitute]
[/substitute]

Thanks for any suggestions.

At 12/13/99 06:28 PM , you wrote:

>******    message to minivend-users from Randy Moore 
><ramoore@axion-it.net>     ******
>
>Hello,
>
>I'm trying to do an in-page coordinated search and I can't seem to get it 
>write.
>
>Here is the SQL version of the search I'd like (just for reference):
>SELECT code FROM orders
>WHERE customer_code='[scratch customer_code]' AND
>time > [scratch start_time] AND time < [scratch stop_time]
>
>I'm NOT really using an SQL server, just the GDBM database.
>
> From reading the list archives, I see that I can't use ranges with 
> coordinated searches:
>http://www.minivend.com/minivend/minivend-list/1999/msg00438.html
>
>So, following Mike's first example in thmessage referenced above, here is 
>my search code:
>
>[search-region arg="
>                 ml=4
>                 sp=manage/custorders.html
>                 co=yes
>                 fi=Orders.txt
>                 sf=customer_code
>                 sf=time
>                 sf=time
>                 se=[scratch customer_code]
>                 se=[scratch start_time]
>                 se=[scratch stop_time]
>                 op=rm
>                 op=>
>                 op=<
>                 nu=no
>                 nu=yes
>                 nu=yes
>           "]
>
>[more-list][more][/more-list]
><TR><TH>Order Number</TH><TH>Date</TH><TH>Amount</TH><TH>time</TH></TR>
>[search-list]
>
>{{{Display a table here}}}
>
>[/search-list]
>     [no-match]
>         Sorry, no orders found for [scratch customer_code]. <P>
>     [/no-match]
>[/search-region]
>
>The scratch variables are all being set correctly, and I DO have all the 
>field names correct (they do exist in my Orders.txt file).
>
>
>It almost works, but I have two problems with this code:
>
>1) the second test on the 'time' field is ignored completely, but the 
>first works.
>
>2) the [more-list][more][/more-list] feature works, except that on all 
>results pages (other than the first), a part of the search specification 
>appears on the resulting HTML page (ie, se=1 se=2145934801 op=rm op=> op=< 
>nu=no nu=yes nu=yes "]  ) .  It is always everything after the first 'se='.
>
>Any suggestions for getting this to work would be much appreciated.  I've 
>tried every variation on this I can think of.
>
>Thanks,
>
>Randy Moore
>Axion Information Technologies, Inc.
>
>email     ramoore@axion-it.net
>phone   301-408-1200
>fax        301-445-3947
>-
>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

Randy Moore
Axion Information Technologies, Inc.

email     ramoore@axion-it.net
phone   301-408-1200
fax        301-445-3947