Skip to Content.
Sympa Menu

freetds - RE: [freetds] intermittent empty results

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] intermittent empty results
  • Date: Mon, 28 Jun 2004 16:44:44 +0200

On Mon, 2004-06-28 at 15:36, Thompson, Bill D (London) wrote:
> David,
>
> > my $dbh = DBI->connect($dsn, $USER, $PASSWORD) or die 'connect';
> > my $sth = $dbh->prepare($sql);
> > $sth->execute;
>
> At the moment I'm a *little* sceptical (without any hard and fast evidence
> yet) of the "prepare" functinality within ct-library.

The prepare() in this case (SQL without placeholders) actually only
stores the query internally.

The execute() then sends the query to the server via
ct_command(CS_LANG_CMD) / ct_send().

Running with DBI->trace(3) should illustrate the API calls used.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html






Archive powered by MHonArc 2.6.24.

Top of Page