[Tue Sep 05 16:06:01 2006] [error] [client 159.121.202.43] [Tue Sep  5 16:06:01 2006] jobmaint.pl: ct_send(CS_DESCRIBE_INPUT) returned 0 at /usr/local/lib/perl5/site_perl/5.8.5/mach/DBD/Sybase.pm line 133., referer: http://website/cgi-bin/jobmaint.pl?jobnum=51129

##</code><code>##

use strict;
use DBI;
use DBD::Sybase;

my $CX = <...database connection info...>

sub executeSelect {
  my($CX, $SQL, $params) = @_;
  my $resultset = [];

  # Get the database handle for the currently selected connection
  my $dbh = _getDBHandle($CX);

  my $sth = $dbh->prepare($SQL);

  my @params = @$params;
  for (my $I = 0; $I <= $#params; $I++) {
    $sth->bind_param($I + 1, $params[$I]);
  }
  $sth->execute();

  while (my @row = $sth->fetchrow_array) {
    push(@$resultset, \@row);
  }
  return $resultset;
}

###  MAIN  ###
my $SQL = qq(
  SELECT JobN, JobDescription, CustomerOrderN, BookedDate, DueDate, Quantity
    FROM OpenJob
   WHERE JobN = ?
ORDER BY DueDate desc);

my $params = [ 68104 ];

my $records = executeSelect($CX, $SQL, $params);