Focal Point
[SOLVED] how to get the data from table and html ?

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

October 22, 2009, 04:15 AM
Yangyang
[SOLVED] how to get the data from table and html ?
Q1.

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS XSQLOUT
END
-RUN

the result is

C1 C2 C3
a1 a2 a3
b1 b2 b3
c1 c2 c4


how can i use the XSQLOUT get the [b2]

use this : -SET &TEST1 = ....


Q2. how can get the html value from fex file ?

eg. html
<_select name=test1>
<_option value=1>a<_/option>
<_option value=1>b<_/option>



in fex
-SET &TEST1 = .... get [a]


Thanks,
Yang

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
October 22, 2009, 05:22 AM
<JG>
Yang do a search on the forum, there are many examples
October 22, 2009, 10:42 PM
Yangyang
thanks JG,

I searched ...i think my key not exact
(get data ,get data from html ...)
i try again...

Thanks,
Yang


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
October 25, 2009, 09:06 PM
Yangyang
can anybody help me?


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
October 26, 2009, 11:05 AM
Francis Mariani
Please explain what you would like to do a little more clearly.

Do you want to create option values for a select list form object?

One method:
SET HOLDLIST=PRINTONLY

TABLE FILE CAR
PRINT
COMPUTE OPT1/A100 = '<OPTION VALUE="' || COUNTRY || '">' || COUNTRY || '</OPTION>';
BY COUNTRY NOPRINT
ON TABLE SAVE AS S001
END
-RUN

-HTMLFORM BEGIN
<FORM>
<SELECT>
!IBI.FIL.S001;
</SELECT>
</FORM>
-HTMLFORM END



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 26, 2009, 12:03 PM
Yangyang
to Francis Mariani
thank your reply

you method is put the data in the html...

my mean is :

the result is

Column1 Column2 Column3
a1 a2 a3
b1 b2 b3
c1 c2 c4


i want get the value [a2] with XSQLOUT

the code like this :-SET &TEST1 = ....


Thanks
Yang


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
October 26, 2009, 12:21 PM
Francis Mariani
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA

TABLE FILE CAR
SUM
WEIGHT/D6
HEIGHT/D6
BY COUNTRY
ON TABLE HOLD AS XSQLOUT
END
-RUN

-REPEAT ENDREP1 FOR &COUNTER FROM 1 TO &LINES
-READ XSQLOUT &CA.&COUNTER.A10. &CB.&COUNTER.I6.  &CC.&COUNTER.I6.
-ENDREP1

-? &C


???


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 26, 2009, 01:02 PM
Yangyang
thanks Francis Mariani

i'm trying...



Thanks,
Yang


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET