On Friday 15 July 2011 02:55:55 Mr. Puneet Kishor wrote:

Here is the interesting thing -- if I add the -D switch to the second app

as well, it fails to return the polys and the points. It fails with the

error

{"error":"Warning caught during route execution: DBD::mysql::st

fetchall_arrayref failed: fetch() without execute() at

<path/to>/macrostrat.pm line 79.\n"}

The offending lines are

   71> my $sql = qq{

   72>    ..

   73>

   74>

   75> };

   76>

   77> my $sth = $dbh->prepare($sql);

   78> $sth->execute();

   79> my $res = $sth->fetchall_arrayref({});

The above could be just correlation rather than causal, but it definitely

seems to be a pattern. First, this is bizarre, and why so? And, two...

this is totally bogus... how can execute() not take place above? Perl

doesn't have a habit of jumping over lines, does it?

You haven't actually performed any error checking;