Coordinated search - two problems

[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