My select looks like this:
SELECT surname, first_name, msf810.email_address, msf810.employee_id FROM msf810, msf020, MSF829 WHERE msf810.employee_id = msf020.employee_id AND msf810.employee_id = msf829.employee_id AND msf020.dstrct_code = 'ATTU' AND physical_loc = '05' AND global_profile != 'JRADMIN'
My bind_columns looks like this:
$sth->bind_columns( \$last, \$first, \$email, \$userid );
I then do a loop over the contents but I am only getting the $last and $first to print and not the other columns that are bound.
I am using Perl 5.8.4 from ActiveState on Windows using Oracle 9i as the database.
Robert
Ah, never mind. I got it.
Robert
