Dear Robert,<br><br>Thanks a lot.<br><br>For pymssql, I installed it follow the instruction, however it's not working.<br><br>I can't create a new connection because in "Add" drop-down It's no exist. I don't know why.
<br><br>Pymssql use for SQL Server, no MySQL.<br><br>By the way, I'm using mxODBC but I don't like because it's not free. Actually, I would like to use pymssql but It is still a problem with me.<br><br>I read this book that you said, however it isn't to help me more.
<br><br>If you know about it. Please help me.<br><br>Best regards,<br>Minh Quang<br><br><div><span class="gmail_quote">On 2/16/07, <b class="gmail_sendername">robert rottermann</b> <<a href="mailto:robert@redcor.ch">robert@redcor.ch
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I do not think any one of us can help you unless you tell us what<br>exactly your problem with installing pymssql ist.
<br>by the way: do you mean MySQLdb?<br><br>there is very good documentation on using Z SQL in the zope book:<br><a href="http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx">http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
</a><br><br>there you find examples how to use a query with like.<br>robert<br><br>Nguyen Viet Minh Quang wrote:<br>> Dear Dieter and All,<br>><br>> Thank you for your mail.<br>><br>> I have now a trial version of mxODBC. However I don't really like it
<br>> because it's not free. I would like to use pymssql and another one,<br>> although I try to install it more times but it's not working. Can you<br>> help me to install it?<br>><br>> Moreover, I'm testing my product with mxODBC. I have a problem about
<br>> query. I want to use keyword 'LIKE' and '%' inside SQL query but I<br>> don't know how to do it. In the current, I use dtml-sqlvar and<br>> dtml-sqltest to do it. Do you know about my problem and can help me to
<br>> solve it?<br>><br>> Further, How can I format the text to get from database, about HTML tag?<br>><br>> Thank you for your help.<br>><br>> Best regards,<br>> ------------------------------------------------------------------------
<br>><br>> _______________________________________________<br>> Zope-DB mailing list<br>> <a href="mailto:Zope-DB@zope.org">Zope-DB@zope.org</a><br>> <a href="http://mail.zope.org/mailman/listinfo/zope-db">
http://mail.zope.org/mailman/listinfo/zope-db</a><br>><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>----------------------------------------------------------------------------------<br>Nguyen Viet Minh Quang
<br>Thua Thien Hue Center of Information Tecnology - HueCIT<br>Hue Software Center - Huesoft<br>Address: 06 Le Loi street, Hue city, Vietnam<br>Work Tel: (84-54) 824141 - Ext 13<br>Cellphone: 0914 173 117<br>Website:
<a href="http://www.huecit.com.vn">www.huecit.com.vn</a><br>----------------------------------------------------------------------------------<br>"Share with all, All will share"!