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

Garrett Goebel garrett at scriptpro.com
Tue Apr 15 17:30:50 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!



More information about the FreeTDS mailing list