[DB-SIG] Parameters in DCOracle2
Matthew T. Kromer
Mon, 19 Aug 2002 09:05:18 -0400
I think you're really after something like
cursor.execute("select * from table where RTRIM(nombre) =3D :1",=20=
Although I'm away from my manual to look up RTRIM to see if you need to=20=
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 =
> thefull length of the column, which is 50. So, the non-parameter query=20=
> does find
> results, but the parametrised query only finds results when providing=20=
> exactnumber of spaces (5 in this case). I can't touch the data in the=20=
> 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
> DB-SIG maillist - DB-SIG@python.org