I'm not sure that this is the problem, but could the following be causing a cyclical redundancy error:
NVL(financial_no, '00000') financial_no Some DB platforms don't let you assign an alias name that is the same as the column to which it is being assigned. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Chris Norloff [mailto:cnorloff@;norloff.com] > Sent: Friday, October 18, 2002 9:39 AM > To: CF-Talk > Subject: Oracle Error "no descriptor for this position > > > We're getting the Oracle error ORA-24334: no descriptor for this > position with the following query. Not having much luck finding > out what's going on, or getting info from the MM CF forum, > CF-Talk archives, or Google. Any ideas? (CF 4.5.1 SP2 on > Solaris 8, Oracle 8i db, with 8.1.7 client) > > thanks, > Chris Norloff > > SELECT > job_id, > provider_code, > NVL(financial_no, '00000') financial_no, mailing_facility, > job_title, > process_category, > class, > local_permit_no, > permit_type, > total_piece, > total_weight, > cqt_total_pieces, > cqt_weight, > location_zip, > owner_name, > gca_version > FROM > m_job_summary > WHERE > job_id = 'QD2AES_1' > AND provider_code = 'QUAD' > AND mailing_facility = > '22203-1553' > > > Oracle's description of the error: > ORA-24334 no descriptor for this position > Cause: The application is trying to get a descriptor from a > handle for an illegal position. > Action: Check the position number. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm