Hi,
Imagine this code:
Both queries should result in the same data but as soon as I use the binding
no rows are returned. I can't see what I'm doing wrong here. Can someone
help me?
Jos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sorry, trigger happy. Also try ":postalcode" in uppercase.
Neil
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI Binding problem
Hi,
Imagine this code:
Both queries should result in the sa
Jos,
This may or may not sort out the problem, but OCI_ASSOC |
OCI_FETCHSTATEMENT_BY_ROW should be OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW.
Neil
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI Bind
Hi,
Since flags are normally bitmaps, FLAG1 | FLAG2 should have the same result
as FLAG1 + FLAG2. I've tried your suggestion anyway but it had no result.
I've also tried to uppercase :postalcode (in the query and in the bindbyname
call) but that didn't help either.
Jos
-Original Message---
Turns out that it's covered in bug report 30808.
I've applied the edit mentioned there and will see if this solves my
problem (have to wait for the next Oracle restart overnight).
The discussion there is quite revealing about the fact that oci8
connections are always persistent even if you do no
Juffermans, Jos would like to recall the message, "[PHP-DB] OCI Binding
problem".
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Update:
I've found a workaround:
Somehow Oracle will interpret the :postalcode as a numeric value in this
case, eventhough the column is a varchar. By adding '' || Oracle converts it
to a string.
Jos
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 20
Hi Leo,
We are having the same problem. Check out the bug I filed many months ago
http://bugs.php.net/bug.php?id=30808 I can't for the life of me figure out
why the bug is suspended, as this seems to be a common issue with Oracle and
php5. Perhaps you should also and your comments to the bug re
Leo,
Please let me know how that works for you. I don't remember the specifics
(if we where testing using plogon, nlogon or just logon), but we did try and
implement that fix and it didn't work for us.
Thanks,
Michael
-Original Message-
From: Leo D. Geoffrion [mailto:[EMAIL PROTECTE
I am still new to this, but I turned the manual upside down, or at least I
tried.
I am designing a payroll application by which payslips can be processed for
each employee for each period.
The problem lays where I would like to display a list of employees that
don't have transactions (payslips
Hi,
I've been trying to get MySQL 5 installed with php-5.0.4(windows). I'm
getting several messages about entry points not being found in dlls etc
etc. Am I being over optimistic to expect this configuration to work?
Indeed has anyone got it working? If it should work, I'll press on and
When checking for unmatched records, you use a left join as you are
doing. This assures all records are retained from the left side table
(i.e. employees), regardless if there is a matching record or not.
Obviously if you have a filter on the left side table it will narrow
down the result.
Get those with transaction into a php array
Get those without transaction into a php array
Then use array_diff() (or one of its variants)
graeme.
jinxed wrote:
I am still new to this, but I turned the manual upside down, or at least I
tried.
I am designing a payroll application by which payslips
13 matches
Mail list logo