RE: Different types of prepare statements

2004-07-29 Thread CAMPBELL, BRIAN D (BRIAN)
Technically the question and answer is OT (off topic) because the difference has to do with Perl quoting features and is not specific to DBI. However, it does illustrate some techniques that can make the SQL passed to DBI calls more readable (IMHO) than when you use conventional quotes ("" or '').

Re: Different types of prepare statements

2004-07-29 Thread Hardy Merrill
My comments(HM>>) are below. Sorry for the poor message quoting - thanks to Groupwise on Windoze XP. >>> "Robert" <[EMAIL PROTECTED]> 07/29/04 11:51AM >>> I have seen: my $sth = $dbh->prepare( <> I've never used this method but there's no reason it shouldn't work. This uses what perl calls "Her