> > What version of Zope/MySQL/mysqldb/ZMySQLDA are you using?
>
> Zope is 2.6.4
> MySql is 3.22.32
> ZMySQLDA 2.0.8
>
> i don't know the version of mysqldb.
I think this is 0.9.
Jamie
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailm
Hi Dieter,
On 4/5/06, Dieter Maurer <[EMAIL PROTECTED]> wrote:
> Jamie O'Keefe wrote at 2006-4-5 01:32 -0400:
> >I have written a series of zope pages for a person to update their
> >record in our mysql database. They use a zpt->python->db sql->db
> >driver->db flow and work pretty well.
> >
> >
Hi Chris
On 4/5/06, Chris Withers <[EMAIL PROTECTED]> wrote:
> Jamie O'Keefe wrote:
> > try:
> > result = context.updatePerson(**query_args)
> > return text
> > except Exception:
>
> This is insane code. If you want to get mailed errors, look at the
> MailingLogger product.
Did. What if you
Jamie O'Keefe wrote at 2006-4-5 01:32 -0400:
>I have written a series of zope pages for a person to update their
>record in our mysql database. They use a zpt->python->db sql->db
>driver->db flow and work pretty well.
>
>Unfortunately, if enough people use it, the number of open db
>connections g
Matthew Fairclough wrote:
What is the exact error? Please show us the complete traceback from
the error.log and the complete ZSQL-Method, please.
Many thanks. Full query is:
select * from category where
Arguments in ZSQL method are: clientID=0 qID=0 clientAssocList=0
qList=0
Entry in tes
On 2006-04-05 at 07:32:46 [+0200], Jamie O'Keefe <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> I have written a series of zope pages for a person to update their
> record in our mysql database. They use a zpt->python->db sql->db
> driver->db flow and work pretty well.
>
> Unfortunately, if enough peop
On 2006-04-05 at 10:39:11 [+0200], Matthew Fairclough
<[EMAIL PROTECTED]> wrote:
> Chris,
>
> Thanks for your help.
>
> Basically I just want to limit the result to a number of entries based on
> Id.
>
> As there are several Id's I'm trying for "... where catId IN (x, y, z)".
>
> I could jus
Chris,
Thanks for your help.
Basically I just want to limit the result to a number of entries based on Id.
As there are several Id's I'm trying for "... where catId IN (x, y, z)".
I could just use a variable that is a list (through REQUEST) but I would like to
ensure the argument is an integer,
>What is the exact error? Please show us the complete traceback from the
>error.log and the complete ZSQL-Method, please.
Many thanks. Full query is:
select * from category where
Arguments in ZSQL method are:
clientID=0 qID=0 clientAssocList=0 qList=0
Entry in test page is:
ClientAssocList:
Jamie O'Keefe wrote:
try:
result = context.updatePerson(**query_args)
return text
except Exception:
This is insane code. If you want to get mailed errors, look at the
MailingLogger product.
The traceback error is:
Exception Type Database Error
Exception Value updatePe
Matthew Fairclough wrote:
Hi,
Really frustrated by this.
No need to tell us twice ;-)
type=int is for int's only, you're talking about a list of ints...
I want catId to be a list: ie [4, 6, 8].
Hmm, dunno what sqltest does... what are you actually looking to do here?
cheers,
Chris
11 matches
Mail list logo
