Interchange Developer Resource
[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] one-click search with sql database



Hello i am trying to make a one-click search on my postgres db,
but its always the Sql Module of Jochen Friedman which trys to process the query instead of 
sending the sql statement directly to my sql database

i tried it this way :
<a href="[area scan ml=25/st=sql/tf=artist/sq=SELECT * from products where artist ilike 'a%'/
sp=catalog]">A</a>

can someone tell my how to do it correctly ?

Cheers,
Karsten Fuhrmann


______________________________________________________________________________
Die clevere Geldreserve: der DiBa-Privatkredit. Funktioniert wie ein Dispo, 
ist aber viel gunstiger! Alle Infos: http://diba.web.de/?mc=021104



Search for: Sort by: