Re: Refering to Data binding

On 11 May 2006 08:05:45 -0700, goliathuy <mario.albornoz@gmail.com> wrote: > I'm tring to do some mass insertion, so i'm using data binding, now the > question is that i have (for the moment) a some field that will get the > same value. > is there a way to make it while on prepare? So that i only pass one > value to the execute?? Not really. > One more thing... could i prepare a group of insertions together? > Like: "INSERT INTO theTable (field1, field2, field3....) > VALUES (?, ?, ?, ...); > INSERT INTO theSubTable(fieldA, fieldB, fieldC,...) > VALUES (?, ?, ?, ...);" Yes. You'll need to supply values for all the placeholders, and you shouldn't try and mix SELECT with INSERT (etc), but otherwise you'll be OK. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/