Help with SQL2XML
| From: | Ken Harris | Date: | Mon, 01 Apr 2002 20:31:20 +0000 |
| Subject: | Help with SQL2XML | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-1068@lists.php.net to get a copy of this message | ||
Is anyone using this module, especially with Postgresql? I have tried to use
it and only get an empty xml string back. The documentation says that the
database needs a tableInfo function (which Postgresql has) in the DB module.
I have tried both the direct and indirect methods:
$myclass = new xml_sql2xml
( "pgsql://username:password@host5432/databasename" );
$xmlstring = $myclass->getxml( $sql );
AND
$db = DB::connect ( "pgsql://username:password@host5432/databasename" );
$result = $dbh->query ( "SELECT * FROM users" );
$myclass = new xml_sql2xml ( $db );
$xmlstring = $myclass->getxml( $result );
I get the same results in both cases:
<?xml version="1.0"?>
<root><result></result></root>
Any help would be appreciated.
Ken Harris
Senior Analyst
Lighthouse Information Systems, Inc
(410) 239-9591