Re: [Zope-DB] Please help me about driver adapter
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 Regards Garry ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Please help me about driver adapter
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 Nguyen Viet Minh Quang wrote: > Dear Dieter and All, > > Thank you for your mail. > > I have now a trial version of mxODBC. However I don't really like it > because it's not free. I would like to use pymssql and another one, > although I try to install it more times but it's not working. Can you > help me to install it? > > Moreover, I'm testing my product with mxODBC. I have a problem about > query. I want to use keyword 'LIKE' and '%' inside SQL query but I > don't know how to do it. In the current, I use dtml-sqlvar and > dtml-sqltest to do it. Do you know about my problem and can help me to > solve it? > > Further, How can I format the text to get from database, about HTML tag? > > Thank you for your help. > > Best regards, > > > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db > begin:vcard fn:robert rottermann n:rottermann;robert email;internet:[EMAIL PROTECTED] tel;work:031 333 10 20 tel;fax:031 333 10 23 tel;home:031 333 36 03 x-mozilla-html:FALSE version:2.1 end:vcard ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Please help me about driver adapter
Dear Dieter and All, Thank you for your mail. I have now a trial version of mxODBC. However I don't really like it because it's not free. I would like to use pymssql and another one, although I try to install it more times but it's not working. Can you help me to install it? Moreover, I'm testing my product with mxODBC. I have a problem about query. I want to use keyword 'LIKE' and '%' inside SQL query but I don't know how to do it. In the current, I use dtml-sqlvar and dtml-sqltest to do it. Do you know about my problem and can help me to solve it? Further, How can I format the text to get from database, about HTML tag? Thank you for your help. Best regards, ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db