SELECTED
--
6 Solid Edge
0
7 MicroStation
1
10 MDSync
1
Thx for your help.
Barry
"Barry Prentiss" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> Here's another SQL qu
Sorry, forgot to mention that I'm on an Oracle 8.1.6 db...
Thx,
Barry
"Barry Prentiss" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> Here's another SQL query problem:
>
> How do I construct a query th
b if a.id = b.id
or select 0 as selected from another-table b if a.id != b.id ) c;
Thx in Advance,
Barry Prentiss
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrato
-1);
ociExecute($stmt);
$sql = "insert into mdfaq_faq_cat values ($faq_ID, $req_cat)";
$stmt = ociParse($conn,$sql);
ociExecute($stmt);
Any Ideas?
Thx in Advance,
Barry Prentiss
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECT
t;Alnisa Allgood" <[EMAIL PROTECTED]> wrote in message
news:p05100300b79a3aa685c8@[63.202.15.82]...
> At 4:07 PM -0700 8/10/01, Barry Prentiss wrote:
> >Hi,
> > I am writing a FAQ machine in PHP using Oracle 8.1.6.
> > I can't figure out what's not workin
@[63.202.15.82]...
> At 4:07 PM -0700 8/10/01, Barry Prentiss wrote:
> >Hi,
> > I am writing a FAQ machine in PHP using Oracle 8.1.6.
> > I can't figure out what's not working in my SQL query.
> > I've spent two days on the Oracle site, to no avail.
> >
Solved!
Thx Stathis, but it wasn't OciLogon("user","pass",'SLAC'), but
OciLogon("user","pass",'SLAC_TCP').
i.e. not the SID but the TWO_TASK variable it was after...
Thx Again,
Barry
"Rouvas Stathis" <[EMAIL
message.
> -Original Message-
> From: Barry Prentiss <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Friday, July 20, 2001 2:02 PM
> Subject: Re: [PHP-DB] 'ORA-12203: TNS:unable to connect to destination'
> error
>
>
>
wrote in message
news:[EMAIL PROTECTED]...
> Barry Prentiss wrote:
> >
> > Hi All,
> > I finally got past the php_oci8.dll problem by moving it to the same
> > directory as php.exe and changing the php.ini extensions_dir back to
'./'.
> >
> > Now I am