in reply to Re: Re: Re: Batch DB query -- implementation?
in thread Batch DB query -- implementation?

Bind variables:
Sorry, my terminology is weak here: I wouldn't know whether I was using bind variables even if I was. What I know is that I'm currently using '?' as a place holder so that I don't have to think about properly escaping the data. My current paradigm is: 
my $sth = $dbh->prepare($query)
$sth->execute(@parameterlist)

[download]
(use looping as convenient).

Replies are listed 'Best First'.
Re(4): Batch DB query -- implementation?
by perrin (Chancellor) on Jul 03, 2002 at 16:28 UTC
    That's correct, you are using bind variables.

    Another way to do it, if you really find that network is killing you, is to use whatever batch loader your database provides and just have perl generate the correct file format to feed it.

[reply]

In Section Seekers of Perl Wisdom