[dev] Re: dev Digest, Vol 631, Issue 2

[Alan Wood]

Hi,

I would like to submit a patch to the framework SQL/SQL.php file. This was
needed to allow the DataTree to work with Oracle9i. I cannot confirm whether
this works with other versions, but it does with Oracle 9.2.0.1.

This has allowed me to see the created mnemo notes and genie wishlists.

I am assuming that this is the correct place for this, but please tell me if I
am wrong.
As far as I can tell, this is still against the most recent version, but could
not see

--- SQL.php.orig 2004-01-27 21:31:21.000000000 +0000
+++ SQL.php 2004-01-27 21:38:44.000000000 +0000
@@ -40,6 +40,11 @@
// ~ for greater backwards compatibility.
return sprintf(\'CASE WHEN CAST(%s AS VARCHAR) ~ \\\'^-?[0-9]+$\\\'
THEN (CAST(%s AS INTEGER) %s %d) <> 0 ELSE FALSE END\', $lhs, $lhs, $op,
(int)$rh
s);

+ case \'oci8\':
+ // Oracle uses & for variables... We need to use the bitand fun
ction
+ // that is available, but may be unsupported.....
+ return sprintf(\'bitand(%s,%d) = %d\', $lhs, (int)$rhs, (int)$rhs
);
+
default:
return sprintf(\'%s %s %d\', $lhs, $op, (int)$rhs);
}


I hope this helps. Also, is there a good way of submitting the oracle table
creation scripts I had to create?

Alan Wood

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.