freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

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!

RE: [freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1 5},{d 2003-04-1 5}), Lowden, James K, 04/15/2003
- <Possible follow-up(s)>
- RE: [freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1 5},{d 2003-04-1 5}), Garrett Goebel, 04/15/2003
- RE: [freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1 5},{d 2003-04-1 5}), ZIGLIO Frediano, 04/16/2003