Hi;
I want to do something like this in my Page Template:
mysql select * from products order by name, newRow;
Now, I know I can do this:
tal:define=items python:sequence.sort(items, (('name', 'cmp', 'asc'),))
but that only orders by name, not by name *and* newRow. Any ideas?
TIA,
Tony
--On 27. September 2007 15:37:33 -0400 [EMAIL PROTECTED] wrote:
Hi;
I want to do something like this in my Page Template:
mysql select * from products order by name, newRow;
Now, I know I can do this:
tal:define=items python:sequence.sort(items, (('name', 'cmp', 'asc'),))
but that only
Thanks!
-Original Message-
From: Andreas Jung [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; zope@zope.org
Sent: Thu, 27 Sep 2007 3:43 pm
Subject: Re: [Zope] ZMySQLDA Question
?
--On 27. September 2007 15:37:33 -0400 [EMAIL PROTECTED] wrote:?
?
Hi;?
I want to do
Traceback (most recent call last):
File /usr/local/zope/278/lib/python/OFS/Application.py, line 673, in
import_product
product=__import__(pname, global_dict, global_dict, silly)
File /usr/local/zope/instance1/Products/ZMySQLDA/__init__.py, line 91, in ?
import DA
File
--On 5. März 2007 07:14:41 -0500 [EMAIL PROTECTED] wrote:
__bootstrap__ ImportError: Shared object libmysqlclient_r.so.15 not
found, required by _mysql.so Traceback (most recent call last):
This is also self-speaking. The mysql client libaries are either not
installed or can't be found.
specific? How exactly do I do that? Or, where is a resource to
learn how to do it?
TIA,
Tony
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; zope@zope.org
Sent: Mon, 5 Mar 2007 8:19 AM
Subject: Re: [Zope] ZMySQLDA Problem
--On 5. März 2007 07:14:41 -0500 [EMAIL
--On 5. März 2007 07:26:10 -0500 [EMAIL PROTECTED] wrote:
# find / -name libmysqlclient_r.so.15
/usr/local/lib/mysql/libmysqlclient_r.so.15
# find / -name bdist.freebsd-6.2-RELEASE-i386
/usr/src/MySQL-python-1.2.2/build/bdist.freebsd-6.2-RELEASE-i386
# ls
]
To: [EMAIL PROTECTED]; zope@zope.org
Sent: Mon, 5 Mar 2007 8:29 AM
Subject: Re: [Zope] ZMySQLDA Problem
--On 5. März 2007 07:26:10 -0500 [EMAIL PROTECTED] wrote:
# find / -name libmysqlclient_r.so.15
/usr/local/lib/mysql/libmysqlclient_r.so.15
# find / -name bdist.freebsd-6.2-RELEASE-i386
--On 5. März 2007 07:35:19 -0500 [EMAIL PROTECTED] wrote:
Thank you for giving me that command, unfortunately, export is not
found on my system (?).
# export LD_LIBRARY_PATH=/usr/local/lib/mysql/
export: Command not found.
# find / -name export
#
you might read about the unix
setenv
Thanks!
Tony
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; zope@zope.org
Sent: Mon, 5 Mar 2007 8:38 AM
Subject: Re: [Zope] ZMySQLDA Problem
--On 5. März 2007 07:35:19 -0500 [EMAIL PROTECTED] wrote:
Thank you for giving me that command, unfortunately
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
michael wrote at 2005-9-1 14:44 +1000:
...
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:
...
[EMAIL PROTECTED] src]# make
gcc -pthread -fPIC
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:
can some one please help me! I have followed all instructions around,
and none of them cover
Dennis Allison wrote at 2005-6-20 11:31 -0700:
...
* Module Shared.DC.ZRDB.TM, line 59, in tpc_finish
* Module Products.ZMySQLDA.db, line 376, in _finish
error: release unlocked lock
When I remember right, I have seen such problem reports in
the mailing list.
You have checked the
IE, Zope 2.7.6, Python 2.4.1, MYSQLDA 2.0.9
One of our developers is reporting a curious problem, which I have not
been able to track down. It appears to be threading related, somewhere
in the ZBMYSQLDB adaptor.
The database connection string is bare of transaction indicators. The
database
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Andy Dustman
Sent: Friday, January 26, 2001 12:42 AM
To: Randall F. Kern
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope] ZMySQLDA problems after upgrade
be returned to it by the query method
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron
Bickers
Sent: Friday, January 26, 2001 11:28 AM
To: Andy Dustman; Randall F. Kern
Cc: [EMAIL PROTECTED]
Subject: RE: [Zope] ZMySQLDA problems after upgrade
How about excluding the automatic
On Fri, 26 Jan 2001, Ron Bickers wrote:
How about excluding the automatic LIMIT clause if max_rows is set to 0?
Would that confuse people?
Oh! It already does that. So if you want to make your own LIMIT clause,
just set max_rows to 0. Correct me, Andy, if this is a bad thing.
That
You will get 0 rows if you use max_rows=0.
-Randy
-Original Message-
From: Ron Bickers [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 10:05 AM
To: Ron Bickers; Andy Dustman; Randall F. Kern
Cc: [EMAIL PROTECTED]
Subject: RE: [Zope] ZMySQLDA problems after upgrade
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
@ .net
Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Randall F. Kern [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 1:22 PM
To: Ron Bickers; Andy Dustman
Cc: [EMAIL PROTECTED]
Subject: RE: [Zope] ZMySQLDA problems after upgrade
You will get 0 rows if you use
s NT(4)
Python 1.5.2 in Program Files but I have that other python.exe in the zope
dir/bin
ZMySQLDA 1.1.3
I used the MySQL.pyd you provided from your How-To
I also used the libmySQL.dll you provided from your How-To
What can be the reason for this? Is it strange Zope/ZMySQLDA behaviour or is
it my
peter bengtson wrote:
William Crandall had a similar question with more details but with the same
result as I. No answer to this one:
http://zope.nipltd.com/public/lists/zope-archive.nsf/242bb7cc2b2c343d802568a
b003585d4/f5a855d999e73c978025693600507b4e?OpenDocument
I am running Zope from the CVS (from January 14th), MySQL 3.22.23 and
ZMySQLDA v2.0.1.
The install appears to be successfull, the Products appear in the Control
Panel, I can add, and open a database connection.
However, when I issue the following query:
SHOW TABLES;
I receive the following
On Mon, 15 Jan 2001 [EMAIL PROTECTED] wrote:
I am running Zope from the CVS (from January 14th), MySQL 3.22.23 and
ZMySQLDA v2.0.1.
Are you really running MySQL 3.22.23? This is a rather old version.
The install appears to be successfull, the Products appear in the Control
Panel, I can
Greetings Zopers,
I'm attempting to make connections between Zope and MySQL using
MySQL-python 0.3.0 and ZMySQLDA 2.01.
The Python/MySQLdb side is working. I can use "connect(db='test')" or
"connect(db='test', user='guest', passwd='token')" -- where guest and token
are a MySQL username and
This is curious to me - I tried this on my Linux platform from mysql and it
doesn't work.
Perhaps I misunderstand what you are trying to do:
SELECT COUNT(*) FROM mytable - returns a number - so I really don't expect
it to work.
I have a table - shop and a column in that table - article:
mysql
I have a problem with ZMySQLDA and aggregate functions in combination with
grouping on Windows.
When I say:
SELECT COUNT(*) FROM mytable GROUP BY myfield;
I get an KeyError 'Unhandeld'.
SELECT COUNT(*) FROM mytable;
works fine, so does
SELECT myfield FROM mytable GROUP BY myfield;
Hi All,
I am trying to install ZMySQLDA and as a result of my installation, i am
getting the following traceback
ZMySQLDA Import Traceback
Traceback (innermost last):
File "/home/zope/224/lib/python/OFS/Application.py", line 397, in
import_products
product=__import__(pname, global_dict,
On Wednesday 06 December 2000 08:47, Rodrigo Leme de Mello wrote:
Hi All,
I am trying to install ZMySQLDA and as a result of my installation, i am
getting the following traceback
ZMySQLDA Import Traceback
Traceback (innermost last):
File "/home/zope/224/lib/python/OFS/Application.py",
PROTECTED]
To: Chris Gray [EMAIL PROTECTED]
Subject: RE: [Zope] ZMySQLDA installation problem
Hi Chris,
I ran into similar errors. Here's the response from Jo Meder that helped me
get MySQLDA compiled: Hope it helps! PS, check out the NIP Ltd Mail list
archives. They've got a really nice search
This is my problem that I have been having. I am trying to install the
database adapter from MYSQL to Zope. I downloaded the ZMySQLDA from the
zope webpage. I then downloaded the Mysqldb from the zope web page. I
installed both. It didn't work. After much trials and tribulations I
found I
I'm trying to install ZMySQLDA on Solaris 5.6. Everything seems to be
going fine until make tries to compile the module. Then I get the
following error messages:
gcc -I/usr/local/mysql/include -I/usr/include/mysql -g -O2
-I/usr/local/include/python1.5 -I/usr/local/include/python1.5
Hi all,
Does anyone have a binary version of ZMySqlDA product?
Because I'm running it on my Win 2000 Professional,
and with the non-binary version, it give me message
like this:
2000-10-11T12:26:25 ERROR(200) Zope Couldn't import
Products.ZMySQLDA
Traceback (innermost last):
File
This is additional info for the error mentioned in my last email.
If I alter the column definitions to use 'int' as opposed to 'mediumint',
then everything works fine! So, its the 'mediumint' type that isnt mapping
properly...
where would i fix this?
I'm guessing it's in db.py in ZMySQLDA, I had to do the same
thing with DECMIAL as shown here, I didn't post that since I'm
not sure most folks would want this behavior but you should
be able to do the same with MEDIUMINT:
class DB:
defs={
FIELD_TYPE.CHAR: "i",
]; [EMAIL PROTECTED]
Subject: Re: [Zope] ZMysqlDA error, and a workaround
I'm guessing it's in db.py in ZMySQLDA, I had to do the same
thing with DECMIAL as shown here, I didn't post that since I'm
not sure most folks would want this behavior but you should
be able to do the same with MEDIUMINT
Franz
Sent: Monday, October 09, 2000 7:07 PM
To: '[EMAIL PROTECTED]'; Jon Franz
Cc: [EMAIL PROTECTED]
Subject: RE: [Zope] ZMysqlDA error, and a workaround
Wow, that looks very diffrent from my ZMySQLDA, what version are you
running?
I just got mine to work, I had to mod the def section in the db.py
Installing MySQLDA-0.1.2 and running
python build.py
I get the error
Import Error: ./_mysqlmodule.so: undefined symbol: uncompress
Any clues ? I've just installed the latest (3.23.25) MySQL rpms on Linux
6.1, including the client and development libraries, this seems to have put
stuff in
Hi,
I installed ZmySQLDA and that mysqldb extension. A test with python "import
_mysql" works, but in the control panel the ZMYSQLDA is broken:
ZMySQLDA Import Traceback
Traceback (innermost last):
File "/usr/local/zope/lib/python/OFS/Application.py", line 396, in
import_products
Hi,
I´ve got it running. ZMYSQLDA could not find the libraries from mysqldb.
Yes, you´re right, it was a FAQ.
BTW: Is there any product that acts as acl_users which allows to collect
more information from my users, like company name, adress ... ?
MfG / best regards,
Peer Dicken
IMD
[Re-sending w/o attachments -- too big for mail servers.]
William BC Crandall wrote:
Chasing down MySQL question, I get here:
(Besides having a strong urge to return to Linux ;)
I now have three MySQL.pyd modules (attached for your
inspection -- labeled 01,02,03). The oldest file (01)
Dear Phil:
Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)".
And for your inquiry about troubles with the set up.
Following the steps you outlined, I was able to establish
a (very) minimal working connection. That is to say, I can
use Zope's 'Z MySQL Database Connection' 'Test' page
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 09, 2000 12:56 PM
Subject: [Zope] ZMySQLDA on Win32 - connect then crash
Dear Phil:
Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)".
And for your inquiry about troubles with the set up.
Following the s
Sorry for the delayed response. I just posted a patch for this on the Zope
site at http://www.zope.org/Members/jfarr/Patches
--jfarr
- Original Message -
From: Brenton Bills [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 22, 2000 12:06 AM
Subject: [Zope] ZMysqlDA
Hi
directory and restart Zope, ZMySQLDA does not show up in
the Products list. All the above were installed from RPM binaries. I
did manage to get ZMySQLDA working on a different machine with some
difficulty. I seem to have hit a different stumbling block this time.
Any suggestions?
David
Hi people, I am trying to get ZMysqlDA running on a 4.0 Release BSD
machine, I have compiled this fine before on Linux but no luck on bsd. I
am new to Bsd so if this is a bsd problem I appolagise in advance, but the
ZMysqlda documentation is not clear on what libs are required.
Python 1.5.2
+[ Brenton Bills ]-
|
| Hi people, I am trying to get ZMysqlDA running on a 4.0 Release BSD
| machine, I have compiled this fine before on Linux but no luck on bsd. I
| am new to Bsd so if this is a bsd problem I appolagise in advance, but the
|
When I use an ZSQL method to fetch data, the manage test tab gives a
result of 14 items. When the same method is used in a dtml-in tag, with
batches of size 10, it only shows the first 10 items, with no "Show next x
missions". It previously showed "Show next 4 missions", but after altering
10 of
49 matches
Mail list logo