[Zope] Zope/PostgreSQL/PoPy

[Antonio Carrasco]

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 )
> > >
> >
>