Re: Re: Calling MSSQL Stored Procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Mark Rees wrote:



The type problem in not in PHP but in SQL Server. The sp expects an input
parameter of type datetime, and it isn't getting one.

http://www.php.net/function.mssql-query has the answer to this question,
which is to supply the parameter as varchar and use CONVERT in the sp to
change it into a datetime

As other programs, not under my control, are already using that Stored Procedure altering it is really not a good idea.


--

Regards,
Alf Stockton		www.stockton.co.za

Good day for overcoming obstacles.  Try a steeplechase.

My email disclaimer is available at www.stockton.co.za/disclaimer.html

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux