And here is the output of desc projekte_generisch:
Name Null? Type
PID NOT NULLCHAR(8)
ANFANGNOT NULLVARCHAR2(8)
ENDE VARCHAR2(8)
LAENGENOT NULLNUMBER
I believe the problem has to do with your field type for PID.
Hi,
select * FROM projekte_generisch where trim(pid)=:pid
Thanks Roberto!
This solution with trim() works like a charm!
Cheers,
Manuel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Roberto Mansfield wrote:
PIDNOT NULLCHAR(8)
I believe the problem has to do with your field type for PID. When you run:
select * FROM projekte_generisch where pid='u0test'
Oracle either autotrims or autopads (I'm not sure which) so that
'u0test' matches PID even
Manuel Schölling wrote:
Hi Christopher,
thanks for caring about my problem. ;)
I couldn't reproduce your problem. What does your table look like?
What version of PHP OCI8? What version of Oracle?
I using PHP 5.2.5 on a Linux 2.6.9 machine. The version of OCI8 is 1.2.4
(Revision
Manuel Schölling wrote:
Hi guys,
sorry for spamming your mailing list.
I have a strange problem with ocibindbyname():
I use this simple code to start an SQL query:
But this query doesn't give me any data record (no error; empty resultset).
I couldn't reproduce your problem. What does
Hi Christopher,
thanks for caring about my problem. ;)
I couldn't reproduce your problem. What does your table look like?
What version of PHP OCI8? What version of Oracle?
I using PHP 5.2.5 on a Linux 2.6.9 machine. The version of OCI8 is 1.2.4
(Revision 1.269.2.16.2.38, Oracle Instant
Hi guys,
sorry for spamming your mailing list.
I have a strange problem with ocibindbyname():
I use this simple code to start an SQL query:
$sql = Select * from projekte_generisch where pid=:data;
$conn = oci_connect(secret, secret, secret);
$cur = oci_parse($conn, $sql);
my_dump($conn, $cur,