Re: [Zope] ZMySQLDA

2005-09-08 Thread Andy Dustman
On 9/1/05, michael <[EMAIL PROTECTED]> wrote: > Hi, I am trying to set this up, following install instructions from > zope.org/Members/Mike/ZMySQLDA > make -f Makefile command works fine, but 'make' afterwards produces > the following error: That page, which no longer exists, was extraord

Re: [Zope] Problem with ZSQLMethods/MySQL after update

2005-06-29 Thread Andy Dustman
Greg's right: ZMySQLDA-2.0.8 definitely won't work properly with MySQL-python-1.2.0. You need ZMySQLDA-2.0.9b3. On 6/29/05, Greg Fischer <[EMAIL PROTECTED]> wrote: > I could be totally wrong, but just a thought > > You might remove the Zmysqlda 2.0.8 you have and download and install > the 2.

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Andy Dustman
On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrote: > Yellow, > > I wrote the wrong version. > I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3 Take a look at ZMySQLDA/db.py: http://cvs.sourceforge.net/viewcvs.py/mysql-python/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py?rev=

Re: [Zope] MySQL timestamp issue

2005-06-03 Thread Andy Dustman
On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrote: > I already know what exactly makes Zope hang! > The problem is located at times.py that was installed by MySQL-Python > 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip) This is a package for Python-2.4. Are you using Python-2.4 with Zope-2.7? If you

Re: [Zope] dollars-and-cents display fails

2005-05-14 Thread Andy Dustman
On 5/14/05, David H <[EMAIL PROTECTED]> wrote: > Greg, > Have you contacted the mySQL product maintainer? This is not a Zope > community issue. Which is to say, many of us have the instinct to help > but simply do not use mySQL and therefore have nothing to suggest. > Other than what is obvious:

Re: [Zope] dollars-and-cents display fails

2005-05-12 Thread Andy Dustman
On 5/12/05, Greg Fischer <[EMAIL PROTECTED]> wrote: > Thanks Andy. I do have those versions. But Python is 2.3.5 because I > didnt want to move to 2.4.x as I think I read something in the README > for Zope stating it was not tested for compatibility. (right?) I > guess my thought is... Does 2.3.

Re: [Zope] dollars-and-cents display fails

2005-05-12 Thread Andy Dustman
On 5/12/05, Greg Fischer <[EMAIL PROTECTED]> wrote: > I just moved my zope app from 2.7.3 to 2.7.6, plus the mysql db from > 5.0.0 to 5.0.4. After moving everything, I noticed all of my decimal > fields that will no longer display their values in DTML unless I > remove the dollars-and-cents fmt op

Re: [Zope] Z SQL Methods and the SQL LIMIT clause

2005-05-11 Thread Andy Dustman
On 5/11/05, Asad Habib <[EMAIL PROTECTED]> wrote: > Is there a reason why Z SQL methods do not allow the use of the LIMIT > clause? I am absolutely certain that my query has the right syntax since I > executed it against the MySQL server and it gave me the correct results. > FYI, I have provided th

Re: [Zope] MySQLdb and unicode

2005-05-06 Thread Andy Dustman
On 5/6/05, robert rottermann <[EMAIL PROTECTED]> wrote: > Hi there, > I have a problem using MySQLdb and unicode. > with older version (0.92) I could set a parameter "unicode" to the > connect() method to tell MySQLdb what charset to use. > > This parameter is not accepted anymore. > The only way

Re: [Zope] MYSQL Problem

2001-01-29 Thread Andy Dustman
ough for you, use that. As Ron points out, INTEGER (particularly UNSIGNED) can overflow in Python, so they need to be returned as Python long integers. Python adds the L when doing str(), but Python 2.0+ does not do this (only on repr()). -- Andy Dustman PGP: 0xC72F3F1D @ .net htt

Re: [Zope] MySQL

2001-01-26 Thread Andy Dustman
y what the error message is that comes with the ValueError exception. -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "Normally with carbonara you use eggs, but I used lobster brains instead." -- Masahiko K

RE: [Zope] ZMySQLDA problems after upgrade

2001-01-26 Thread Andy Dustman
On Fri, 26 Jan 2001, Randall F. Kern wrote: > You will get 0 rows if you use max_rows=0. OK, I agree that this is a legit bug, and I am in the process of working up a new patch. I'll send it off-list when it's ready. -- Andy Dustman PGP: 0xC72F3F1D @

RE: [Zope] ZMySQLDA problems after upgrade

2001-01-26 Thread Andy Dustman
f this is a bad thing. That sounds very much like a good thing. I will have to add that to the tip I have (really, re-write it). I actually forgot that it did that. Randy, does setting max_rows to zero fix things for you? -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.ne

Re: [Zope] ZMySQLDA problems after upgrade

2001-01-25 Thread Andy Dustman
ry much yet. I am cc:ing Brian Lloyd (because he seems like the best bet at this point) to get Digital Creations' attention (obviously they read the list, but this message could easily be overlooked). You can also send me your patch, if you think you have a better way to solve this. -- Andy Dus

