Re: Database Access Problem (again)

2002-05-02 Thread garrett esperum
OOPS!! Thank you! That "a" was the problem. :) -garrett >From: Felix Geerinckx <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Database Access Problem (again) >Date: 2 May 2002 20:25:22 - > >on Thu, 02 May 2002 20:11:29 GMT, Garrett Esperum wrote:

Re: Database Access Problem (again)

2002-05-02 Thread Felix Geerinckx
on Thu, 02 May 2002 20:11:29 GMT, Garrett Esperum wrote: > This is the error message I recieve when I run my script: > > DBD::Oracle::db prepare failed: ORA-00904: invalid column name (DBD > ERROR: OCIStmtExecute/Describe) at 3mfiles.pl line 63. > DBD::Oracle::db prepare failed: ORA-00904: inval

Re: Database Access Problem (again)

2002-05-02 Thread garrett esperum
print "$oid\n"; } $sth->finish(); $dbh->disconnect(); I think I am screwing up the whole while loop. -garrett >From: "garrett esperum" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Sub

Database Access Problem (again)

2002-05-02 Thread garrett esperum
Hello all again, Solaris, Perl 5, Oracle 8.1.6 OK, so here I am... Now I am having issues accessing my database from my Perl SQL query. I want to query my DB and put it's response into a variable to be used later. I really think that I am structuring my perl query wrong. How do I get my SELEC