|
Hello, I have 2 tables in SQL....TrafficLog and PhotoEditors In the Table TrafficLog you have the following fields ID Date Login PhotoEditors Condition In the Table PhotoEditors you have the following fields ID FirstName LastName I have created an add new record form using the new record builder for Table TrafficLog . I would like to have the field PhotoEditors in the Table TrafficLog be a dropdown menu displaying the PhotoEditors items in the Table PhotoEditors and when saved the item goes in to the PhotoEditors field in the Table TrafficLog . I have done the Search action for PhotoEditors table with the 3 fields <TR ALIGN="LEFT" VALIGN="TOP"> <TD> <B>Send To: </B> </TD> <TD> <@CHOICELIST name=TSend TYPE=SELECT SIZE=1 OPTIONS=@@PEName[*,2] VALUES=@@PEName[*,2]> </TD> </TR> My question is how do I get Firstname and Last name displayed in the dropdown menu...right now it is only displaying first name? Thanks in advance for your help.... Cecilia C. Cos Data Analyst Newsweek | 251 W 57th Street | New York, NY | 10019 212-445-4309 [EMAIL PROTECTED] Cecilia, The choicelist
tag only allows you to use 2 columns, one for the values and one for the
options. There are a couple of ways you can resolve
this. 1) append the FirstName and LastName
columns into a single value in your search action. Use a “custom
column” in the search and enter a concatenation function for your
database. In MySQL it would be concat_ws(‘ ‘,FirstName,LastName). The syntax will be different for other
databases. This will give you a two column array of ID and FirstName+LastName
which you can use in a choicelist tag. 2) Use a select tag and a rows loop to build the dropdown instead of a
choicelist tag Dave Shelley -----Original Message-----
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf |
