[freetds] ODBC: syntax error? select datediff(d,{d 2003-04-1
5},{d 2003-04-1 5})
ZIGLIO Frediano
Frediano.Ziglio at vodafoneomnitel.it
Wed Apr 16 09:36:42 EDT 2003
>
> 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
More information about the FreeTDS
mailing list