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?


-- 
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
cd /pub
more beer


Reply via email to