You need to give column names when a accessing the result:
$fdat{'!Fields'} = "employee_key, first_name || ' ' || last_name as
name";
...
<option value='[+$employeeDat[$row]{employee_key} +]'>[+
$employeeDat[$row]{name} +]</option>
or even better leave out the $row in the second expression, because
otherwise the loop will end when you have an name that return NULL (i.e.
undef)
<option value='[+$employeeDat[$row]{employee_key} +]'>[+ $employeeDat{name}
+]</option>
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]