You can't use 'class' in your where clause. Brian Avis wrote:
> So is there any reason why I can't run this through DBI? > > SELECT ecls_code || '-' || ecls_long_desc AS class, > id_number, > last_name || ', ' || first_name AS name > FROM ap_employee_profile > WHERE empl_status = 'A' > AND class = $quotedCLASS > ORDER BY class, id_number, name > > Other than the fact that it complains about class being an unkown > column? Or is this more sqlplus stuff that is catching me off guard? > >
