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 -0000
>
>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: invalid column name (DBD
> > ERROR: OCIStmtExecute/Describe) at 3mfiles.pl line 63.
> > Issuing rollback() for database handle being DESTROY'd without
> > explicit disconnect().
> >
>
>[ SQL statement reformatted]
>
> > my $sql = qq{
> > SELECT
> > c.oid AS folder_oid
> > FROM dp_doc_folder_content c, bv_ep_proj_attach
> > WHERE
> > c.DOC_DELETED=0
> > AND c.DOC_OID=a.ASSOC_CONTENT
> > AND a.file_path = '$rootDir/$projectId/$docName'
> > };
>
>You don't have an 'a' table (or alias) in your 'from' clause, but you have
>two 'a.fields' in your 'where' clause -> two 'invalid column errors'.
>
> > I think I am screwing up the whole while loop.
>
>The while loop looks OK to me.
>
>
>--
>felix
>
>--
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
