Re: DBI error

[ralphie]

the dbi prepare method is for preparing a statement handle to which one passes values at execution. in your case, i would expect to see something like ...

my $sthD = $dbh->prepare("INSERT into ICD_specifications_for_disea
+se (Range_key, A, B, C, D, E, F, G) VALUES (?,?,?,?,?,?,?);

then you execute the statement with

$sthD->execute(19,'E',9,'430','438');

for example. You can execute a large statement like this, but that would be done with the do() method.

[cchampion]

You are just repeating the same mistake the OP did, i.e. naming eight columns and then passing 5 values.

Moreover, the "prepare" method can work just fine without placeholders. It allows placeholders, but it does not enforce them.

I can't see where the error is, but I am sure the reason is not the one you mentioned.