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]
