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: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafoneomnitel.it>
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: Wed, 16 Apr 2003 08:36:42 +0200

>
> 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!

Unfortunally escape are not fully supported... On some condition brackets are
removed however full support for SQLNativeSql is under way..

freddy77

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