Re: sql/scan searches

[mikeh@minivend.com]

Quoting John Edstrom (edstrom@Poopsie.hmsc.orst.edu):
> > For one-click searches, I've used:
> > 
> > [page scan st=sql
> >            sq="select all * from foo where bar = 'joebob'"
> > ]
> > 
> 
> no joy
> 
> sample query: "[area scan st=sql
>   sql="select code,description,name from products where category='2'"
> 

This is the same thing that was discussed a week or two back -- it
IS documented, though perhaps not well.

    [area href=scan 
          arg="
              st=sql
              sq=select code,description,name from products where category='2'
          "]

Once again -- you cannot mix positional and named/quoted parameters in
the same tag.  I think the original failed because of () in the positional
stuff, which is not allowed.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
In character, in manners, in        131 Willow Lane, Floor 2  | ||  _ \
style, in all things, the           Oxford, OH  45056         | || |_) |
supreme excellence is               <mikeh@minivend.com>     |___|  _ <
simplicity. -- Longfellow           513.523.7621 FAX 7501        |_| \_\