Passing record values from DSP recordlist to wM services

, ,
1

HI,

I have a requirement in which I have to get records from a table based on conditions to display on DSP page and when user clicks on a one of the rows returned he can edit the data for the particular row.

Say if the table has four columns

DeptNo, Name, Staffs, Budget - I have to display NAME, STAFFS BUDGET for the user corresponding to the Dept No he enters , which I have done. The next part is if he clicks on one of the rows returned he should be able to edit the values of the row.

I am having hyperlink for each row returned to do this, but how can i pass all the column values corresponding to THAT particular row user has clicked to the IS update service. When I am using %loop% I dont have an index for the variables in there. How can I accomplish this?

Thanks,
Bharathi

2

are you looking for the $index option to get the current index within that loop?

3

You can certainly build a web-based application using DSP’s to query and update database rows. But why would you do that in Integration Server rather than a more traditional web-development toolset. Even Portal would be a better choice than IS for web user interfaces.

Mark

4

Saurabh,

Can you please elaborate on the $index you mentioned, If its the loop idex then it is what I am looking for.

Thanks,
Bharathi

5

You can look into the developers guide for DSP’s and templates for more information on $index

Or just try it out with %value $index%

6

Mark,

You are right, we had explained the clients it is better to use Portal as we use with many other projects and IS DSP’s are better for our IS Administrative purposes.

The requirement being a look up and smaller one they have decided to have the table in IS config schema and dsp pages to manipulate the look up data.

Thanks,
Bharathi

7

Thank Saurabh, that solved a part of it.

HI,
How can we pass special characters to a DSP?
For e.g

%invoke Test:getDetails% Area Route %loop Services% %value Area% %value Route% Update %endloop% %endinvoke% The value gets passed in the URl file but when I display them in the updateDetails it is not showing correctly. If I am pssing Bayer & Bayer it is showing only Bayer in the test box. Heres the update page I use.

Area
Route

I tried passing in Hidden inputs its giving empty values. Any alternatives please. Thanks Bharathi
8

Hint: Look at built-in services pub.string:URLDecode and pub.string:URLEncode

HTH.