> -----Original Message----- > From: Erik Colson [mailto:[EMAIL PROTECTED] > Sent: Monday, January 28, 2008 10:19 AM > To: DBIx::Class user and developer list > Subject: Re: [Dbix-class] DBF access ? > > On Fri, Jan 25, 2008 at 08:31:17AM +0000, Matt S Trout wrote: > > On Fri, Jan 25, 2008 at 07:52:20AM +0100, Erik Colson wrote: > > > Hello > > > > > > I'm using DBIx::Class for accessing data in Mysql which does work > great. > > > I now would like to use DBIx::Class with DBF (Foxpro or DBase data > files). > > > Is this possible ? What would be the best approach ? Would there be > some limitations ? > > > > If there's a DBD then it probably is possible, though you may need to > write > > something to handle last_insert_id work since IME that's different > with every > > DBD ... > > The best way seems to use DBD::ODBC on a windows platform and then use > the foxpro driver. > however I'm falling into this problem : > > DBIx::Class does generate SELECT statements like this : > > SELECT me.field FROM table me WHERE (me.field=?) :'a_key' > > This is not accepted by the foxpro driver which wants : > > SELECT me.field FROM table me WHERE (me.field='a_key') > > So, I can circumvent this problem by useing search_literal, but this > stops working when DBIx::Class magic starts most of its magic. > Therefor I'm searching for a way to add the possibility to change the > SQL layout.. is this already implemented somewhere? if not, where > should I do this ? > > Thanks for help > > -- > Erik >
Have a look at DBIx::Class::Storage::DBI::Sybase. It uses DBIx::Class::Storage::DBI::NoBindVars to solve the same problem for Sybase. - Alan _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
