Re: Invalid Operating System

[prev] [thread] [next] [lurker] [Date index for 2006/12/17]

On Dec 17, 2006, at 4:26 AM, H.Merijn Brand wrote:
> my $sth = $dbh->prepare (qq;
>     select foo, bar
>     from   baz
>     where  duh = ?;
>     );

BAD idea, because semicolons are semantically meaningful in SQL. As 
soon as you have a more complex block you're hosed. And since double 
quotes are rare in SQL (you only need them when you're using a keyword 
as a literal, which is a bad idea all round) plain strings work better.

set sql "
   SELECT foo, bar
     FROM baz
    WHERE duh = ?;
"

If you can't do that in your favorite language, then perhaps it 
shouldn't have blindly borrowed C string syntax.

• H.Merijn Brand 10:26 on 17 Dec 2006
  • Martin Ebourne 11:13 on 17 Dec 2006
  • Earle Martin 12:42 on 17 Dec 2006
  • Peter da Silva 14:35 on 17 Dec 2006
• David Landgren 17:00 on 17 Dec 2006
• David Cantrell 01:14 on 20 Dec 2006

Generated at 22:02 on 27 Dec 2006 by mariachi 0.52