[DB-SIG] Parameters in DCOracle2

[Marcos Sánchez Provencio]

I expect this to break index usage, I suppose...

El lun, 19-08-2002 a las 15:05, Matthew T. Kromer escribió:
> I think you're really after something like
> 
>       cursor.execute("select * from table where RTRIM(nombre) = :1", 
> nombre)
> 
> Although I'm away from my manual to look up RTRIM to see if you need to 
> pass it a 2nd parameter to tell it to trim trailing spaces.
> 
> 
> On Monday, August 19, 2002, at 05:27 AM, Marcos Sánchez Provencio wrote=
:
> 
> > First, thank you for your help, I have found out several new things.
> >
> > The value is stored in the table as 'SAENS     ' with spaces, but _not_=
 
> > to
> > thefull length of the column, which is 50. So, the non-parameter query 
> > does find
> > results, but the parametrised query only finds results when providing 
> > the
> > exactnumber of spaces (5 in this case). I can't touch the data in the 
> > table. Is
> > theresome way to get the same results as a SQL*Plus window?
> >
> > PS. I use now named parameters correctly. Thanks.
> >
> >> Hello, I am having a problem trying to get some data from an Solaris
> >> Oracle 7.3.3 server. I use the 8.1.7 client in the same machine. The
> >> problem is as follows:
> >>
> >> I get results if I say
> >>
> >>    where nombre='SAENS'
> >>
> >> but not if I say
> >>
> >>    where nombre=:p1
> >>
> >> and pass a parameter 'SAENS', fetchall returns an empty list
> >>
> >> It is funny that I get some results if I say
> >>
> >>    where nombre between :p1 and :p1 || 'Z'
> >>
> >> or (almost) what I want by saying
> >>
> >>    where nombre like :p1 || ' %'
> >>
> >> I have been puzzled by Oracle since I am using it (I had used Sybase
> >> before). Is this an Oracle issue or a Python one?
> >>
> >> Thank you very much
> >>
> >>
> >>
> >> _______________________________________________
> >> DB-SIG maillist  -  DB-SIG@python.org
> >> http://mail.python.org/mailman/listinfo/db-sig
> >
> >
> >
> >
> > _______________________________________________
> > DB-SIG maillist  -  DB-SIG@python.org
> > http://mail.python.org/mailman/listinfo/db-sig
> 
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig