logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: Re: SQLite: column aliases do not work at all: msg#00004

Subject: Re: Re: SQLite: column aliases do not work at all
On Thu, May 20, 2004 at 04:25:40PM +0200, Andreas Schwarz wrote:
> Michael Neumann wrote:
> >On Sun, Apr 11, 2004 at 08:11:27PM +0200, Andreas Schwarz wrote:
> >
> >>require 'dbi'
> >>dbc = DBI.connect('DBI:SQLite:/tmp/test.db')
> >>res = dbc.execute("SELECT column AS alias FROM table")
> >>puts res.fetch_hash.inspect
> >>
> >>Output:
> >>{nil=>"1"}
> >>
> >>sqlite-ruby alone doesn't have this problem.
> >
> >
> >We definitly have to implement the sqlite_compile and sqlite_step
> >functions.
> 
> I started working on it yesterday. With sqlite_compile & _step the huge 
> broken type detection part can be removed, the rest seems to be pretty 
> straightforward.

Right. That seems to be much easier than the current implementation.
I've tried that already using Ruby/DL, but never finished it.

Of course a pure-C version would be slightly faster, but Ruby/DL would
be so great, as it would work without using a compiler.

Regards,

  Michael


<Prev in Thread] Current Thread [Next in Thread>