[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: sql/scan searches
August Detlefsen
>
> ****** message to minivend-users from August Detlefsen <augustd@idiom.com> ******
>
> 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'"
If I use the double quotes like you suggest, the query received by my
mysql server reported in the log is
9 Query select code from products where 1 = 1
If I take the double quotes out, the log sez:
12 Query select code from products where code = '[area'
its mangling the query badly. It is only generating single-field
queries, asking for only code, eventhough I asked for
code,description, and name fields.
> I think you have to write the tag on multiple lines for it to be processed properly...
>
> For in-page searches try:
>
> [sql type=list query="select all * from foo where bar = 'joebob'" base=products]
> <HTML> and [minivend] tags
> [/sql]
>
> What I want to know is: Is there any way to FORCE these searches to be done on the SQL database and not on the ascii text file?
>
> -August
> --
> mailto:augustd@idiom.com
--
John Edstrom | edstrom @ slugo.hmsc.orst.edu
