Re: Re: Undefined property

Ok, this should be fixed in CVS http://lists.php.net/article.php?group=php.pear.cvs&article=6144 I've also fixed the escaping on update and insert, so it should be postgres/oracle... etc. compatible. http://lists.php.net/article.php?group=php.pear.cvs&article=6128 Can you check it out from CVS, otherwise I can send you a package file. - It would be nice to get this all working before I release 0.5 Regards Alan mclinden@informed.net wrote:

on line 152 of generator.php this line is commented out. //print_r($this->_definitions); if you turn it back on and send the results, It should begin to track down the problem. Well, there is much to send. But, basically, what I get (truncated for a single table) is: CREATING FOR oci8://yyy:xxx@xxx.yyy.org:1621/zzz

CONNECT       : NEW CONNECTION
CONNECT       : oci8://yyy:xxx@xxx.yyy.org:1621/zzz 7af141281156d109429773e9e03a6cda
CONNECT       : a:1:{s:32:"7af141281156d109429773e9e03a6cda";O:7:"db_oci8":25:{s:10:"connection";i:0;s:7:"phptype";s:4:"oci8";s:8:"dbsyntax";s:4:"oci8";s:11:"manip_query";a:0:{}s:13:"prepare_types";a:0:{}s:10:"autoCommit";i:1;s:9:"last_stmt";b:0;s:6:"_debug";b:0;s:19:"_default_error_mode";N;s:22:"_default_error_options";N;s:22:"_default_error_handler";s:0:"";s:12:"_error_class";s:8:"DB_Error";s:16:"_expected_errors";a:0:{}s:8:"features";a:4:{s:7:"prepare";b:0;s:8:"pconnect";b:1;s:12:"transactions";b:1;s:5:"limit";s:5:"alter";}s:13:"errorcode_map";a:10:{i:900;i:-2;i:904;i:-19;i:923;i:-2;i:942;i:-18;i:955;i:-5;i:1476;i:-13;i:1722;i:-11;i:2289;i:-18;i:2291;i:-3;i:2449;i:-3;}s:4:"type";N;s:14:"prepare_tokens";N;s:16:"prepared_queries";N;s:15:"prepare_maxstmt";i:0;s:10:"last_query";s:0:"";s:9:"fetchmode";i:1;s:22:"fetchmode_object_class";s:8:"stdClass";s:7:"options";a:5:{s:10:"persistent";b:0;s:8:"optimize";s:11:"performance";s:5:"debug";i:0;s:14:"seqname_format";s:6:"%s_seq";s:8:"autofree";b:0;}s:3:"dbh";N;s:3:"dsn";a:9:{s:7:"phptype";s:4:"oci8";s:8:"dbsyntax";s:4:"oci8";s:8:"username";s:3:"yyy";s:8:"password";s:3:"xxx";s:8:"protocol";s:3:"tcp";s:8:"hostspec";s:14:"xxx.yyy.org";s:4:"port";s:4:"1621";s:6:"socket";b:0;s:8:"database";s:3:"zzz";}}} 

Array ( [ZIPCODE] => Array

       (
           [0] => stdClass Object
               (
                   [table] => ZIPCODE
                   [name] => ZIP
                   [type] => CHAR
                   [len] => 5
                   [format] =>
                   [nullable] =>
                   [default] =>
               )

            [1] => stdClass Object
               (
                   [table] => ZIPCODE
                   [name] => CITY
                   [type] => VARCHAR2
                   [len] => 30
                   [format] =>
                   [nullable] =>
                   [default] =>
               )

            [2] => stdClass Obje
                   [format] =>
                   [nullable] =>
                   [default] =>
               )

            [3] => stdClass Object
               (
                   [scalar] => 3
               )

       Many tables do not have a primary key.

Thanks. Sean