[Zope] Re: connecting mysql db from zope

2001-01-18 Thread Andy Dustman
99, in ? > ImportError: No module named sql See, you have the same problem for the ZSolidDA. I would suggest modifying z2.py to print sys.path shortly after importing sys. This will tell you where python is looking for modules. If MySQLdb is not installed in one of those directories, that is y

Re: [Zope] Trouble installing ZMySQLTDA

2001-01-17 Thread Andy Dustman
4, in ? > class DB(DB, TM): > NameError: DB Is this line at the top of that file?: from Products.ZMySQLDA.db import * -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy ___ Zope maillist - [EMAIL

Re: [zope] : installation of MySQL

2001-01-17 Thread Andy Dustman
dustman/MySQL_Updates for more information. ZMySQLDA-2.0.2 is about to be pushed out the door (waiting on some user feedback). I'm going to send that to you off-list, along with MySQLdb-0.3.0. -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy __

Re: [Zope] ZMySQLDA returns truncated/corrupted data?

2001-01-15 Thread Andy Dustman
try "SELECT * FROM ARTIKKEL;", I get > > Error Type: TypeError > Error Value: len() of unsized object I don't know if this is the problem, but ZMySQLDA-2.0.1 requires MySQLdb-0.3.0 (aka MySQL-python). These should both work with MySQL-3.22.23, though I would recommend an

[Zope] Re: mysql connection string

2001-01-15 Thread Andy Dustman
dard port, if necessary. If the UNIX socket is in a non-standard location, you can specify the full path to it after the password. ...so you want something like: db@pit peter-hauser test3-.2 If pit is the local host: db peter-hauser test3-.2 ...will be fas

Re: [Zope] MySQLDA and MySQL-python - patch needed?

2001-01-12 Thread Andy Dustman
pe-ZMySQLDA-1.2.0-1.i386.rpm You might also try: http://www.zope.org/Members/adustman for MySQLdb-0.3.0 and ZMySQLDA-2.0.1, which includes a transactional DA for MySQL servers with BDB tables (3.23.30 recommended). -- andy dustman | programmer | comstar.net is part of the Globix network telep

Re: [Zope] MySQLdb

2001-01-12 Thread Andy Dustman
On Thu, 11 Jan 2001, Martin Fekete wrote: > sombody compiled MySQLdb under WIN32 ? Somebody has. Look for a link at: http://dustman.net/andy/python/MySQLdb/0.3.0 -- andy dustman | programmer | comstar.net is part of the Globix network telephone: 770.485.6025 / 706.549.7689 |

Re: [Zope] duplicate column name

2000-12-07 Thread Andy Dustman
r.id and fac.id have the same column name, of course. I'm a little surprised that some DAs would return column names with periods in them, since this would require using the special namespace object to get at them, i.e. _['adr.id']. The WHERE and ORDER BY clauses can use table.column

[Zope] Stumped: Python in operator seems to not work

2000-09-04 Thread Andy Dustman
ot, make a difference. Initializing parents with a copy of PARENTS (PARENTS[:]) does not make a difference, as expected. Direct comparisons, i.e. (or ==) also fail. What did I overlook, because this seems like it ought to work. -- andy dustman | programmer/analyst | comstar.net, inc.

Re: [Zope] ANNOUNCE: Zope 2.2.1 released

2000-08-25 Thread Andy Dustman
Sadly, 2.2.1 seems to break all my ZClass objects. The Products themselves look fine, but any object made with them comes up as broken. The Class ID (in the HTML source) looked like it had a * in front of it. I retrograded to 2.2.0 and the problems went away. -- andy dustman

Re: [Zope] Zope culture (Was: [Zope] Simple DTML date-stamp)

2000-08-17 Thread Andy Dustman
es work there, so I am told. If you can't get it to compile or something, I can't help you. -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you ma

Re: [Zope] MySQL Select Statements

2000-07-03 Thread Andy Dustman
med "weird but legal" from table t. MySQL, OTOH, is case-sensitive on column names. -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your

Re: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
ltaneously on the same connection, the transactions are going to be whacky. -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your strength or coura

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-07-03 Thread Andy Dustman
ional semantics are required. The status of this checkbox determines which class is used for the database connection. This might be workable, not really sure. -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc

RE: [Zope] MySQL transaction support (was: MySQL Select Statements)

2000-06-30 Thread Andy Dustman
down as having a DA for 3.22 and one for 3.23. Which is, in practice, may not be any different than having one that is not transactional (3.22 never is) and one that is transactional (3.23 sometimes is). -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.

RE: [Zope] MySQL Select Statements

2000-06-30 Thread Andy Dustman
e is to look at the server's version. Anyway, more experimenting is needed. -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your strength or cou

RE: [Zope] MySQL Select Statements

2000-06-30 Thread Andy Dustman
2000 -0400, Ron Bickers wrote: > >Why do you say you "must" use the AS statement? Do you get an error > >otherwise? > > > >MySQLdb 0.2.2 is broken when used with ZMySQLDA. But 0.2.1 works okay for > >me. Andy Dustman (author of the MySQLdb) said he will fix