Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #1 

Options in Drop-down Not on Separate Lines

Last edited: 13 Oct 2005


The information in this article applies to product: e-Work 6.x

Issue

  • When using the SelectSQL function, the list options in a drop-down are displayed on one line instead of separate lines.

Resolution

  • The drop-down uses a comma as the row delimiter. If SelectSQL is used, a comma must be specified as the row delimiter. The alternative is to use the GetData function which has a comma as the default row delimiter. Either of the following would return a list of user names from the eUser table with each name on a separate line in the drop-down:

    %GetData(,eUser,"","eUserName")

    %SelectSQL("SELECT eUser.eUserName FROM eUser WHERE (eUser.eUserName IS NOT NULL)","","",",")                                        
  • See the Designer User Manual for additional information on these functions.

Keywords: kb656


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!