[Zope] (no subject)

[Joachim Schmitz]

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