Re: DBD::Sybase prepare statement returns empty query hash but no errstr

[Jenda]

OT, not even Sybase cares about newlines so there's no need to bend over backwards with all those quotes and dots.

 my $query = $db->{dbh}->prepare( "
declare \@skiprows int, \@getrows int;
select \@skiprows = $skiprows;
select \@getrows = $getrows;

set rowcount \@skiprows;
select * into #debt from debt
order by debt_id, debt_no asc;

set rowcount \@getrows;
select * from debt where
(debt_id NOT IN ( select * from #debt ) )
ORDER BY debt_id, debt_no ASC" );

[jcb]

I use a similar syntax for lining up my source code:

my $st = $dbh->prepare
  (q[SELECT foo, bar, baz FROM whatever]
  .q[    WHERE foo = xyz AND bar IS NOT NULL AND ...]);

[Jenda]

The thing is there's no need to close and reopen the string literal. You are working too hard and if you then need to copy&paste the SQL elsewhere you have to work again.

my $st = $dbh->prepare(q[
  SELECT foo, bar, baz
    FROM whatever
   WHERE foo = xyz AND bar IS NOT NULL AND ...
]);

[jcb]

You do have to close and reopen the literal if you want Emacs to indent your code properly. Emacs indentation commands will not change multi-line string constants.