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;"] > > 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. > If you use DB_DataObject_FormBuilder, you can specify a function to convert dates from/to the DB format. Not a great solution, but it's what I'm using right now. AFAIK, DataObject should do it (or maybe DB), but no one's written it yet. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--