Re: Question About Proper Use of Bind Variables in Perl DBI Scripts

Yes, prepare the query once outside the subroutine, then let the subroutine execute the already prepared query multiple times.

Comment on Re: Question About Proper Use of Bind Variables in Perl DBI Scripts

Replies are listed 'Best First'.
Re^2: Question About Proper Use of Bind Variables in Perl DBI Scripts by RazorbladeBidet (Friar) on Mar 24, 2005 at 17:48 UTC
Or you may want to examine using prepare_cached (take note of the warnings, however) -------------- "But what of all those sweet words you spoke in private?" "Oh that's just what we call pillow talk, baby, that's all."	[reply]
Re^2: Question About Proper Use of Bind Variables in Perl DBI Scripts by JPD (Novice) on Mar 28, 2005 at 15:21 UTC
JZed: Your suggestion was very easy to implement and it worked perfectly. Thanks! JPD	[reply]