Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1 5},{d 2003-04-1 5})

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Garrett Goebel <garrett AT scriptpro.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1 5},{d 2003-04-1 5})
  • Date: Tue, 15 Apr 2003 16:30:50 -0500

Lowden, James K wrote:
>
> > From: Garrett Goebel
> >
> > Any ideas on why
> >
> > select datediff(d,{d 2003-04-15},{d 2003-04-15})
> >
> > Would result in a syntax error?
>
> Peering closely at the sent buffer:
>
> > Sending packet @ 2003-04-15 09:04:14.689699
> ...
> > |...3.... select d|
> ...
> > |atediff( d,'2003-|
> ...
> > |04-15',' 2003-04-|
> ...
> > |14'|
>
> What happened to the closing parenthesis?
>
> $dbh->prepare("select datediff(d,{d '2003-04-15'},{d '2003-04-14'}");
> should be
> $dbh->prepare("select datediff(d,{d '2003-04-15'},{d '2003-04-14'})");

oops! thanks for the catch.

> P.S. I'll follow up on the archive searching tonight.

thanks!




Archive powered by MHonArc 2.6.24.

Top of Page