Steve Thanks for all that...what I was trying to achieve was to get an employee ref number from a record in one table, match that to an employee name in another table and provide a list of employees to choose from so that the relationship could be changed should the member of staff change...the solution was to access the various elements of the array [1,2] etc...which is what I thought I was doing...must have had a typo in there somewhere, because starting again and rekeying the whole thing solved the problem.
Thanks again and kindest regards ____________________________ 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 _______________________ -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Steve Smith Sent: Tuesday, November 05, 2002 4:02 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Array stuff I'm confused about a couple of things. Why are you doing a filter on the EmployeeList array variable to create Employee1 and then you use both Employee1 and EmployeeList to create your drop-down? Also if EmployeeList is indeed an array, when you create Employee1 you are creating another array. This would explain why you are seeing a table outside of the dropdown. Also I don't quite understand what you are referring to when you say you are using a formatted table. Do you mean that instead of having the array variable created by a search result that you are using a hard-coded HTML table? If this is the case, check to make sure that the assignment to the variable is producing an array. You can check this by turning debug on and looking at the list of local variables. You should see variablename=[Array:'number of rows' x 'number of columns']. For example I've got an array variable that is called la_workcodes which is 19 rows by 3 columns and it shows up in the debug as 'la_workcodes=[Array:19x3]'. If you see anything else, chances are that the initial assignment to the EmployeeList variable did not produce an array. Perhaps if you stepped back and tried to explain what you are hoping to accomplish, we could provide some suggestions. Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:owner-witango-talk@;witango.com]On Behalf Of Rick Haden > Sent: November 5, 2002 10:11 AM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: Array stuff > > > > > ____________________________ > 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 > _______________________ > > Could it have anything to do with the fact that using this method I am > trying to get a formatted table into an input field? All I can think > of.. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:owner-witango-talk@;witango.com]On Behalf Of Rick Haden > > Sent: November 5, 2002 7:05 AM > > To: Multiple recipients of list witango-talk > > Subject: Witango-Talk: Array stuff > > > > > > 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 > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body