All pastes #465505 Raw Edit

Untitled

public text v1 · immutable
#465505 ·published 2007-04-30 11:59 UTC
rendered paste body
SELECT TerDoc, TerNom, TerTel1, TerTel2, TerFax, TerCel,
       TerEma, TerMsn, TerCid, TerEst, TerMsg, TerTip
FROM ter01
<dtml-sqlgroup where>
    <dtml-sqltest expr="'%'+nome+'%'" column="TerNom" op="like" type="string"> 
<dtml-or>
    <dtml-sqltest expr="'%'+texto+'%'" column="TerMsg" op="like" type="string">
<dtml-or>
    <dtml-sqltest expr="'%'+tipo+'%'" column="TerTip" op="like" type="string">
</dtml-sqlgroup>
ORDER BY TerDoc, TerNom