php-windows Digest 11 Oct 2003 03:23:39 -0000 Issue 1950
Topics (messages 21746 through 21751):
timeout?
21746 by: Disko_kex
21750 by: Rahman Haqparast
preg_match function
21747 by: Omar
handling SQL dot notation in PHP
21748 by: Herhuth, Ron
21749 by: Herhuth, Ron
21751 by: Frank M. Kromann
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Hi, Im running IIS and PHP 4.3.3. I have set max_execution_time = 0 in
php.ini and set_time_limit(0); in my php files. But still after about 5
minutes I get CGI-timeout.. error.
The scripts sends newsemail to about 3-400 customers, that's why I need
it to be inifity.
What should I do?
--- End Message ---
--- Begin Message ---
Hi.
1.. Start the IIS management console (Start => Settings => Control Panel
=> Administrative Tools => Internet Services Manager).
2.. In the tree on the left-hand side of the console you should see
"Internet Information Services" at the very top, then below this the name of
your computer. Right-click your computer name and select "Properties".
3.. Under "Master Properties" is a listbox; ensure that "WWW Service" is
showing, then click the "Edit" button.
4.. Click on the "Home Directory" tab.
5.. Click on the "Configuration" button in the Application Settings area.
6.. Click on the "Process Options" tab.
7.. In the CGI Configurations area there is a "CGI script timeout" value
specified in seconds. The default value is 300 seconds (5 minutes).
8.. Change this value to whatever you would like your timeout to be.
9.. Work your way out by clicking the "Ok" button on each window until you
get right back to the IIS management console.
10.. Close the management console.
11.. Restart IIS by opening a command prompt (Start => Programs =>
Accessories => Command Prompt) and type the command:
iisreset
FROM http://www.murraymoffatt.com/software-problem-0002.html
"Disko_kex" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi, Im running IIS and PHP 4.3.3. I have set max_execution_time = 0 in
> php.ini and set_time_limit(0); in my php files. But still after about 5
> minutes I get CGI-timeout.. error.
>
> The scripts sends newsemail to about 3-400 customers, that's why I need
> it to be inifity.
>
> What should I do?
>
>
>
--- End Message ---
--- Begin Message ---
Hello everyone.
In this line
preg_match("/[^a-z0-9'\?!-]", $item)
i can´t find de way to add vowels with accent (á,é,í,ó,ú,ñ,Ñ) and other
characters to the preg_match function.
Can anyone help me?
The documentation of this function is not very clear (or complete) to me.
Thank you.
--- End Message ---
--- Begin Message ---
When using SQL in PHP I have run up against a small issue when working
with larger SQL queries...specifically when using alias table names. PHP
doesn't like the "." used to seperate the table/field name.
Here is an example:
$query = "SELECT Role.display_Name from Northwind";
This generates an error because of the "." symbol in the query. This is a
very rudimentary query used simply for ease of understanding of the
problem...but on a larger query where it is necessary to denote
field/table relationships using the period becomes crucial.
How can I get around PHP's issue with the "."?
Thanks,
ROn
--- End Message ---
--- Begin Message ---
OOPS!...The error comes when trying to display the result in the
situtation illustrated here:
echo "<td>$row[frole.display_name]</td>";
>From: Herhuth, Ron
>To: [EMAIL PROTECTED]
>Sent: 10/10/2003 1:13 PM
>
>When using SQL in PHP I have run up against a small issue when working
>with larger SQL queries...specifically when using alias table names. PHP
>doesn't like the "." used to seperate the table/field name.
>
>Here is an example:
>
>$query = "SELECT Role.display_Name from Northwind";
>
>This generates an error because of the "." symbol in the query. This is
a
>very rudimentary query used simply for ease of understanding of the
>problem...but on a larger query where it is necessary to denote
>field/table relationships using the period becomes crucial.
>
>How can I get around PHP's issue with the "."?
>
>Thanks,
>ROn
>
>
>
>
>
--- End Message ---
--- Begin Message ---
Hi Ron,
No database servers I know will return the column name as
<table>.<column>. Only the column name is returned. This has nothing to do
with PHP, but is how the SQL92 standard defines it.
If you want to have nice names you can do something like this:
$query = "SELECT Role.display_Name as my_column_name from Northwind";
..
echo "<td>$row[my_column_name]</td>";
- Frank
> OOPS!...The error comes when trying to display the result in the
> situtation illustrated here:
>
> echo "<td>$row[frole.display_name]</td>";
>
>
>
> >From: Herhuth, Ron
> >To: [EMAIL PROTECTED]
> >Sent: 10/10/2003 1:13 PM
> >
> >When using SQL in PHP I have run up against a small issue when working
> >with larger SQL queries...specifically when using alias table names.
PHP
> >doesn't like the "." used to seperate the table/field name.
> >
> >Here is an example:
> >
> >$query = "SELECT Role.display_Name from Northwind";
> >
> >This generates an error because of the "." symbol in the query. This
is
> a
> >very rudimentary query used simply for ease of understanding of the
> >problem...but on a larger query where it is necessary to denote
> >field/table relationships using the period becomes crucial.
> >
> >How can I get around PHP's issue with the "."?
> >
> >Thanks,
> >ROn
> >
> >
> >
> >
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
