oracle and adodb status report

I would like to update the list on my efforts to use phpList with adodb 
and Oracle. I don't have a complete migration to adodb but would like to 
share what I have learned.

There is a lot of mysql-specific syntax in the code. One way for phpList 
to use different database backends via adodb is to make the sql more 
generic. Generic date data is an issue. Adodb provides some support for 
handling dates but in some cases the only way I could see to keep the 
code generalized was to do the date arithmetic in the code.

The file structure.php is almost entirely mysql "create table" 
statements. I rewrote it into a version more usable with the adodb table 
creation facility, which also slightly simplified other parts of the 
code that referenced the database structure.

Adodb provides a Replace() function call similar to the mysql "replace 
into". I was able to change almost all remaining instances of "replace 
into" with calls to Sql_Replace() in adodb.inc.

If you are targeting Oracle use the adodb driver oci8po, not oci8.

My current set of changes will create a database structure and 
initialise the tables using Oracle as the backend. I can see the setup 
page but have not gotten very far past that due to date handling issues. 
I've also run out of time - these changes were made during work hours 
and I need to move on to other tasks. I will probably try to get a 
stealth mysql database running because phpList has needed functionality.

If anyone would like a copy of the changed code please let me know.

--

-- 
Tim Holliefield
System Administrator
Information Technology
UMUC Europe
+49(0)6221-378281
_______________________________________________
Phplist-developers mailing list
Phplist-developers <at> tincan.co.uk
http://mail.tincan.co.uk/mailman/listinfo/phplist-developers