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

[Barbara McCormick]

Title: Message

Thank you it worked.   -----Original Message----- From: Storey, Paul [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 10:16 AM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: @rows array/SELECT statement returning partial string   I think if you add quotes around the value, it will work.   <OPTION VALUE="<@VAR NAME=request$ServRep[<@CURROW>,1]>"> -----Original Message----- From: Barbara McCormick [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 12:12 PM To: [EMAIL PROTECTED] 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