First, you should be using PrepareSP() instead of Prepare() to call a
stored procedure. Second, the PHP mssql extension does not appear to be
able to bind directly to a datetime parameter. If you cannot rewrite the
procedure, then you should install the odbtp extension
(http://odbtp.sourceforge.n
Quoting Luis Ferro <[EMAIL PROTECTED]>:
> Instead of doing a somefile.php#ref do a somefile.php?jump=ref and then
> in the somefile.php add a mix of javascript/php to perform the "jump"...
>
> That is a workaround and should work in any browser that uses javascript.
>
> Of course, if javascript is
Hi,
Have you tried using the SQL Profiler??? This can output everything
that happens on the SQL Server, and specifically only output data on
SPs that execute.
So, if you put a print command inside your SP which prints the date
that it "should" be receiving, you may be able to work out of it i
> >
> >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
> >ch
The other programs I spoke of in my earlier email that are already using
that sp are written in C# not php.
--
Regards,
Alf Stocktonwww.stockton.co.za
Give him an evasive answer.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (h
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
ch
> > Mark Rees wrote:
> >
> >>>
> >>> I get 2005/09/16 10:09:22 AM which is exactly the same format as it
> >>> appears in the database table when viewed via Enterprise Manager.
> >>>
> >>
> >>
> >> I wouldn't set too much store by how it looks in EM. It is a datetime
> >> value,
> >> so its interna
M. Sokolewicz wrote:
Alf Stockton wrote:
Mark Rees wrote:
I get 2005/09/16 10:09:22 AM which is exactly the same format as it
appears in the database table when viewed via Enterprise Manager.
I wouldn't set too much store by how it looks in EM. It is a
datetime value,
so its intern
Alf Stockton wrote:
Mark Rees wrote:
I get 2005/09/16 10:09:22 AM which is exactly the same format as it
appears in the database table when viewed via Enterprise Manager.
I wouldn't set too much store by how it looks in EM. It is a datetime
value,
so its internal representation will b
Instead of doing a somefile.php#ref do a somefile.php?jump=ref and then
in the somefile.php add a mix of javascript/php to perform the "jump"...
That is a workaround and should work in any browser that uses javascript.
Of course, if javascript is turned off the user is always stuck to the
top
> >>I get
> Please suggest what data type you would use. In the database the
> requisit field is a datetime but I cannot find in either adodb or php
> document a datetime type.
I suggest you augment your research with google:
http://www.google.co.uk/search?hs=tAt&hl=en&client=firefox-a&rls=org.
Mark Rees wrote:
I get 2005/09/16 10:09:22 AM which is exactly the same format as it
appears in the database table when viewed via Enterprise Manager.
I wouldn't set too much store by how it looks in EM. It is a datetime value,
so its internal representation will be quite different.
It
>
> >>I have to access a MsSQL stored procedure coded as follows :-
> >>
> >>CREATE PROCEDURE spGetActivePromotions
> >> @Today datetime
> >>AS
> >>SELECT PromotionID, PromotionName, StartDate, EndDate, LastDrawDate,
> >> MaxDraws, NumRegTickets, VouchersPermitted, NumTicketsPerVoucher,
> >
Bob Stout wrote:
Bob Stout wrote:
Although it works fine with Firefox, whenever I use a object
to open a PHP file in a frame, with an internal reference, it ignores
the reference. IOW, if the link I want in the frame is "somefile.php",
everything works OK. If, instead, the link I want in the
Mark Rees wrote:
I have to access a MsSQL stored procedure coded as follows :-
CREATE PROCEDURE spGetActivePromotions
@Today datetime
AS
SELECT PromotionID, PromotionName, StartDate, EndDate, LastDrawDate,
MaxDraws, NumRegTickets, VouchersPermitted, NumTicketsPerVoucher,
ManualTicketIss
> I have to access a MsSQL stored procedure coded as follows :-
>
> CREATE PROCEDURE spGetActivePromotions
>@Today datetime
> AS
> SELECT PromotionID, PromotionName, StartDate, EndDate, LastDrawDate,
>MaxDraws, NumRegTickets, VouchersPermitted, NumTicketsPerVoucher,
> ManualTicketIssue
16 matches
Mail list logo
