Re^2: DBD:Oracle::db prepared error

my $qmark = join(',', ('?') x @row);
$sth = $dbv->prepare( "INSERT INTO DL_SWIPE VALUES( $qmark )" );
$sth->execute( @row );
[download]

Much easier to read and maintain. You knew that ...

------
We are the carpenters and bricklayers of the Information Age.

Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

I shouldn't have to say this, but any code, unless otherwise stated, is untested

Comment on Re^2: DBD:Oracle::db prepared error Download Code

Replies are listed 'Best First'.
Re^3: DBD:Oracle::db prepared error by rdfield (Priest) on Aug 20, 2004 at 13:53 UTC
`$dbv->do("INSERT INTO DL_SWIPE VALUES( $qmark )",undef,@row);` [download] You knew that... rdfield	[reply] [d/l]
Re^4: DBD:Oracle::db prepared error by dragonchild (Archbishop) on Aug 20, 2004 at 14:13 UTC
laughs Actually, I never use do(), preferring to always prepare_cached() as I'm usually in a persistent environment reusing the same queries over and over. But, touche! :-) ------ We are the carpenters and bricklayers of the Information Age. Then there are Damian modules.... sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon.* - flyingmoose I shouldn't have to say this, but any code, unless otherwise stated, is untested	[reply]