Re: [Zope] Problem Inserting zsql query result
Chris, I was preparing to reply to your e-mail when I discovered the problem. I had been assuming it was the query zsql method value that was the problem (due to the 0\n error), when it was actually a typo in the insert zsql method (I had failed to add a , when adding the additional field to insert . . . my eyes must be getting old). Anyway, I will try not to make so many assumption when I run it future bugs. Thank you for your help, Ivan On 11/15/05, Chris Withers [EMAIL PROTECTED] wrote: Ivan Stout wrote: Yes, the full error message is the following: ProgrammingError: (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0\n)' at line 9) Here is the select portion of the query I am running: select count(*) as orderI'd look for the bit of your SQL that is '0' at the end of a line ;-) What's your full ZSQL? (well, actually, boil it down to a minimal testcase that fails...)cheers,Chris--Simplistix - Content Management, Zope Python Consulting- http://www.simplistix.co.uk ___ 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 )
[Zope] Problem Inserting zsql query result
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] 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 )
Re: [Zope] Problem Inserting zsql query result
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 [EMAIL PROTECTED] wrote: 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'] orvariable = 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.comhome 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 )
Re: [Zope] Problem Inserting zsql query result
Yes, the full error message is the following: ProgrammingError: (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0\n)' at line 9) Here is the select portion of the query I am running: select count(*) as orderOn 11/12/05, Peter Bengtsson [EMAIL PROTECTED] wrote: 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 ) notbecause 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] wrote: 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-announcehttp://mail.zope.org/mailman/listinfo/zope-dev )--Peter Bengtsson, work www.fry-it.comhome www.peterbe.comhobby 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 )
Re: [Zope] Re: Text field and module import questions
Martijn, Thank you very much. Just as you said, there was aspace in between openning and closing tags, but the reason I missed it was becauseI had indented likethe following:_textarea name=var _/textarea since it was part of an if tag block. So I changed it like the following:_textarea name=var/textarea Anyway, thanks again. I will pay much closer attention to how I format my code in the future. Cheers. On 9/19/05, Martijn Pieters [EMAIL PROTECTED] wrote: Ivan Stout wrote: It appears that the text input field I have created using a dtml method has a default space character when you click in the field. Is there a way to get rid of this?Depends on the HTML used; this is really a HTML question more than a DTMLquestion.If this is a textarea, make sure there are no spaces between the openingand closing tags: textarea ..attrs../textareaor, if you fill the textarea from with a dtml attribute, eliminate thespaces there too:textarea ..attrs..dtml-variablename;/textarea If you need multiple lines to avoid excessive wrapping or scrolling, putthe angle brackets on a new line to eliminate whitespace (newlines arewhitespace too!):textarea ..attrs..dtml-var expression_or_variable ..attrs.. /textareaIf you used an input tag, the same applies, but now to whitespace betweenthe quotes of the value attribute.Martijn Pieters___ Zope maillist-Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!** (Related lists -http://mail.zope.org/mailman/listinfo/zope-announcehttp://mail.zope.org/mailman/listinfo/zope-dev ) ___ 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 )
[Zope] Text field and module import questions
Greetings, It appears that the text input field I have created using a dtml method has a default space character when you click in the field. Is there a way to get rid of this? Also, I have a python script that I would like to import a python module, but when I run it Zope complains the user does not have authorization. Is there a way around this? Thanks. 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 )
