![]() |
|
Perl-Sensitive Sunglasses | |
PerlMonks |
Interpolating DBI/SQL placeholdersby abclex (Monk) |
on May 11, 2004 at 03:49 UTC ( #352302=perlquestion: print w/replies, xml ) | Need Help?? |
abclex has asked for the wisdom of the Perl Monks concerning the following question: Dear monks, I just wanted to ask if someone has a quick'n'fast solution(tm) or hint for my problem: I generated some SQL string including the related bind values on the fly using SQL::Abstract to query Sybase. Everything works fine for normal queries, but now I have to execute a batch SQL string (I need to select data into a temporary table and then do another select out of there) and it seems that combining placeholders with multiple select statements/batch queries is not supported. Does anyone have an idea how to manually "fill out" the placeholders of the SQL string with the values from the bind array? Or maybe there already exists a module for this... Many thanks in advance! Update: Added some example code:
Back to
Seekers of Perl Wisdom
|
|