Hi…

I have some problem for looping data from data base. I used the %loop% syntax but it still doesn’t work.

I used the adapter service to select table from oracle dbms,in developer I can run this adapter and it running successful.

After that I made dsp for client, but when I tried to made it, I can’t Invoke and looping this data.

Is there somebody can help me …
“URGENT”…

Hi,
how did you write your %loop% ?

One Example from me: The Adaptor-Service has the output: SteuerDaten_ASOutput/results
%loop SteuerDaten_ASOutput/results%
%value SomeValue%
%endloop%

Hope that helps
Ralf

For Exsample I have Adapter Service name Viewdata in package Exercises.
The Output from this adapter is “ViewdataOutput”.
And I run in developer the result is array string from table. shown like below:

ViewdataOutput 
|-results 
|-results[0] 
|-FIELD1 : abc 
|-FIELD2 : 123 
|-FIELD3 : xxx 
|-FIELD4 : yyy 
|-results[1] 
|-FIELD1 : abc 
|-FIELD2 : 123 
|-FIELD3 : xxx 
|-FIELD4 : yyy 
....etc 

is the dsp code like this?

 

......

%invoke Exercises:Viewdata% 
%loop Exercises_Viewdata/results% 
%value FIELD1%
%value FIELD2%
%value FIELD3%
%value FIELD4%

%ENDLOOP%
%ENDINVOKE%

.....