Re: [Zope-DB] Please help me about driver adapter

2007-02-15 Thread garry saddington
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:

Re: [Zope-DB] case insensitive ZSQL queries

2007-09-06 Thread garry saddington
On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote: is there an easy way to make the following ZSQL query case-insensitive? select * from clients dtml-sqlgroup where dtml-sqltest firstname op=like type=string optional dtml-or dtml-sqltest lastname op=like type=string optional

Re: [Zope-DB] Calling SQL Query in DTML Method with a string argument

2008-07-28 Thread Garry Saddington
On Monday 28 July 2008 15:59, Matylda Sawicka wrote: Hello, I am a fresh Zope Explorer. I was trying to call an SQL Query that requires an argument in a DTML Method that would be called with an argument passed in the URL. The Query looks more or less like this: SELECT Uni_Name,

Re: [Zope-DB] ZSQL Question - Insert multiple rows in one statement?

2010-08-24 Thread Garry Saddington
Garry Saddington wrote: Andreas Jung wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would assume that you can use DTML-IN for looping and generating multiple SQL statements of the same kind. You have to ensure that the statements having a proper delimiter (there was something