Wonderful. It's always nice when you find out that, not only does your
idea have merit, but someone else has already figured out the details.
Time to start refactoring...
--TWH
On Jul 29, 2004, at 6:06 PM, Jeff Zucker wrote:
Tim Howell wrote:
> Does anyone know of a module that allows querie
You can even avoid writing extra four lines of code ( ..foreach loop.. )
with this line.
$statement->execute(@sbval);
This also takes care of numeric fields, if database is smart enough to
convert internally ( Oracle does ).
Ravi
Helck, Timothy wrote:
You can get single quotes around your value
You can get single quotes around your values with this line:
my $temval = "('".join("','",@sbval )."')";
However, Mark's solution is much better, especially if your list of values includes a
number.
-Original Message-
From: Nettlingham, Mark [mailto:[EMAIL PROTECTED]
Sent: Friday, July 3
In order to get quoting to work, your best bet is to use placeholders, which
are automatically populated/quoted for you. My solution would be (and I'm no
expert):
Replace:
$temval = "(".join(",",@sbval ).")";
With:
$temval = "(".join(", ", map("?", @sbval)).")";
(which creates a string : "?,?,?,?,
I am onsite at a client, and they use AIX/DB2-UDB
V8. They have an automated scheduling package that starts jobs using "su" super
user, and then passes the account like a nohup would do. My problem is that the
dbi connect seems to require a password, but I do not have access to the
password.
Hi,
I have been trying to read data from a hash and put it into myaql using
insert into statement.
foreach $key (keys %submt_feat)
{
if($submt_feat{$key}){
$submt_feat{$key}= $submt_feat{$key};
push(@sbft,$key);
push(@sbval,$submt_feat{$key});
}
}
$temfeat = "(".join