Re: [PHP-WIN] MSIE problems

2005-09-15 Thread Bob Stout
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 frame is "somefi

[PHP-WIN] MSIE problems

2005-09-15 Thread Bob Stout
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 frame is "somefile.php#here", it di

[PHP-WIN] Calling MSSQL Stored Procedure

2005-09-15 Thread Alf Stockton
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 FROM Promoti

Re: [PHP-WIN] Calling MSSQL Stored Procedure

2005-09-15 Thread Robert Twitty
On Thu, 15 Sep 2005, Alf Stockton wrote: > Thanks for the suggestions on ADODB which, thanks to you, I have > implemented. > > I like the simularity between databases as my applications are going to > be accessing both MSSQL & Oracle. > > The next step is for me to use ADODB & PHP to call vari

[PHP-WIN] Calling MSSQL Stored Procedure

2005-09-15 Thread Alf Stockton
Thanks for the suggestions on ADODB which, thanks to you, I have implemented. I like the simularity between databases as my applications are going to be accessing both MSSQL & Oracle. The next step is for me to use ADODB & PHP to call various MSSQL and Oracle Stored Procedurers so I am curre

Re: [PHP-WIN] I Can't connect to MySql using ADODB

2005-09-15 Thread Mark Rees
> Tony Aldemir wrote: > > >Hi There, > > > >I am trying to connect to MySQL using ADODB library for PHP using the > >following code with no success. What am I doing wrong? > > > > >include('/php/adodb.inc.php'); > > > >$db = &ADONewConnection('mysql'); # eg. 'mysql' or 'oci8' > >$db->debug = true;

Re: [PHP-WIN] I Can't connect to MySql using ADODB

2005-09-15 Thread Alf Stockton
Tony Aldemir wrote: Hi There, I am trying to connect to MySQL using ADODB library for PHP using the following code with no success. What am I doing wrong? $db = &ADONewConnection('mysql'); # eg. 'mysql' or 'oci8' $db->debug = true; $db->Connect('localhost', 'tony', 'mypassword', 'test'); $r