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, nameOther than the fact that it complains about class being an unkown column? Or is this more sqlplus stuff that is catching me off guard? -- Brian Avis SEARHC Medical Clinic Juneau, AK 99801 (907) 463-4049 cd /pub more beer
