[Zope] SQL LIKE

[J C Lawrence]

On Wed, 12 Jan 2000 15:28:30 GMT 
cesare  <cesare@planningsrl.it> wrote:

> 1) I use sqlgroup but I can use it just with the = and not with
> the LIKE statement select * from annunci <dtml-sqlgroup where>
> <dtml-sqltest Parola column=testo type=string optional>
> </dtml-sqlgroup>

Read the "ZSQL MEthods User's Guide" and look in the back at the
"op=XXX" support in dtml-sqlquery.  You can use "op=LIKE" per that
doc.

> 2) I am not able to divide the words in more conditions. I would
> like the following result: select * from annunci where testo LIKE
> "%FirstWord%" and testo LIKE "%SecondWord%"

Again, see the above doc, and look at the examples using
dtml-sqlgroup, dtml-and, and dtml-or.  They show you how to do what
you want.

-- 
J C Lawrence                                 Home: claw@kanga.nu
----------(*)                              Other: coder@kanga.nu
--=| A man is as sane as he is dangerous to his environment |=--