Help on using DBIx

[Boyd, David]

I am trying to do a simple select statement and display the results into a
pull down list, but it does not seem to work.

here is the code that I am using:


[-

                #-------------------
                # database parameter
                #-------------------
                $fdat{'!DataSource'} = GetDSN();
                $fdat{'!Table'}      = 'unanet_employee';
                $fdat{'!Fields'}     = "employee_key, first_name || ' ' ||
last_name";
                $fdat{'=search'}     = 'ok';

                #-------------------
                # execute action according to the query parameters
                #-------------------
                *employeeDat = DBIx::Recordset -> Execute (\%fdat);

-}


                <table border='0'>
                        <tr>
                                <td>Employee:</td>
                                <td>
                                        <select
name="assignment.employee_key" class="assignment.employee_key"
id="assignment.employee_key" onChange='document.Form1.emailAddress.value =
this.value;'>
                                                <option value='[+
$employeeDat[$row] +]'>[+ $employeeDat[$row] +]</option>
                                        </select>
                                </td>
                        </tr>
                </table>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]