[PHP-DB] Re: [PHP] MS-SQL 2000 weird problem

2003-09-15 Thread Dan Anderson
> Any thoughts? Are you dying and outputting an error where something could happen to bodge up the server? I'm not familiar with MS SQL Server, but I know under mysql: -Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MS-SQL 2000 weird problem

2003-09-15 Thread Curt Zirzow
On Mon, 15 Sep 2003 15:21:41 -0300, Martin Greco <[EMAIL PROTECTED]> wrote: Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it re

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
- Original Message - From: "Pat Lashley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, September 15, 2003 5:12 PM Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? > --On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa > <[EMAIL PROT

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Matt Babineau
Goto your shell and type "php -i" w/o the quotes. You should see the phpinfo() output. You can pass the path to your script as a command line variable, and it will process it. Here, read about it, I think this is the right answer for you: http://us3.php.net/features.commandline Matt On Mon, 2003-

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Pat Lashley
--On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa <[EMAIL PROTECTED]> wrote: Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outs

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Ryan Marks
My bad... wget does require http or ftp protocol and a hostname that can be resolved by the server. -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:47 PM To: Ryan Marks; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Need

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
I believe this would need php to installed as a cgi, which I prefer not to do... On Mon, 2003-09-15 at 15:31, Ryan Marks wrote: > Not necessarily. You can wget /path/to/file.php or my personal preference > is not to use wget, but php directly > /path/to/php/executable /path/to/file.php > > Just

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: "Ryan Marks" <[EMAIL PROTECTED]> > Not necessarily. You can wget /path/to/file.php or my personal preference > is not to use wget, but php directly > /path/to/php/executable /path/to/file.php Are you sure about that? I thought wget had to go through HTTP? This didn't work for me, am I do

[PHP-DB] MS-SQL 2000 weird problem

2003-09-15 Thread Martin Greco
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works fine

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Ryan Marks
Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Just a thought, Ryan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:28 PM To: [EM

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: "Jonathan Villa" <[EMAIL PROTECTED]> > > wget -q -O - www.domain.com/cron.php > /dev/null > > Interesting... how does this fair concerning security? So I'll have to > have this file located in my document root, is this a good thing? My > current directory structure consists of several fil

[PHP-DB] Weird MSSQL problem

2003-09-15 Thread Martin Greco
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 set to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works

[PHP-DB] Weird MSSQL problem

2003-09-15 Thread Martin Greco
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 set to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page On Mon, 2003-09-15 at 1

AW: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Lars Jedinski
I used to have the same problem and solved it as follows: I wrote my php script and created my crontab runing the script with the lynx-browser. The output is sent to me via eMail in crontab e.g.: MAILTO:[EMAIL PROTECTED] 15 15 * * * lynx -dump http://www.myDomain.com/myScript.php That works fine

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: "Jonathan Villa" <[EMAIL PROTECTED]> > I have an application which creates temporary tables. My plan is to > remove them after a 24 hour period and only those which are have a > created time greater than 24 hours. That part I can do, my question is > how will I be able to run this script

[PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull t

Re: [PHP-DB] $PHP_SELF does not work with all browsers

2003-09-15 Thread Alain Barthélemy
Le lundi 15 septembre 2003, 14:16:15 ou environ mike karthauser <[EMAIL PROTECTED]> a écrit: > on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote: > > > http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF > > Try using $_SERVER['PHP_SELF'] > -- > Mike Karthauser

Re: [PHP-DB] Re: Connect to Oracle DB

2003-09-15 Thread roy.a.jones
I just wanted to add my two cents ... I have compiled php with BOTH --with-oracle and --with-oci8. It is usually preferred to have your architectures/systems separate to prevent some performance issues. As a test/demo system then having them on the same box is perfectly acceptable and remove

Re: [PHP-DB] $PHP_SELF does not work with all browsers

2003-09-15 Thread mike karthauser
on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote: > http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF Try using $_SERVER['PHP_SELF'] -- Mike Karthauser Managing Director - Brightstorm Ltd Email >> [EMAIL PROTECTED] Web >> http://www.brightstorm

[PHP-DB] $PHP_SELF does not work with all browsers

2003-09-15 Thread Alain Barthélemy
I wrote a page browser that allows me to list different persons in a table according to the first alphabet-letter of their name Thus if I choose letter nr 65 (A): $chrLettre = chr(65); $chosenLettre = $chrLettre; echo "".$chosenLettre."\n"; 1) Station Linux-RedHat-7.2 apache 1.3 php-4.0 mozilla