Re: Witango-Talk: @rows array/SELECT statement returning partial string

[Alan Wolfe]

Hi barbara, Try including the values in double quotes:                        <SELECT NAME="servrep">                           <@rows Array="request$ServRep">                               <OPTION VALUE="<@VAR NAME=request$ServRep[<@CURROW>,1]>">                                  <@VAR NAME=request$ServRep[<@CURROW>,1]>                           </@rows>                      </SELECT>   ----- Original Message ----- From: Barbara McCormick To: [EMAIL PROTECTED] Sent: Friday, March 05, 2004 10:11 AM Subject: Witango-Talk: @rows array/SELECT statement returning partial string Hello, I think I have seen a reference to this issue before in the archive, but of course I couldn�t find it when I needed it. I�m using a SELECT statement in combination with @ROWS ARRAY and OPTION to display the results of a Direct DBMS action in a drop down so the user can select a value to send to a report. The value displays correctly in the form, but as it gets passed I only get the characters up to the first space in the text string loaded into my variable. Like �Doug Smith� only shows �Doug� in my variable. Here�s my SELECT statement:                        <SELECT NAME="servrep">                           <@rows Array="request$ServRep">                               <OPTION VALUE=<@VAR NAME=request$ServRep[<@CURROW>,1]>>                                  <@VAR NAME=request$ServRep[<@CURROW>,1]>                           </@rows>                      </SELECT> Any ideas? Thanks,   Barbara McCormick Capital Pacific Homes, Inc. [EMAIL PROTECTED] 480-777-2400 ext 211   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf