Re: DB_DataObject and SQLite

On Mon, 26 Jul 2004 19:12:03 +0530, Nikhil G. Daddikar <ngd@tydalwave.com> wrote: > 1) Has anybody got DB_DataObject to work with SQLite? I tried to use it > but I get the following error: > > [db_error: message="DB Error: DB backend not capable" code=-9 > mode=return level=notice prefix="" info="SELECT name FROM sqlite_master > WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE > type='table' ORDER BY name;"] This means that DB thinks that SQLite is not capable of whatever is being tried. I believe that the DB_DataObject_Generator only officially supports mysql. You can: 1) create the table classes from a mysql DB, then use SQLite when actually using the classes (shouldn't be a problem) 2) create the classes and ini file manually (ick) 3) hack the sqlite DB driver and/or the Generator to allow you to use the generator > > 2) Is DB_DataObject going to do something about database neutral dates? > I am planning to write an app and give the user a choice of mysql or > sqlite. But it looks like I have to do a "if (mysql) then.. else.." to > manipulate dates. > > Any help would be appreciated. > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > !DSPAM:4105096a307022050849632! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--