> 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
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
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
>
> >>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,
> >
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 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.
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
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
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
> > 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
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
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
> >
> >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
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
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
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
16 matches
Mail list logo
