freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: PHP calling Stored Proc on MS-SQL 7 params being missinterpreted as dates

From: "Matt Kynaston" <matt AT online-canarias.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: RE: PHP calling Stored Proc on MS-SQL 7 params being missinterpreted as dates
Date: Fri, 21 Jun 2002 11:16:25 +0100

> Error Message:
> Warning: Sybase error: The conversion of a char data type to a datetime
> data type resulted in an out-of-range datetime value. (severity 16) in
> /www/reports.priv/htdocs/general/R0013.php on line 129

I called stored procs from PHP all the time, though I am using MSSQL2000.
Maybe I'm dumb, but it sounds more like a problem with the sp than freetds.
Does the sp run with those values in Query Analyser? If not, is it comparing
the parameter to a datetime column anywhere?

Matt

PHP calling Stored Proc on MS-SQL 7 params being missinterpreted as dates, Trevor, 06/21/2002
- <Possible follow-up(s)>
- Re: PHP calling Stored Proc on MS-SQL 7 params being missinterpreted as dates, Bill Thompson, 06/21/2002
- RE: PHP calling Stored Proc on MS-SQL 7 params being missinterpreted as dates, Matt Kynaston, 06/21/2002
- Re: PHP calling Stored Proc on MS-SQL 7 params being missinterpreted as dates, Nick Brandon, 06/21/2002