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

[Barbara McCormick]

Thank you very much   -----Original Message----- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 10:21 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: @rows array/SELECT statement returning partial string   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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf