Sorry... michi..
I've ignored your advice to quote the script as :
> 3.
> you have to quote "v$session": "v\$session"
-----
yeah.. the script is work when I change the script right below :
$query = "Select OSUSER
>From v\$session
Where USERNAME = (Select USER From DUAL)
And AUDSID =(Select USERENV('SESSIONID') From DUAL)";
great thanks in advance to michi...
^_^
----- Original Message -----
From: "èdy kurniawan" <[EMAIL PROTECTED]>
Subject: Re: [PHP] SQL Statement
> thanks to michi for ASAP response...
> but I thought your opinion not actually right..
>
> I've a sql :
>
> $query = "Select dfl_desc From
> fmmis_0000_datafls@dbhonda Where dfl_flag =
> (Select dpb_flag From fmadm_gs00_dtlppbs@dbhonda
> Where DPB_PARTNONSTOCK = '".$TT[$n]."')
> And DFL_KDDOK ='PPM'";
>
> its a kind of subselect (or oracle-ist usual call it nested query) and it
> works properly.
>
> as your sugesstion, I've ever put a simple script :
> $query = "Select OSUSER
> From v$session";
>
> and the error is still occured.
>
> Ora_Parse failed (ORA-00942: table or view does not exist ........
>
>
> O.k. but at all... i'm very appreciate for your response michi ..
>
> any other ideas ?
>
> sincerely,
> edyk
----- Original Message -----
From: <[EMAIL PROTECTED]>
Sent: Wednesday, June 19, 2002 1:26 PM
Subject: Re: [PHP] SQL Statement
> this is the problem:
>
> $query = "Select OSUSER
> >From v$session
> Where USERNAME = (Select USER From DUAL)
> And AUDSID =(Select USERENV('SESSIONID') From DUAL)";
>
> 1.
> mysql does NOT support subselects!
> 2.
> delete the "<" in front of "FROM"
> 3.
> you have to quote "v$session": "v\$session"
>
> start with a short query like:
> $query = "select OSUSER from v\$session where USERNAME like 'foo'";
>
> then you have to recode the subselects with php-loops!!!
> michi
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
