Am I correct in thinking that you want the filtered result (a single employee?) to appear first, then a list of employees after that in a drop-down menu? If so, it seems that while it is filtered down to one, it is still an array. You would need to reference elements in the array to show the name of that employee, i.e. <@VAR Employee1[1,3]> or something like that. Does this make sense?
Jason
On Tuesday, November 5, 2002, at 07:05 AM, Rick Haden wrote:
I know I am being stupid, but the following doesn't work and I know it--
has something to do with the variable, but I don't know how to fix it:
<@ASSIGN NAME="Employee1" VALUE='<@FILTER ARRAY="EmployeeList"
SCOPE="local" EXPR="#1=<@COLUMN 'customers.appointed_employee_1'>">'>
<SELECT NAME="customers_appointed_employee_1" SIZE=1>
<OPTION VALUE="<@COLUMN 'customers.appointed_employee_1'>">
<@VAR Employee1>
<@ROWS ARRAY="EmployeeList">
<OPTION VALUE="<@VAR NAME='EmployeeList[<@currow>,1]'>"><@VAR
NAME="EmployeeList[<@currow>,2]">
<@VAR NAME="EmployeeList[<@currow>,3]"> </@ROWS>
</SELECT>
OK...It is the first reference to <@VAR Employee1> that causes a
problem...substitute text and the drop down works fine...put the
variable in and I get the result outside the dropdown and the rest of
the array as a great wodge of text...
Any ideas?
____________________________
Rick Haden
Director - IS/IT
Trident Communications
3 Selsdon Way
City Harbour
London
E14 9GL
UK
Tel: +44 20 7536 8924
Fax +44 20 7536 8999
www.tridentcommunications.net
_______________________
_______________________________________________________________________ _
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
____________________________________________________________________
Jason Pamental, President [EMAIL PROTECTED]
Bathysphere Digital Media Services, Inc. http://bathyspheredms.com
____________________________________________________________________
Tel: 401.490.6830 Fax: 401.490.6831
________________________________________
A North American Distributor for Witango (http://www.witango.com)
Rapid Web Application Development - XML Execution Engine
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
