freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "Lowden, James K" <LowdenJK AT bernstein.com>
To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
Subject: RE: PHP calling Stored Proc on MS-SQL 7 params being mi ssinterpreted as dates
Date: Fri, 21 Jun 2002 10:54:32 -0400

> From: Trevor [mailto:trevor.burgess AT haysdx.co.uk]
> Sent: June 21, 2002 5:57 AM

> I am using mssql_* in PHP on my linux box to talk to our
> MS-SQL server via
> freetds. No problems with SELECT statements but when I try to
> use stored
> procedures with parameters I get problems. The scripts work
> on my windows
> machine but fail on the Linux server.
>
> $res = mssql_query("EXEC ap_rpt_r0013_0a @Item='EFD3343'");
>
> I have also tried:
> $res = mssql_query("EXEC ap_rpt_r0013_0a 'EFD3343'");
>
> 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

Trevor,

FreeTDS doesn't interpret your query string; it doesn't care if your query
is, "Why me?".

How does sqsh treat your query?

Regards,

--jkl

RE: PHP calling Stored Proc on MS-SQL 7 params being mi ssinterpreted as dates, Lowden, James K, 06/21/2002