[prev in list] [next in list] [prev in thread] [next in thread] 

List:       zope
Subject:    [Zope] (no subject)
From:       Joachim Schmitz perry () ac-copy ! net
Date:       1999-06-30 19:34:25
[Download RAW message or body]

Hi,

I'm using this for example:

SELECT * FROM ADRESSEN WHERE
       vorname LIKE <!--#sqlvar expr="vorname + '%'" type=string -->
       AND name LIKE <!--#sqlvar expr="name + '%'" type=string -->
   AND organisation LIKE <!--#sqlvar expr="organisation + '%'" type=string
-->
       AND strasse LIKE <!--#sqlvar expr="strasse + '%'" type=string -->
       AND plz LIKE <!--#sqlvar expr="plz + '%'" type=string -->
       AND ort LIKE <!--#sqlvar expr="ort + '%'" type=string -->
       AND tel LIKE <!--#sqlvar expr="tel + '%'" type=string -->
       AND fax LIKE <!--#sqlvar expr="fax + '%'" type=string -->
       ORDER BY <!--#sqlvar sortier type=string --> 


On 30 Jun 1999, CURTIS David wrote:

> Friends of Zope,
> I am a newbie who wants to know how to search for for data on a MySQL database \
> using the SQL LIKE command.  I used the  tutorial and found it helpful but It show \
> how to search for exact matches only.  I suppose this is easily done, Any ideas? 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
> 
> (For developer-specific issues, use the companion list,
> zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
> 

Gruß

Joachim Schmitz

WWW-Consultant

email: js@ac-copy.net
tel: +49-241-89491-0
fax: +49-241-89491-29


[prev in list] [next in list] [prev in thread] [next in thread]