http://blog.gmane.org/gmane.comp.python.egenix.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.python.egenix.user/1220 Hi, I have struck an error on MacOS Leopard similar to this post. http://www.egenix.com/mailman-archives/egenix-users/2007-July/114231.html My error is as follows: Python 2.5.2 (r252:60911, Sep 5 2008, 23:29:08) [GCC 4.0.1 (Apple Inc. build 5465)] on darwin Type "help", "copyright", "credits" or "license" for more information. Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/__init__.py", line 7, in <module> from Tidy import * File "/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/Tidy.py", line 7, in <module> from mxTidy import * File "/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/mxTidy/__init__.py", line 7, in <module> from mxTidy import * ImportError: dlopen(/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/mxTidy/mxTidy.so, 2): Symbol not found: _CleanTree Referenced from: /Users/darrylcou Darryl Cousins 2008-09-05T12:08:31 http://comments.gmane.org/gmane.comp.python.egenix.user/1216 Hi, I've connected to my database through mx.ODBC.Windows functions connect() and DriverConnect(). I was able to execute sql.execute("""SELECT count(*) FROM IM1_InventoryMasterfile""") but not sql.execute("""SELECT * FROM IM1_InventoryMasterfile LIMIT 5"""). This is the error that I get: mx.ODBC.Error.InterfaceError: ('3700', 1017, '[Best Canada][PUX ODBC Driver]Unexpected extra token: 5', 7089) Windows ODBC version: 3.525.11.32.0 Windows Python version: 2.5 Why does a simple LIMIT 5 not work? Thanks, Minh-Long Pham 2008-09-02T18:43:37 http://comments.gmane.org/gmane.comp.python.egenix.user/1215 ________________________________________________________________________ ANNOUNCING eGenix.com mx Base Distribution Version 3.1.1 Open Source Python extensions providing important and useful services for Python programmers. This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.1-GA.html ________________________________________________________________________ ABOUT The eGenix.com mx Base Distribution for Python is a collection of professional quality software tools which enhance Python's usability in many important areas such as fast text searching, date/time processing and high speed data types. The tools have a proven record of being portable across many Unix and Windows platforms. You can write applications which use the tools on Windows and then run them on Unix platforms without change due to the consistent platform independent interfac eGenix Team: M.-A. Lemburg 2008-08-05T12:46:37 http://comments.gmane.org/gmane.comp.python.egenix.user/1209 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Weverton Gomes 2008-07-22T15:53:53 http://comments.gmane.org/gmane.comp.python.egenix.user/1208 ________________________________________________________________________ eGenix EuroPython 2008 Presentations & Videos ________________________________________________________________________ We have uploaded our EuroPython 2008 presentations to our website. Learn the concepts behind the Python DB-API and how to design large-scale applications. This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/EuroPython-2008-Presentations.html ________________________________________________________________________ INTRODUCTION The EuroPython Conference is the one of the premier conferences for Python & Zope users and developers. This year it was being held from the 7th to 9th July in Vilnius, Lithuania. eGenix was one of the founding members of the EuroPython conference team and played a major role in organizing the first EuroPython conference in the year 2002. Since then we have attended every EuroPython conference to meet up face-to-face with eGenix Team: M.-A. Lemburg 2008-07-21T21:26:54 http://comments.gmane.org/gmane.comp.python.egenix.user/1204 Hi- I'm connecting from linux x86_64 to a sqlserver2005 instance using mxODBC 3.0.1 with unixODBC. I'm able to retrieve data with no problem. When I try a simple insert: c=db.cursor() p1="test" p2="mxodbc test" c.execute("insert into bug" + \ " (UIElement,Description)" + \ "values (?,?)" \ ,(p1,p2) \ ) c.rowcount is 1 but the row is not present in the table. If I execute the same sql command using isql it works. The table uses an autoincrement key column and values for the key are consumed even though the record is not being created. c.messages is empty. The same behavior is seen regardless of whether parameters are used and regardless of wether I use execute or executedirect. Any help would be appreciated. Thanks, Joel _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailm Joel Bard 2008-07-17T19:49:44 http://comments.gmane.org/gmane.comp.python.egenix.user/1202 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Greg Corradini 2008-06-23T16:20:59 http://comments.gmane.org/gmane.comp.python.egenix.user/1201 ________________________________________________________________________ ANNOUNCING eGenix.com mx Base Distribution Version 3.1.0 Open Source Python extensions providing important and useful services for Python programmers. This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.0-GA.html ________________________________________________________________________ ABOUT The eGenix.com mx Base Distribution for Python is a collection of professional quality software tools which enhance Python's usability in many important areas such as fast text searching, date/time processing and high speed data types. The tools have a proven record of being portable across many Unix and Windows platforms. You can write applications which use the tools on Windows and then run them on Unix platforms without change due to the consistent platform independent interfac eGenix Team: M.-A. Lemburg 2008-06-18T16:26:54 http://comments.gmane.org/gmane.comp.python.egenix.user/1200 ________________________________________________________________________ ANNOUNCING eGenix.com mxODBC Connect Database Interface for Python Version 0.9.1 (beta) Our new client-server product for connecting Python applications to relational databases - on all major platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mxODBC-Connect-0.9.1-beta.html ________________________________________________________________________ INTRODUCTION The mxODBC Connect Database Interface for Python allows users to easily connect Python applications to all major databases on the market today in a highly portable and convenient way. This makes mxODBC Connect the ideal basis for writing cross-platform database programs and utilities in Python. mxODBC Connect extends our eGenix mx Python Extension series with a new client-server based product, that removes the need to instal eGenix Team: M.-A. Lemburg 2008-06-16T10:12:26 http://comments.gmane.org/gmane.comp.python.egenix.user/1199 ________________________________________________________________________ ANNOUNCING eGenix.com pyOpenSSL Distribution Version 0.7.0-0.9.8h-1 An easy to install and use repackaged distribution of the pyOpenSSL Python interface for OpenSSL - available on Windows and Unix platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-pyOpenSSL-Distribution-0.7.0-0.9.8h-1-GA.html ________________________________________________________________________ INTRODUCTION The eGenix.com pyOpenSSL Distribution includes everything you need to get started with SSL in Python. It comes with an easy to use installer that includes the most recent OpenSSL library versions in pre-compiled form. pyOpenSSL is an open-source Python add-on (http://pyopenssl.sf.net/). OpenSSL is an open-source implementation of the SSL protocol (http://www.openssl.org/). * About Python: eGenix Team: M.-A. Lemburg 2008-06-12T20:04:46 http://comments.gmane.org/gmane.comp.python.egenix.user/1195 The Plone universal installer ships with its own Python and Zope installation. As a result the installation procedure for our Zope DA has to be adapted to the Plone setup. The following assumes that you are using the unified Plone 3.1 installer and its default standalone configuration. For a Plone 3.1 standalone installation: ---------------------------------------- cd /opt/Plone-3.1/ # Unzip the mxODBC Zope DA ZIP file in the instance directory unzip -d zinstance/parts/instance \ egenix-mxodbc-zopeda-1.0.10.*-py2.4_ucs2.zip # Move the product package into place mv zinstance/parts/instance/lib/python/Products/mxODBCZopeDA \ zinstance/products/ # Remove the no longer needed Products/ directory to avoid # confusion rmdir zinstance/parts/instance/lib/python/Products then install the license files into /opt/Plone-3.1/zinstance/parts/instance/lib/python/mx/ODBC and restart Plone. Regards, M.-A. Lemburg 2008-06-06T20:14:28 http://comments.gmane.org/gmane.comp.python.egenix.user/1189 Dear list, I am evaluating mx.odbc for connecting to a MS SQL server from my Linux machine using freetds 0.82. I can connect and query using isql without problem, but I get a segmentation fault if I fetch using the mx.odbc interface. wva< at >amcat:~/tmp$ isql -v AmcatDB <UID> <PWD> +---------------------------------------+ | Connected! [...] +---------------------------------------+ SQL> select top 1 projectid, name from projects [...] | 1 | test [...] SQLRowCount returns 1 1 rows fetched wva< at >amcat:~/tmp$ python testodbc.py connected to Microsoft SQL Server 08.00.2039 Executed, fetching... [(1,)] Executed, fetching... Segmentation fault wva< at >amcat:~/tmp$ cat testodbc.py import mx.ODBC db = mx.ODBC.unixODBC.connect("AmcatDB", "<UID>", "<PWD>") print "connected to %s %s" % (db.dbms_name, db.dbms_version) c = db.cursor() c.executedirect("select top 1 projectid from projects") print "Executed, fetching..." print c.fetchall() c.executedirect("select top 1 projectid, name from projects") print "Executed, f Wouter van Atteveldt 2008-06-03T00:49:58 http://comments.gmane.org/gmane.comp.python.egenix.user/1187 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Eric S Tyrer II 2008-05-22T14:49:47 http://comments.gmane.org/gmane.comp.python.egenix.user/1184 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Cliff Quinn 2008-05-22T04:35:37 http://comments.gmane.org/gmane.comp.python.egenix.user/1175 Hello all, I try to use mx.ODBC in the following environment: mx.ODBC, Linux, iODBC, FreeTDS-Library, Microsoft SQL Server. I get an error message when I try to insert a string with new lines into a table with a TEXT field: import mx.ODBC con = mx.ODBC.iODBC.DriverConnect("DRIVER={SQL Server};SERVER=<server_ip>;DATABASE=<dbname>;UID=<user>;PWD=<pwd>") cur = con.cursor() cur.execute("CREATE TABLE #test (t text)") cur.close() cur = con.cursor() cur.execute("INSERT INTO #test(t) VALUES(?)", ('test\n',)) cur.close() con.close() /etc/odbcinst.ini: [ODBC Drivers] TDS MSSQL = installed [SQL Server] Description = TDS MSSQL ODBC Driver v 4.2 Driver = /usr/local/lib/libtdsodbc.so after the line cur.execute("INSERT ... ") I get an error: Traceback (most recent call last): File "<stdin>", line 1, in ? mx.ODBC.Error.ProgrammingError: ('22018', 206, '[FreeTDS][SQL Server]Operand type clash: varbinary is incompatible with text', 7028) Part of freetds-Log: token.c:2159:tds_process_end() state set to TDS_IDLE util Alexandre Pigolkine 2008-05-14T06:37:12 http://comments.gmane.org/gmane.comp.python.egenix.user/1171 For mxDateTime. I know I saw this in the manual, but I can't locate it again. Thanks, Dick Moores _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Dick Moores 2008-05-07T10:09:20 http://comments.gmane.org/gmane.comp.python.egenix.user/1168 Hi, I am using mx.DateTime to parse dates and times in ISO format. I have noticed that DateTimeFromString seems to be off by one second if the time string being parsed ends with :59 <mx.DateTime.DateTime object for '2008-05-06 19:30:09.58' at 651a8> but <mx.DateTime.DateTime object for '2008-05-06 19:30:09.58' at 8c250> Adding formats=['iso', ] does not change the results. I am using mx.DateTime 3.0 by the way. Am I doing something wrong? Thank you! Francesco _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Francesco Pierfederici 2008-05-06T21:27:53 http://comments.gmane.org/gmane.comp.python.egenix.user/1165 Use this file for temporary saving. E.g. for drafting an email. Please see my daysDelta24.py at <http://py77.python.pastebin.com/f5d8a35d> "Compute the difference in days (and weeks and days) between 2 dates. E.g., The difference between 07/04/1776 and 09/11/2001 is 82248 days Or 11749 weeks and 5 days" The user is instructed to "Enter date as month/day/year, or enter nothing for today", for both dates. If for one date he chooses to enter nothing in order to make that date today's date, the script fails--the computed difference between the dates will be short by 1. Thus, if the dates are 5/5/2008 (today's date entered by entering nothing) and 5/8/2008, the computed difference will be 2. If instead, both of these dates had been entered "manually", the computed difference will be 3. (See outputs #3 and #4, lines 107-126) I believe the error is caused by getDate() returning DT.now() when the user enters "". DT.now() is, for example, 2008-05-05 00:51:34.00 (my local time at time of writing), not 2008-05-05 Dick Moores 2008-05-05T08:37:16 http://comments.gmane.org/gmane.comp.python.egenix.user/1163 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Eric S Tyrer II 2008-05-03T02:21:24 http://comments.gmane.org/gmane.comp.python.egenix.user/1153 Win XP, Python 2.5.1, mxDateTime v.3 I'm trying to begin to master both Python's datetime module and mxDateTime. I have a script that does something useful for me with datetime: <http://py77.python.pastebin.com/f25c957>. Note the user is able to enter a date in informal U.S. style. E.g. yesterday's as 5/1/2008. I've tried hard to write a script that does the same with mxDateTime, but am not able to incorporate the same date style. I'm stuck at having the user enter a date as "year, month, date". This effort is at <http://py77.python.pastebin.com/f130055a1> Please suggest how to modify this to meet my objective. Thanks, Dick Moores _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Dick Moores 2008-05-02T09:29:08 http://comments.gmane.org/gmane.comp.python.egenix.user/1146 _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users Cliff Xuan 2008-04-15T15:15:25 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.python.egenix.user