Re: [PHP-WIN] Re: Run batch files using php

2004-04-29 Thread Harpreet K. Singh
I run the batch file double clicking on it and it copies the files from one server to the other. I run the copy command in dos prompt it runs perfect I try running the same copy command or running the same batch file using exec in my php page and i get access is denied. What do i need to do to c

Re: [PHP-WIN] Convert string to date

2004-03-25 Thread Harpreet K. Singh
gt; 112 gives the date format as "mmdd", and that should > solve your problem. > > -Original Message- > From: Harpreet K. Singh > To: 'Php-Windows ' > Sent: 23-3-2004 19:06 > Subject: [PHP-WIN] Convert string to date > > I have a report that ha

[PHP-WIN] Convert string to date

2004-03-23 Thread Harpreet K. Singh
I have a report that has an expiration field I want to sort by expiration but when clicked it sorts alphanumerically and shows january 01 before march 03 no matter what the year. If i do select expiration and sort it works fine but if i say select [expiration]=convert(char(10), expiration, 101) i

Re: [PHP-WIN] Sending arguments to a SP in PHP

2004-03-04 Thread Harpreet K. Singh
Because it is a string The first variable is a sql statement which is a string the call to the SP is as follows exec limitselect 'select var1, var2, var3 from table1 order by var1',10,100 - Original Message - From: "Gerardo Rojas" <[EMAIL PROTECTED]> To: &

[PHP-WIN] Sending arguments to a SP in PHP

2004-03-04 Thread Harpreet K. Singh
I am using PHP and sql server 2000. I have a stored procedure which takes 3 arguments. The first argument is a string and the rest 2 are integers. For some reasons the call to the stored procedure is being trimmed. My call is as follows $oldquery="select var1,var2,var3,var4. from table order

[PHP-WIN] Running an exe from local drive

2004-02-24 Thread Harpreet K. Singh
I am trying to run an exe file from my php page. But i get an error Access is denied I am trying to open the file using javascript document.location=fp Thismight be a javascript question but if any one can help that would be great Regards, -- PHP Windows Mailing List (http://www.php.net/) To