INSERT INTO foo () VALUES ()

[prev] [thread] [next] [Date index for 2004/05/25]

From: Simon Cozens
Subject: INSERT INTO foo () VALUES ()
Date: 13:55 on 25 May 2004

I have a table which has only an ID, and everything else is handled in
has-many relationships to it. To add a new item, I'd been doing this:

    Foo->create({});

This works fine on MySQL, but bombs out on SQLite, because "INSERT INTO foo ()
VALUES ()" is arguably not great SQL. I've hacked around it by adding a dummy
column, but is this something that should and can be fixed in CDBI?

        -- 
        Actually Perl *can* be a Bondage & Discipline language but it's unique
among such languages in that it lets you use safe words. 
    -- Piers Cawley

INSERT INTO foo () VALUES ()
Simon Cozens 13:55 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Tony Bowden 14:13 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Simon Cozens 14:35 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Tony Bowden 14:37 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
ed-cdbi 14:42 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Simon Cozens 14:49 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
ed-cdbi 15:13 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
cees-cdbi 15:47 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Branislav Zahradnik 16:20 on 25 May 2004

RE: INSERT INTO foo () VALUES ()
"g 06:00 on 26 May 2004

Re: INSERT INTO foo () VALUES ()
Edward J. Sabol 14:40 on 26 May 2004