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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     HTML Form data to Webfocus

Read-Only Read-Only Topic
Go
Search
Notify
Tools
HTML Form data to Webfocus
 Login/Join
 
Member
posted
I have been asked to select multiple entries from a HTML Dropdown.

How does Webfocus handle this any pointers or examples The Manual makes no sense to me.
 
Posts: 8 | Location: White Plains | Registered: June 20, 2005Report This Post
Expert
posted Hide Post
What release of WebFOCUS are you running?

Are you using the HTML Layout Painter, or Resource Layout Painter depending on your release?

The multi-select information comes back to the focexec as 'value1' OR 'value2' OR 'value3'. You can put a -TYPE &var in your program at the beginning followed by a -EXIT to see exactly what you are getting back.

I applaud the fact that you at least tried to find info in the documentation.

Also look up FOC_NONE. You will need to know about that as well if you are going to use multi-select boxes.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
Yes Please update your signature via the Profile set up with what version you are on.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Member
posted Hide Post
Webfocus is not my reporting tool of choice but thats what the company has and I only work here

I tried to determine what version we are using but the Help 'about' panel has all the labels but no data so I have no clue except its webfocus

Our Environment is AS400
 
Posts: 8 | Location: White Plains | Registered: June 20, 2005Report This Post
Expert
posted Hide Post
Run this link with the appropriate substitution:

http://your_web_server/ibi_apps/about.jsp


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
quote:
Webfocus is not my reporting tool of choice but thats what the company has and I only work here

I tried to determine what version we are using but the Help 'about' panel has all the labels but no data so I have no clue except its webfocus


Doesn't sound like you're enjoying yourself.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
quote:
Webfocus is not my reporting tool of choice but thats what the company has and I only work here

I tried to determine what version we are using but the Help 'about' panel has all the labels but no data so I have no clue except its webfocus



That's bad news.....

We like it (Web Focus) it has some special characteristics, but that's why...

May be you can ask the company "you only work for" to spend some time for proper courses.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
Might want to do some of the Tutorials IBI offers on this site.

We try to be a happy group here. Smiler


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
smilin' 'til we drop!


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
Almost Miller Time.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Miller time? I thought you'd never ask Smiler

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
T, aren't you supposed to be sleeping?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Sleeping? When there's a miller on offer? You've got to be joking Smiler

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Guru
posted Hide Post
All,

When I started with webfocus, also in the same situation as WP10601, i was really upset and unhuppay with the documentation.
I then discover this forum and with all the help I got from you i could progress and my knowledge is growing day per day.

Thanks


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
Guru
posted Hide Post
Trying to earn my Gold status...

Just wanting to point this out... the multiselect dropdown passes the values to the fex already enclosed in quotes. a single select or any other control doesn't have the value in quotes.

Okay, so, it's not the most helpful tip... but you won't believe how many times I've stared at a fex trying to figure out why it is failing only to find out I'm missing quotes.


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Expert
posted Hide Post
Majid,

We all know what you mean, and we are happy that people like yourself have grown in your knowledge and understanding of WebFOCUS. Long may it continue.

I, myself, am also disillusioned with some of the documentation and even after over twenty years of utilising FOCUS I still keep the manuals close to my working area. However, as do many of the more frequent posters on theis Forum, I contribute to some articles, profer suggestions as to improvements etc., and mostly IB listen and look at improving things but to ensure real problems get fixed we have a responsibility to raise cases and get them progressed.

For an example of improvement, take this Forum and the myriad of explanations and examples that have been provided over the years, IB has seen that there is a wealth of knowledge in the contributions here and have incorporated these posts into an enhanced search facility (which can be accessed from the top right). These supplement any documentation that exists but the end user must make the effort to use them.

As a community we are trying to help and assist those that are starting out on their journey into learning what they can achieve with WebFOCUS, just as we did a while ago (for some it is many years!!). From my point of view, I am happy to assist where I can but draw the line when an individual is not willing to meet us half way by doing some preparation and searching for themselves.

We all learn at different rates and by different methods, but I think most will agree that if you invest in your learning through time then often the lesson sticks more firmly than if no effort is given.

Remember FOC is the prefix for FOCUS errors and not always an acronym for Free Of Charge!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Virtuoso
posted Hide Post
Had the Miller...slept...now it's coffee time!
Well Said Tony on your mini speech.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
Just to add a little bit of extra liens to this post:
There are two ways to get multiple values from an html dropdown list.
The first one has been discussed above and concerns html screens that have been created within DevStudio with DevStudio tools. These will respect the FOC_NONE technique and also enclose values in quotes sepearated by AND or OR clauses.
The second way is how we used to do this in the old days, when there was no HTML painter around in WebFOCUS.
That way returns the variables as separate &vars, made unique by a sequence number attached to it.
Example:
Your field is called FIELD.
If you select 1 value, you get returned &FIELD.
If you select more than 1 value, you get returned:
&FIELD - contains the first value you selected
&FIELD0 - contains the total number of values selected
&FIELD1 - &FIELDxx contain the individual selected values.
Quite a nice technique, I used it a lot.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report 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     HTML Form data to Webfocus

Copyright © 1996-2020 Information Builders