Re: Re: Calling MSSQL Stored Procedure

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