Ok, Jim, Let´s go again... ----- Original Message ----- From: "Jim Penny" <jpenny@universal-fasteners.com> To: "Antonio Carrasco" <antoniojezu@hotmail.com> Sent: Thursday, August 23, 2001 11:16 PM Subject: Re: [Zope] Zope/PostgreSQL/PoPy
On Wed, Aug 22, 2001 at 10:57:55PM +0200, Antonio Carrasco wrote:
----- Original Message ----- From: "Jim Penny" <jpenny@universal-fasteners.com> To: <zope@zope.org> Sent: Thursday, August 23, 2001 10:30 PM Subject: Re: [Zope] Zope/PostgreSQL/PoPy
Sorry, I?m spanish and my english is not good at all. Mmmm.... Which version? I can?t answer you until tomorrow morming at
work,
but I think they?re both latest version. There are another mail in the list with my same problem. My code:
No problem with your language, it is clear enough.
While we are doing version checking, which zope and which python?
sqlGetWorkers Arguments: id:int Query: select from Departments where <dtml-sqltest id op=eq type=int>
get rid of the op=eq and try
select from Departments where name=<dtml-sqlvar name type=string> I tried it.
Also, does select from Departments where name='<dtml-var name sql_quote>' work?
I have tried it. And I have tried another ways. But nothing. I have been today two hours making and thinking different ways. My last try is find someone who can make the query without problems in this list. Farrell seems to be. But in RedHat. Tomorrow I´m going to write and specifie all the products version data and OS used(It´s Linux, but I can´t remember now more). Thanks again. Jim Antonio Carrasco
Also, I worry about Departments. PostgreSQL is case sensitive. You are sure it is created as Departments and not departments?
I think it isn´t either my problem, because I can access the table Departments with the argument id or writing select * from Departments where name='nameOfDepartment';
works successfully but this... sqlGetWorkers Arguments: name:string Query: select from Departments where <dtml-sqltest name op=eq type=string>;
doesn?t work, but this... select from Departments where name='nameOfDepartment'; works successfully too. It?s a very strange error. Zope only raises an
error
with string or nb type arguments. I?ve tried a lot of ways to do it, putting ",',nothing, with sqlvar, but it always raises the error.
Thanks for your time, Jim. Antonio
I can assure you that there are no such problems prior to 2.0.5, and I really suspect that there are no such problems in 2.0.7, although I don't have a machine at hand that I can safely test it on. (I will be able to test tonight).
I suspect that the lack of response you are getting is because it is SO outside the experience of everyone else that no-one has the least clue of what is happening to you.
Russell: are you also saying that you can now connect to your database and that ZSQL methods containing references to type=string are failing?
Jim Penny
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )