Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Why does my insert work with DBI but fails with DBIx::Simple?

by tobyink (Abbot)
on Feb 18, 2013 at 10:14 UTC ( #1019314=note: print w/ replies, xml ) Need Help??


in reply to Why does my insert work with DBI but fails with DBIx::Simple?

I guess that DBIx::Simple takes care of quoting issues, so you should not be adding single quotes to your values. The other main difference that I can see is that you're not populating the final int in the broken script.

package Cow { use Moo; has name => (is => 'lazy', default => sub { 'Mooington' }) } say Cow->new->name
f


Comment on Re: Why does my insert work with DBI but fails with DBIx::Simple?
Re^2: Why does my insert work with DBI but fails with DBIx::Simple?
by karlgoethebier (Curate) on Feb 18, 2013 at 10:46 UTC

    Hi tobyink,

    You are right, it should be push @row, $some_ID;.

    I added the last column after i switched to DBI and forgot it in the broken example, sorry.

    Unfortunatly fixing this and omitting the quotes brought no success. I'm getting still the same error.

    Thanks and regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1019314]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2014-07-12 23:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (242 votes), past polls