On 11/11/05, Ivan Stout <[EMAIL PROTECTED]> 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@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@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 )

Reply via email to