Skip to Content.
Sympa Menu

freetds - Re: PHP calling Stored Proc on MS-SQL 7 params bein g missinterpreted as dates

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Burgess, Trevor - HMS" <Trevor.Burgess AT haysdx.co.uk>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP calling Stored Proc on MS-SQL 7 params bein g missinterpreted as dates
  • Date: Fri, 21 Jun 2002 16:49:16 +0100


I have tried that but the mssql_init,bind and execute functions are windows
only.

Trev

-----Original Message-----
From: Nick Brandon [mailto:nbrandon AT hotmail.com]
Sent: 21 June 2002 13:40
To: TDS Development Group
Subject: [freetds] Re: PHP calling Stored Proc on MS-SQL 7 params being
missinterpreted as dates


Not too sure if this would help, but the PHP manual suggests using
mssql_init for stored procedures.

http://www.php.net/manual/en/function.mssql-init.php

HTH

Nick


> Hi there,
>
> 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
>
> With ver 7.0
>
> and
>
> ver 4.2 returns no rows.
>
> I have been using
>
> SuSE Linux 7.2 and 8.0
> PHP 4.2.1
> freetds 0.53
> Apache 1.3.24
> MS-SQL 7.0 on NT4
>
> Help..! thanks
>
> Trevor

---
You are currently subscribed to freetds as: [trevor.burgess AT haysdx.co.uk]
To unsubscribe, forward this message to
$subst('Email.Unsub')


**********************************************************************
This message (including any attachments) is confidential and may be
legally privileged. If you are not the intended recipient, you should
not disclose, copy or use any part of it - please delete all copies
immediately and notify the Hays Group Email Helpdesk at
email.helpdesk AT hays.plc.uk
Any information, statements or opinions contained in this message
(including any attachments) are given by the author. They are not
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.

A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**********************************************************************





Archive powered by MHonArc 2.6.24.

Top of Page