Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     USE of & onDrop Down List Box

Read-Only Read-Only Topic
Go
Search
Notify
Tools
USE of & onDrop Down List Box
 Login/Join
 
Jay
Gold member
posted
I have an html page which has a drop down list box. The way I populate this drop down list box is by reading a file. The file has one record which contains B&T - when it gets displayed it only has B.

Is there a way to display the value as B&T as its on the databse.


WebFocus 7.6.6
Oracle 10
Windows XP
 
Posts: 60 | Registered: March 13, 2007Report This Post
jimster06
Guru
posted Hide Post
You may have to edit it - B&|T - yes that is the pipe or weak concatenation symbol.

Give it a shot.

HTH


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
susannah
Expert
posted Hide Post
Jay
you might want to bulletproof your source data
by using the CTRAN function to change all & in your character strings to , say, +
The values for & and + are 38 and 43 respectively.
I have had luck also with the STRREP and SQUEEZE functions to ensure that all '&' in an inbound character string are followed by a blank
'& ' and then squeezing out the double blanks.
But the first solution might be the simplest for you. Look up CTRAN in your USING FUNCTIONS manual.
-s.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Jay
Gold member
posted Hide Post
The problem is that on the HTML painter you can select to read the file and populate the drop down from this read - there is no way I can modify this code, it looks like its a FOCUS bug because the FOCUS should be ignoring the '&'

Any thoughts on this?


WebFocus 7.6.6
Oracle 10
Windows XP
 
Posts: 60 | Registered: March 13, 2007Report This Post
susannah
Expert
posted Hide Post
Jay,
you don't have to use the 'master' ...
you can, in devstu, click on 'procedure' and write a fex that will populate the dropdown.
When you write your fex, its
PRINT displayvalue BY parmvalue AS parmname...
ON TABLE PCHOLD FORMAT XML



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Jay
Gold member
posted Hide Post
I put this in as a bug - Case # : 43442515

The weird thing is when I wrote the focexec it displays every other one and I don't know why that is happening.

When you display the results you can see everything but on the drop down list it displays every other one.

The fun you can have with Focus. Sweating


WebFocus 7.6.6
Oracle 10
Windows XP
 
Posts: 60 | Registered: March 13, 2007Report This Post
<JG>
posted
The issue is that when you display the report no special handling is required to display an &.

However when you populate the dropdown from a file it comes back in XML format and the & is a
reserved character. If you use the ON TABLE PCHOLD FORMAT XML method to
manually create the dropdown list the you must use the STRREP function to replace all & with
&|amp; (you need the | in the function call so that WebFOCUS does not think it is a variable);

This message has been edited. Last edited by: <JG>,
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     USE of & onDrop Down List Box

Copyright © 1996-2020 Information Builders