Re: sql/scan searches

[August Detlefsen <augustd@idiom.com>]

I never got this to work:

> no joy
> 
> sample query: "[area scan st=sql
>   sql="select code,description,name from products where category='2'"
> 

Instead I took a different tack and did: 

[comment]One-click search[/comment]
[page form="
      searchterms=[sql_param 0]
      mv_doit=return
      mv_nextpage=sqlresults"][sql_param 0]</A>
[comment][sql_param 0] is a result from a previous SQL search[/comment]


On the results page there is this code:

[comment]uppercase everything for a case-insensitive search[/comment]
[value name=searchtermsuc set='[upper][value searchterms][/upper]' interpolate=1
hide=0]

[sql type=list query="select all * from localization where UPPER(description) like '%[value searchtermsuc
]%' or UPPER(part) like '%[value searchtermsuc]%' or UPPER(category) like '%[value searchtermsuc]%' or UP
PER(comment) like '%[value searchtermsuc]%' order by [scratch resultsort]" base=localization]

<RESULTS HTML> and [minivend] tags

[/sql]

BTW: Can we write our sql statements on multiple lines? The above is kinda hard to read?

-August
--
 mailto:augustd@idiom.com