[Zope-DB] Please help me about driver adapter

garry saddington garry at schoolteachers.co.uk
Fri Feb 16 02:57:37 EST 2007


On Fri, 2007-02-16 at 07:38 +0100, robert rottermann wrote:
> I do not think any one of us can help you unless you tell us what
> exactly your problem with installing pymssql ist.
> by the way: do you mean MySQLdb?
> 
> there is very good  documentation on using Z SQL in the zope book:
> http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
> 
> there you find examples how to use a query with like.
> robert
Here's an example of how to use like and wildcards in sqlvar's

select * from students
where surname ilike <dtml-sqlvar expr="'%'+surname+'%'" type="string">

Regards
Garry



More information about the Zope-DB mailing list