Hello
I have Oracle 9 + RedHat 7 + PHP 4.3.4 + Apache 1.3.29.
I've compiled apache and php I've compiled PHP using the
documentation and activating OCI.
I've build the typical script for starting apache, it's like this:
$ORACLE_HOME=blablahblah...
more oracle variables
c
Luis Moran Ochoa wrote:
I've build the typical script for starting apache, it's like this:
$ORACLE_HOME=blablahblah...
more oracle variables
Are the environment variables exported in the script?:
ORACLE_HOME=/my/oracle/home
export ORACLE_HOME
Are all variables needed set?
Are
Both Internet Explorer and Mozilla browsers when you have multiple windows
there is only one application instance running, this is done to save memory
and make the program run faster.
Probably (i'm not sure) Mozilla behaves diffent than Internet Explorer in
this situation. My advice is that you co
Yes they are...
I tried to put them into the httpd.conf file, like:
SetEnv ORACLE_HOME /usr/oracle
and so
The problem still remains.
Too, I've put all the environment variables in the root env into the
script I thought
it can be a problem with a missed variable But it doesn't work
Paul --
1) You've hijacked this thread. Don't do that. You don't even get the
benefit of explanation, however, because ...
2) What does this have to do with PHP (or, worse yet, PHP with databases)?
3) STFW
HAND
:-D
--
David T-G * There is too much animal courage in
(p
Perhaps something that isn't obvious is missing. If you post
more detail (e.g. the exact script and the exact permissions)
someone might be able to help you.
Chris
Luis Moran Ochoa wrote:
Yes they are...
I tried to put them into the httpd.conf file, like:
SetEnv ORACLE_HOME /usr/oracle
and so
hi!
thanks a lot for your answer. i also thought of dividing the problem into
several selects, but the application i'm working with (it's designed by a
friend of mine, which lets you easily generate XML out of an sql) only
accepts one single query..
do you know about any problems using CREATE TEM
hi!
yes - it seems as if there was no way out. i'll have to render it without
this php-class. i didn't thought that it's not possible to do such queries
in sql - well at least i don't know how to do them?? :/
thx for your answers!
-mathew
# life would be easier if i knew the source code...
>
// This is just 1 query, I have not tested it, but it may work.
$get_Quote = "select ph.id, ph.img, cm.id, cm.phid, cm.txt, rt.id,
rt.phid, rt.text from photos as ph left join comments as cm left join
ratings as rt on ph.id = cm.phid = rt.phid where id = '$photo_id' order
by ph.id";
//runs the qu
thx for the query!
unfortunately it does not what i was aiming for... a result like this:
id | img | comments | ratings
---+-+--+
1 | p.jpg | 0| 1
2 | a.jpg | 3| 4
3 | v.png | 2| 0
so the variable to set dynamicall should be compared t
Would this work better ?
SELECT comments.id, comments.phid,
COUNT(comments.id) AS comments,
COUNT(ratings.id) AS ratings
FROM photos LEFT OUTER JOIN comments
ON photos.id=comments.phid
LEFT OUTER JOIN ratings
ON photos.id=ratings.phid
WHERE photos.id=1
GROUP BY comments.id, comments.phid
(You can
Hello to all.
I am trying to write a simple (at least I thought it was simple...) "Contact Us" form
that
sends an email when it is submitted.
The $to_name variable was passed from a previous page. I am sure that the variable
was passed, as I can echo it and it is being passed correctly - thank
Anyone know how to pass a query string to a php script when you call it
on the command line?
<>< Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
php script.php %1 %2 %3 %4
And it is referenced as $argv[arg number]
... I think. To be sure, here is the link to that info:
http://www.php.net/manual/en/features.commandline.php
- Paul
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2
Bummer... So I can't send the named variables as a query string? Well,
this will work. Thanks!
-Original Message-
From: Paul Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 3:51 PM
To: 'PHP-DB'
Subject: RE: [PHP-DB] PHP Command Line
php script.php %1 %2 %3 %4
And it i
What's the exact error you get when you try to connect to oracle and
what command are you using to connect?
Does a phpinfo() script show the Oracle env vars correctly under the
"Environment" section?
Chris
Luis Moran Ochoa wrote:
These are the exact details...
/usr/oracle permissions 750 owner o
I've got an odd little problem that I just can't figure out. First, let
me briefly describe my setup:
* Behind a firewall is a Windows 2003 Server running SQL Server 2000
with mixed mode authentication
* On that same internal network is a Linux web server with Apache 2,
PHP 4.3.4, FreeTDS, etc.
I came across this problem when I separated my web applications and database
(sql 2000) onto separate servers. The problem is that Windows does not
(cannot) pass user authentication information to SQL server ... if they are
different machines. I used Mixed authentication and added user
accounts/g
On Thu, 2004-01-29 at 21:57, Duane Lakoduk wrote:
> I came across this problem when I separated my web applications and database
> (sql 2000) onto separate servers. The problem is that Windows does not
> (cannot) pass user authentication information to SQL server ... if they are
> different machin
These are the exact details...
/usr/oracle permissions 750 owner oracle.oinstall
apache belongs to oinstall.
script permissions in /etc/init.d/apache --> 755
ORACLE_SID=OWEB ;export ORACLE_SID;
ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME;
TNS_ADMIN=/usr/
20 matches
Mail list logo