Ah hah!
Thanks
the problem was staring me in the face. I recently removed one of the columns from my select statement that the form was still trying to bind to.
SELECT digest as digest_short, prop_id, prop_no, prop_year, com_id,status_id, introduced_date, initiated_by, proposal.ordtype_id, ordtype_desc, ordinance_no, drafted_by, proposal.com_id, com_name FROM OTS.PROPOSAL LEFT JOIN ordinance ON proposal.ordtype_id = ordinance.ordtype_id LEFT JOIN committee ON proposal.com_id = committee.com_id WHERE 1=1 AND prop_year=2004 ORDER BY LPAD(PROP_NO,4,'0')
--------------------------
Clay Angelly
cangelly@ie-inc.comNever argue with an idiot. They drag you down to their level and beat you with experience.