[DB-SIG] Parameters in DCOracle2
Tue, 20 Aug 2002 10:12:02 +1000
To avoid breaking the index usage, you could try:
cursor.execute("select * from table where nombre like :1||'%'", =
Of course you still have to test the nombre you now have is "SAENS" with =
optional trailing spaces and not "SAENSA", but at least your using the =
database index to only fetch the rows that possible match. I guess the =
ugliness of the extra code is the price for having trailing spaces in the =
>>> Marcos S=E1nchez Provencio <email@example.com> 20/08/2002 =
4:04:36 am >>>
I expect this to break index usage, I suppose...
El lun, 19-08-2002 a las 15:05, Matthew T. Kromer escribi=F3:
> I think you're really after something like
> cursor.execute("select * from table where RTRIM(nombre) =3D =
> Although I'm away from my manual to look up RTRIM to see if you need =
> pass it a 2nd parameter to tell it to trim trailing spaces.
> On Monday, August 19, 2002, at 05:27 AM, Marcos S=E1nchez Provencio =
> > 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 =
> > to
> > thefull length of the column, which is 50. So, the non-parameter =
> > does find
> > results, but the parametrised query only finds results when =
> > the
> > exactnumber of spaces (5 in this case). I can't touch the data in =
> > 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=3D'SAENS'
> >> but not if I say
> >> where nombre=3D: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=20
> >> http://mail.python.org/mailman/listinfo/db-sig=20
> > _______________________________________________
> > DB-SIG maillist - DB-SIG@python.org=20
> > http://mail.python.org/mailman/listinfo/db-sig=20
> DB-SIG maillist - DB-SIG@python.org=20
DB-SIG maillist - DB-SIG@python.org=20