Focal Point
HTML Form data to Webfocus

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3811022152

October 10, 2007, 03:59 PM
WP10601
HTML Form data to Webfocus
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.
October 10, 2007, 04:07 PM
GinnyJakes
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
October 10, 2007, 04:16 PM
Prarie
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
October 10, 2007, 04:18 PM
WP10601
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
October 10, 2007, 04:22 PM
GinnyJakes
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
October 10, 2007, 04:30 PM
Francis Mariani
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
October 10, 2007, 04:46 PM
FrankDutch
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

October 10, 2007, 05:01 PM
Prarie
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
October 10, 2007, 05:09 PM
Francis Mariani
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
October 10, 2007, 05:18 PM
Prarie
Almost Miller Time.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
October 10, 2007, 05:46 PM
Tony A
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 
October 10, 2007, 05:49 PM
Francis Mariani
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
October 11, 2007, 02:36 AM
Tony A
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 
October 11, 2007, 07:18 AM
Majid Jeddi
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
October 11, 2007, 08:50 AM
Anatess
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
October 11, 2007, 09:07 AM
Tony A
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 
October 11, 2007, 09:14 AM
Prarie
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
October 11, 2007, 09:17 AM
GamP
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