[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 02: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