[Zope] Problem Inserting zsql query result

[Peter Bengtsson]

What kind of a strange message is that?
"MySQL server version for the right syntax to use near '0\n)'"
Is that the ErrorValue?

It can't be converted to a long or in because it contains a ) not
because of the \n
What's the SQL you're trying to use? (Only need to see the SELECT ... part)

On 11/11/05, Ivan Stout <aibanhamano at gmail.com> wrote:
> Peter,
>
>  Thank you, but unfortunately I still get the same error due to the newline
> character being there and still cannot remove it with variable.replace. Can
> a "long object" be converted to a string or integer some way?
>
>
>
> On 11/12/05, Peter Bengtsson <peter at fry-it.com> wrote:
> > On 11/11/05, Ivan Stout <aibanhamano at gmail.com> wrote:
> > > Greetings,
> > >
> > >  I would like to insert the results of a query into another table and am
> > > doing this from a python script. I am setting the results of a
> queryequal to
> > > a variable with the following:
> > >
> > >  variable = container.zsql_method(paramater=value)[0][0]
> >
> > Try getting the field out by name, not number.
> > Eg:
> > variable = container.zsql_method(paramater=value)[0]['count']
> > or
> > variable = container.zsql_method(paramater=value)[0]['age']
> >
> > >
> > >  This gives the results I want (in this case "0"), but when I try to
> insert
> > > this variable using another zsql method, I get the following error:
> > >
> > >  "MySQL server version for the right syntax to use near '0\n)'"
> > >
> > >  The value I want is there, but it has a newline character also. I try
> > > removing using .replace but then I get the following error:
> > >
> > >  'long' object has no attribute 'replace'
> > >
> > >  I would greatly appreciate it if someone could point me in the right
> > > direction.
> > >
> > >  Than you very much,
> > >
> > >  Ivan
> > >
> > > _______________________________________________
> > > Zope maillist  -  Zope at zope.org
> > > http://mail.zope.org/mailman/listinfo/zope
> > > **   No cross posts or HTML encoding!  **
> > > (Related lists -
> > >  http://mail.zope.org/mailman/listinfo/zope-announce
> > >   http://mail.zope.org/mailman/listinfo/zope-dev )
> > >
> > >
> > >
> >
> >
> > --
> > Peter Bengtsson,
> > work www.fry-it.com
> > home www.peterbe.com
> > hobby www.issuetrackerproduct.com
> >
>
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>
>
>


--
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com