tored in the ZODB as, except in rare cases such as RelStorage, the majority of
data of a Zope server will be stored in the ZODB.
Finally, I must point out that Zope 2.6 is a very old and no longer supported
release.
Charlie Clark
--
Charlie Clark
eGenix.com
Professional Python Services directly fro
you should have someone at Mahindra Tech who
can help you as this mailing list isn't the right place for further
discussion of such basics.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support .
're running on RHEL in which case I would
hope you there will be some kind of Red Hat curated packages. Other than that
I think you're stuck but you might try asking on initd.org
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> >>
with more experience in unix
to help you. I'm no unix whizz myself but installing Zope 2, psycopg2 and
ZPsycopgDA is pretty straightforward if you follow the instructions.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> >
e this is the case then Zope should start or at least
give a different error.
Please note that the errors you are experiencing are not related to Zope,
Python or Postgres but unix and you should see if you can get some help from a
sys admin in your company.
Charlie
--
Charlie Clark
eGen
derlying psycopg library that
you've installed. It cannot find the Postgres libraries and so cannot connect
to the server. Once you've fixed this you ZPsycopgDA should work fine. Andreas
has pointed out what you need to do.
BTW. I think that you may well be better off with psycopg2 as the lib
p; postgres?
>
> I am using Zope 2.11.4, python 2.4.4, Postgres 7.4.13, egenix 2.0.6 &
> Psycopg 1.1.6
>
> I am really in a mess! Really need your help!
Hi Smita,
if you can start Zope from the shell:
bin/zopetcl fg
You should get a Python traceback that says what is stopping t
and Hannu's proposed DORA both offer significant advantages
over SQL and, therefore, SQL generation.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> >>> Python/Zope Consulting and Support ...http://www.egenix.co
E_HOME, where I
> would expect it to be looking. We're still able to manually start
> Plone's Python and import cx_Oracle just fine. Does anyone have any
> suggestions?
Given that it works when you run Python manually but not when you start
the cluster the problem is li
Am 18.07.2009, 00:02 Uhr, schrieb Charlie Clark :
> Yes, but the code is sketched. There is a reference implementation of a
> similar utility in SQLAlchemy for Plone that we might be able to use but
> the good news is that you can use the .execute() on the connection
> whene
Am 31.03.2009, 11:27 Uhr, schrieb Chris Withers :
> get python running in the browser, which sadly is never going to happen)
There is always Grail http://grail.sourceforge.net/
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zop
good candidates for using stored
procedures.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.ege
o the file
system and it's worth it, especially if you can remove your dependency on
ExternalMethods as well.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...http://www.ege
file system if you haven't
already done this.
> Thanks and sorry for bothering you directly. Please let me know if not
> appropriate.
While I don't mind the e-mail at all. It's always good to keep discussions like
this on list so to that others can join in or benefit.
Charlie
it to the browser. But most importantly - in
the Zope world the RDBMS is unlikely ever to be your bottleneck.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...http://www.egenix.c
actually need to work with an external data system.
If you only need to divide your users into groups then the user management
in Plone should be sufficient. Look at the Plone Control Panel.
And please try to use some of the abundant documentation on these topics.
Charlie
--
Charlie Clark
eGe
s the very basics of using
ZSQL in Zope and there is a download with code for your to play with.
http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/
Good luck!
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Z
ess is crashing for some reason. You need
to enable debugging in zope.conf to get something in your event log but
without shell access it might be difficult to trace the problem.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulti
I don't
know where it is documented.
Zope doesn't support it and unfortunately relational databases aren't
getting the attention they deserve in the Zope world at the moment.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope
still get the same error message in the
event.log file:
Sounds like a permissions problem: the Zope user might not be allowed to
access /usr/local/lib/mysql.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and S
h? for apache and either XUF or PAS for Zope,
as both allow you to hold your users outside of Zope. I'm not sure whether
you wouldn't still be stuck with the problem of having the connection tied
to a one user while wanting to log another.
Charlie
--
Charlie Clark
eGenix.com
Pro
harlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
mxODBC, mxDateTime, mxTextTools ...http://python.egen
on the driver is broken
but you're better off asking the question on the Mysqldb list.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... h
d. Is this
reasonable, or am I just going down a rat-hole?
All form values are in the context.REQUEST.form dictionary which can
overwrite to your heart's content.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support
re is a lot of them.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
mxODBC, mxDateTime, mxTextTools ...
to use an
argument within ZPT without passing it or defining it? Please provide a
code snippet.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.A
nto a PageTemplate using the options dictionary.
You might want to look at my presentation (with sample code) which touches
on Zope and RDBMS.
http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from th
at them again for a couple of years. Then, when you have to, it's
incredibly wonderful being able to review and test them individually.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.
;ve started work on a
simpleSQLTemplate which uses string.Template to support $placeholders
"SELECT id FROM table WHERE id = $value"
->
"SELECT id FROM table WHERE id = ?", (value,) # generate the SQL using the
appropriate paramstyle for the underlying DB driver.
Charlie
--
C
n object if they are supported.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
mxODBC, mxDateTime, mxText
l be ignored by ZSQL methods unless they are
explicitly declared as arguments.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... http:
with the unicode problems?
Any idea?
What setting do you have for Zope's encoding? in etc/zope.conf
Your problem might be solved with the correct setting for that. Otherwise
you may need to patch the DA to handle encoding for your target for you.
Charlie
--
Charlie Clark
eGenix.com
Profe
here should be no reason for a timeout as maybe happening here.
Charlie Clark
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Database.Adapter ... http://zope.egenix.
e many occasions where you want the kind of direct
access to a relation you get with the existing DA's.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
Python/Zope Consulting and Support ...http://www.egenix.com/
mxODBC.Zope.Databa
our project will need more time then you will need to purchase a licence.
Sincerely
Charlie Clark
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Am 08.03.2007, 10:23 Uhr, schrieb Comunian Alessandro
<[EMAIL PROTECTED]>:
I think that maybe the problem is that MySQL is compiled whith a compiler
different than gcc... and the problem could be solved installing MySQL
from
sources, but I not yet been able to do it.
Somebody have some sugg
Am 07.03.2007, 11:39 Uhr, schrieb javi lopez <[EMAIL PROTECTED]>:
My product is like a faq, i have a search engine, it search a
ask-answer in my portal, but if there isn´t result, i fill in a form,
it store email and ask of the user on my DB and when my admin knows
the answer, he answered to the
Am 07.03.2007, 10:48 Uhr, schrieb javi lopez <[EMAIL PROTECTED]>:
All that is a little part of a Product, but i need check that´s ok ,
when I fill in the form , email and ask are stored in my DB with zsql
method, i need user to stored in DB too.
how could do it??
I am sorry but I do not unders
Am 07.03.2007, 10:35 Uhr, schrieb javi lopez <[EMAIL PROTECTED]>:
Hello everyone:
i´m doing a form where i get email and one ask. when I check that
email is valid, I do Controller Python Script where i want to create:
Why do you need a DB connection per user? You can't do this in a
PythonScr
Am 17.02.2007, 13:52 Uhr, schrieb Robert-Reinder Nederhoed
<[EMAIL PROTECTED]>:
Dear Nguyen,
For as far as I know, mxODBC is free to use in a non-commercial
environment.
So you can freely use it for your research or graduation project. Once
your
school adopts your application, they can li
Am 06.02.2007, 17:13 Uhr, schrieb Paul Eipper <[EMAIL PROTECTED]>:
I need to populate several DG fields on one form that will allow to
update, delete and insert new data to my database. Is there a tutorial
or some docs about that somewhere?
Sorry, I have no idea how DG works. There are tutoria
Am 06.02.2007, 13:49 Uhr, schrieb Paul Eipper <[EMAIL PROTECTED]>:
Hello
I'm currently using PFG+DataGrid fields to insert data on a MySQL DB,
but now I need a form to allow to update that data. How can I do this
with DG fields without having a column showing the ID?
Also, how can I delete DG fi
Am 06.02.2007, 10:29 Uhr, schrieb Robert-Reinder Nederhoed
<[EMAIL PROTECTED]>:
Good day,
We use Zope 2.8, still from ZMI. We ran into the 1000 limit several
times. Instead of remembering to set it to a higher value, I would like
to change the ZSQL max_rows default to 5000.
Is it possi
Am 29.01.2007, 12:05 Uhr, schrieb Sven Plage <[EMAIL PROTECTED]>:
Sehr geehrte Damen und Herren,
ich habe in Zope eine "mxODBC Database Connection" angelegt und dort
auch einen entsprechenden "Database Connection String
(DSN=testDB;DATABASE=testDB;UID=root;PWD=) " angelegt. Nun möchte ich
Am 26.01.2007, 14:17 Uhr, schrieb Graziella Toutoungis
<[EMAIL PROTECTED]>:
curs.execute("DROP TABLE test_fetch")
#curs.execute(createQuery)
i will integrate in zope this code to create a form in
order to give the users the capability to manage my
database.
any suggestions?
Yes, you
Am 26.01.2007, 08:37 Uhr, schrieb Graziella Toutoungis
<[EMAIL PROTECTED]>:
Hello,
I use zope2.9.4 with postgresql8.1, in my database i have some tables
are the result of a query on other tables.
exe: table1 is the result of table2 with table3
My
user can connect to the database and he ca
Am 22.01.2007, 13:00 Uhr, schrieb Pawel Lewicki <[EMAIL PROTECTED]>:
I know what's causing timeouts I can't help it now.
It would still be useful to others: is it a database, network or driver
issue.
Increasing connection number doesn't help. I don't blame mxODBC as it is
a great produ
Am 22.01.2007, 11:54 Uhr, schrieb Pawel Lewicki <[EMAIL PROTECTED]>:
Charlie Clark napisał(a):
Am 22.01.2007, 11:24 Uhr, schrieb Pawel Lewicki <[EMAIL PROTECTED]>:
Hi,
I'm using a configuration from the subject. It's quite an old Zope 2.7
instance without prospects
Am 22.01.2007, 11:24 Uhr, schrieb Pawel Lewicki <[EMAIL PROTECTED]>:
Hi,
I'm using a configuration from the subject. It's quite an old Zope 2.7
instance without prospects of upgrade because of dependencies.
Problem is with ODBC broker timeouts. When query takes too much time the
connection b
Am 19.01.2007, 20:10 Uhr, schrieb Paul Eipper <[EMAIL PROTECTED]>:
Hmm, that was "Yes, it does the transaction thing automatically." or a
"Yes, you need to do it manually." ??
It is done within a Zope transaction so you don't have to do anything.
Dennis, I will start looking at SQLAlchemy,
Am 19.01.2007, 17:50 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
it in deed seems not to work.
however I do not understand why.
If you use callproc() we could probably help you.
This is now academical as I resolved to not to use stored procedures
that return a record set (tough its a
Am 19.01.2007, 14:30 Uhr, schrieb Paul Eipper <[EMAIL PROTECTED]>:
I have a Form (generated with PloneFormGen+DataGridField) and I need
to send the data entered there into several mySQL tables. I am
guessing a Python script would be the right thing here.(?)
Can't tell you much about what the P
Am 19.01.2007, 13:27 Uhr, schrieb Maciej Wisniowski
<[EMAIL PROTECTED]>:
Please, stay on the list
First, isn't Charlie Clark solution good for you? It seems to be
reasonable.
Thanks! ;-)
I have try to use external method but without success... (I have read
some post as you s
Am 19.01.2007, 12:22 Uhr, schrieb CERETTO Thierry <[EMAIL PROTECTED]>:
Thierry,
keep replies on the mailing list so that others can learn from them.
Hi,
Thanks Charlie, your method works well (after some hours of labor...)
My code below (not finalized, but, for Zope/Python/MySsql newbies, can
Am 18.01.2007, 17:58 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
I think I found the reason, for my problems with stored procedures.
it seems that on can not call a stored MySQL 5.0x procedure from zope
that returns a data set.
If you use the mxODBC Zope DA callproc() method then you c
Am 18.01.2007, 11:52 Uhr, schrieb CERETTO Thierry <[EMAIL PROTECTED]>:
select distinct c.id_risque, c.libelle_risque, c.id_fiche, c.id_portee,
c.url_info
from (mots a join amotrisque b on a.id_mot = b.id_mot )
join risques c on b.id_risque = c.id_risque
where a.mot_MAJ like '%@@CRITE
Am 17.01.2007, 18:19 Uhr, schrieb Re: [Zope-DB] sql query works in
database connector but not in ZSQL methodrobert rottermann
<[EMAIL PROTECTED]>:
query = "CALL selectVertexProperties(%s, @error2)" %
dbid
- - problem>> result = db.query((query).replace(';', sql_delimit
Am 17.01.2007, 17:57 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
I of course can send them into the interface as integer, but the
procedure is called with a sting (at least the error suggests that)
- -->{call selectVertexProperties('1')}' at line 1", 6088)
Remember you can use bound pa
Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
If tried that, but somehow I did not get it rigth:
questions:
- - the first parameter is an integer, how do I force that?
int(para) ?
- - the second parameter is an out parameter, how do I specify that ?
You don't, I
Am 17.01.2007, 15:42 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
Hi there,
I try the following statement:
CALL selectVertexProperties(1, @error2)
when I execute this directly in the test "window" of the database
connection, it works fine.
when i execute the same line in the test window o
Am 10.01.2007, 17:00 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
thanks for your suggestion.
i am using mxODBC for 2 cusomers and I was under the impression, that it
is used (as the name suggests) to connect to a odbc database.
would using it mean that I had to access MySQL trough odbc.
Am 10.01.2007, 13:16 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
thanks charlie,
so that means, that the _commit and _abort methods are only for zope's
transaction controll.
Yes, and with good reason.
do you have a suggestion how then to start/commit a transaction from
within a ZSQL
Am 10.01.2007, 13:00 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:
I understand that there is a way to handle transaction control in the
ZMySQL methods. However I find no documentation at all on how to use it.
This is incorrect. ZSQL methods are called within Zope transactions so you
n
Am 04.01.2007, 18:47 Uhr, schrieb [EMAIL PROTECTED]
<[EMAIL PROTECTED]>:
Hello Everyone,
I am relatively new to Zope/Plone, as well as the MxODBC Zope DA
adaptor. I am wondering if someone could point me to a basic example
that would illustrate how to use the MxODBC Zope DA adaptor outsid
Am 23.11.2006, 17:03 Uhr, schrieb Andreas Tille <[EMAIL PROTECTED]>:
You are right here and I would definitely prefer Python scripts. The
problem is that I'm using the Formulator Product and despite there are
descriptions how to use it with Python scripts I failed while it was
very straigtforew
Am 20.10.2006, 18:33 Uhr, schrieb fabio gravina <[EMAIL PROTECTED]>:
I want to store more than one records in a single call of zsql method, or
something like LOAD DATA in mysql..
Someone help me
Use an ExternalMethod and executemany().
Charlie
--
Charlie Clark
eGenix.com
Profes
ed the original bug
bothered to rtfm as well...
Oops, I submitted a duplicate bug (I did try looking beforehand) which has
been rejected "as already fixed" - it certainly isn't in the 2.10 which
can be downloaded. Will this automatically get the change which _has_ been
made
. FFS...
How hard is "exc_info=True" to grasp as a concept?
Don't shoot the messenger! I've hardly touched the logging module so I'll
plead ignorance (as well as stupidity ;-). But for 2.10 it is a big error
if zLog is officially being deprecated. I'll s
Globals.Persistent.__setstate__(self, state)
if self.connection_string:
try: self.connect(self.connection_string)
except:
logger.error('Error connecting to relational database.',
exc_info=exc_info())
Am 16.10.2006, 15:10 Uhr, schrieb Chris Withers <[EMAIL PROTECTED]>:
Charlie Clark wrote:
Technically you should actually use $INSTANCE_HOME/modules at least for
Never heard of 'modules' before, where did you read about this?
My bad - I'm sure I saw it on one of
EQUEST
for item in request.form.keys():
validate(item)
if no_errors:
context.SQL.someZSQLMethod(dictionary_of_items)
return context.thank_you_page()
else:
return context.error_page()
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly fr
dout system creates a
dedicated "private" python installation; we're not currently sharing
python or SOFTWARE_HOME across multiple instances, and I doubt we'll
start doing that because it'd take some hacking on the build scripts so
it's much cheaper to just keep wasti
A in
your SOFTWARE_HOME rather than INSTANCE_HOME which should protect.
Charlie
--
Charlie Clark
eGenix.com
Tel: +49-211-600-3657
GSM: +49-178-782-6226
Professional Python Services directly from the Source
___
Zope-DB mailing list
Zope-DB@zo
he statement that we never sent him a licence.
Charlie
--
Charlie Clark
eGenix.com
Tel: +49-211-600-3657
GSM: +49-178-782-6226
Professional Python Services directly from the Source
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Am 28.09.2006, 18:33 Uhr, schrieb Paul Winkler <[EMAIL PROTECTED]>:
Yes! Thank you very much.
Somehow I failed to notice that the connection had a connection
attribute.
Not surprising really. Most people are quite happy with ZopeDA's the way
they are and so we only very rarely get questions
Am 28.09.2006, 00:26 Uhr, schrieb Paul Winkler <[EMAIL PROTECTED]>:
I'll be writing product code, and am currently just experimenting via
zopectl debug, so I have full access to everything. But I still can't
see how to get a cursor or anything else that will let me retrieve
multiple record sets
Am 27.09.2006, 23:44 Uhr, schrieb Paul Winkler <[EMAIL PROTECTED]>:
Any suggestions?
p.s. I'll be asking egenix too, we'll see if they reply to help requests
without a purchased license... but then, if I can't get this to work
there's no point in purchasing one :-]
Why shouldn't we answer supp
Am 30.08.2006, 00:44 Uhr, schrieb Maslak, Michael
<[EMAIL PROTECTED]>:
Did what you suggested. That is, removed the BEGIN TRANSACTION & COMMIT
TRANSACTION statements. It has the same behavior: a non-atomic commit.
No roll back. mat1 has a new record mat2 errors.
Please keep your reply on lis
Am 30.08.2006, 00:35 Uhr, schrieb Maslak, Michael
<[EMAIL PROTECTED]>:
It is allowing a record to be committed in mat1 even as mat2 fails.
There is no roll back happening.
Normally, if you leave the transaction management to Zope and the RDBMS
can manage it, then all transactions will inde
Am 29.08.2006, 22:42 Uhr, schrieb Maslak, Michael
<[EMAIL PROTECTED]>:
Can you please correct my mistake or my
misunderstanding?
Yes, you don't need to explicitly start and commit transactions in ZSQL as
Zoep does this for you.
Charlie
___
Zope
system which is built-in. I don't think it is
as customisable as ZCatalog but may suffice.
Charlie
--
Charlie Clark
eGenix.com
* Professional Python Services directly from the Source *
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/
Am 11.08.2006, 16:56 Uhr, schrieb <[EMAIL PROTECTED]>:
Hi
I'm working with a Postgresql database which I have to insert a lot of
data to... I'm using the ZPsycopgDA database adapter, and ZSQL methods.
I have noticed that though I am calling the zsql method no data gets
really commited to the
NGUYEN HUU DINH wrote:
Hi,
I used mxodbc connected to MSSQL Server to get vietnamese data and displayed
it in portlets. But vietnamese characters displayed not correctly, question
mark appeared!!! I've set the encoding to utf-8 but I don't know why. Can
you help me.
See the website with error: h
Maciej Zięba wrote:
Hi :-)
Thank you for your suggestions I think I will have to try that...
In the meantime I've managed to get the "dollar-quotation" to work -
well, kind of. Previously I was making a very stupid mistake - the $$
should be in template and not in the string itself. I mean some
Maciej Zięba wrote:
Hi :)
I need to insert a python string into Postgresql's text field. I'm using
a ZSQLMethod with ZPsycopgDA and the template looks like this:
'INSERT INTO records (zope_id, title, long_description)
VALUES (,
,
)'
long_description is the text field.
With most of my data i
Maciej Zięba wrote:
Hi :)
I wanted to ask if there's any way to send a file to PostgreSQL database?
The file I have is taken from REQUEST, from multipart form. I need to
send it to the database and later retrieve it when needed. I guess I
should use the bytea field and an Z SQL Methods.
But ho
s me a bit. That make seem connecting to mysql is
> not to be supposed easy.
>
> Is there any alternative to get Zope connected to MySql on Windows
> machines ?
Catonano,
there is a ZopeDA for MySQL on sourceforge. Alternatively if you are
looking for an ODBC connection then please
nothing to do
with Zope or the mxODBC driver.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix
On 2006-06-07 at 16:17:13 [+0200], Davis Mr MR <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> My connection to Postgres keeps failing every couple of hours. I did
> read that there was a problem with some versions of this. I'm using
> 2.0b6 at the moment.
>
> Does anyone have a version number that I can
On 2006-05-04 at 14:18:44 [+0200], Jonas Nielsen <[EMAIL PROTECTED]>
wrote:
> I have the following ZSQL method:
>
> select * from pmember where project=
>
> The result should be about 60 records. However it only works if I set
> "Maximum rows to retrieve" in the "advanced" tab to a number below
On 2006-05-03 at 17:23:32 [+0200], Helena Hartfiel <[EMAIL PROTECTED]> wrote:
> Hi Charlie,
>
> Thank you for your response.
> In fact, I am not familiar with ODBC logs, where can I find it? The database
> is running on a network. The connection used is an eGenix mxODBC Database
> Connection.
>
ine or on a
network?
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mx
alifornia, Berkeley and runs
on a huge range of problems. I prefer it over MySQL but I am not convinced
that switching to PostgreSQL will solve your problems and, of course, will
involve all the work of migration.
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directl
On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe <[EMAIL PROTECTED]>
wrote:
> On 4/6/06, Charlie Clark <[EMAIL PROTECTED]> wrote:
> > This still should not be causing this problem. Jamie, you should be
> > talking
> > to the DBA or looking at the DB side
On 2006-04-06 at 09:51:49 [+0200], Chris Withers <[EMAIL PROTECTED]>
wrote:
> >>> Exception TypeDatabase Error
> >>> Exception Value updatePerson is not connected to a database
> >> What version of Zope/MySQL/mysqldb/ZMySQLDA are you using?
> >
> > Zope is 2.6.4
>
> Good grief. Up
How many concurrent users do you have? I suspect this is not a Zope issue.
Is it possible for you to use our mxODBCZopeDA which gives fine-grained
control over connection pools?
I think you will get further by running Zope in debug mode and seeing
exactly where the problem is, ie. why the co
PythonScript and pass
the result into your ZSQL as a standard DTML variable.
catID = [int(i) for i in catIDs]
Cleaner and quicker than playing the .
Charlie
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and
me the code for that
What an incredibly rude e-mail!
The answer is: read some documentation and also learn how to write to e-mails!
--
Charlie Clark
eGenix.com
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...
On 2006-03-21 at 15:21:29 [+0100], Jimmy small <[EMAIL PROTECTED]> wrote:
> sorry for the double post --
> A python script would be your best bet. You would be able to use that
> in other areas of your site in that case.
At least as long as TALES doesn't support this directly.
In a PythonScript
On 2006-03-20 at 12:01:55 [+0100], Jonas Nielsen <[EMAIL PROTECTED]>
wrote:
> I have an sql statement that given a username it returns a project.
>
> So my first question is: Is it possible to let the statement return a
> string instead of a list. i.e. 'project' instead of ['project'] ?
>
> So,
1 - 100 of 142 matches
Mail list logo