Re: [GENERAL] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

[Dan Wilson]

> Jason wrote:
> >
> > aolserver is a web/application server.  PHP is a server-side scripting
> > language.  Why exactly *should* it have a job scheduler?
> >
> > Some (such as myself) might also ask why should a web server have a job
> > scheduler, but that's a thread for a different list :)
>
> Because PHP is supposed to solve web development problems. And this is
> one of them. It's very useful.

I disagree!  Cronjobs are not a web development problem.  That is something
that should be handled on the server/machine side.  PHP is purely designed
to dynamically create web pages.  It has other things built into it, but
each one interfaces with the web page somehow.  A cronjob doesn't use the
web at all.  The web is an interactive thing and the whole purpose of a job
scheduler is to avoid interaction.

Sure a job scheduler is useful, but it is outside the scope and mission of
PHP.

-Dan

Re: [SQL] [PHP] PEAR Problem

[Dan Wilson]

This is caused by the fact that PostgreSQL is case insensitive.  In order
for it to actually take the case into account, you need quote your field
names and table names.

So your query would then be: select "NetCode","NetworkName" from
"NetworkTab";

Then you would be able to access the fields with $dbRow[NetworkName].

-Dan

: Hi,
:
: It's me again. I have been able to solve most of the porting problems
: from mysql to pgsql. But I have got struck in one place. I have a
: problem where PEAR's associative array doesn't recognise the mix case
: letters.
:
: eg . I issue a query through PEAR db and get results using fetchRow of
: PEAR. Now I have set associative array feature ON.
:
: suppose the query is
:
: select NetCode,NetworkName from NetworkTab;
:
: this would return the result into a variable called $dbRow
:
: to echo the contents returned by the pgsql, I have to give
: $dbRow[NetCode] and $dbRow[NetworkName]
:
: This used to work perfectly fine with mysql, but as I moved to pgsql,
: PEAR started to return nothing
:
: like if i echo $dbRow[NetCode] it prints nothing
:
: but in the same echo is I change it echo $dbRow[netcode], it prints
: the value of the Network Code.
:
: How do I handle this situation. The application is fully written with Mix
Case
: letters for the database fields and returned result set.
:
: And one more thing "SET AUTOCOMMIT=0" which is to set auto commiting
: to "No" in mysql doesn't work in pgsql what is the equivalent command.
:
: --
: Best regards,
:  Gurudutt  mailto:[EMAIL PROTECTED]
:
: Life is not fair - get used to it.
: Bill Gates
:
:
: ---(end of broadcast)---
: TIP 5: Have you checked our extensive FAQ?
:
: http://www.postgresql.org/users-lounge/docs/faq.html
:


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org