IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

How can i display the String Table values in front end using DSP

  • 1.  How can i display the String Table values in front end using DSP

    Posted Mon September 13, 2004 04:22 PM

    Hi,
    i need to display the values which are in StringTable format(i.e., the values are in rows and columns). anyone please help me out.
    Petrus


    #Integration-Server-and-ESB
    #webMethods-General
    #webMethods-Architecture
    #webMethods


  • 2.  RE: How can i display the String Table values in front end using DSP

    Posted Mon September 13, 2004 05:20 PM

    Hello,

    When you loop through the string table output in your DSP, the string table reduces to a string list.

    Later you can reference each of the fields in the stringTable usingstringTable[0],stringTable[1],stringTable[2],… so on.

    assuming the output of your service is giving “stringTable” output

    HTH
    Bhavani Shankar


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods-Architecture
    #webMethods


  • 3.  RE: How can i display the String Table values in front end using DSP

    Posted Mon September 13, 2004 05:31 PM

    I need it in DSP commands.If i tried with “%value StringTable[0]%” is not working.


    #webMethods-Architecture
    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 4.  RE: How can i display the String Table values in front end using DSP

    Posted Mon September 13, 2004 05:41 PM

    DSP syntax for showing StringList or recordList given from the service output.

    %loop stringTable%
    %value city%
    %endloop%

    HTH,
    RMG


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods-Architecture
    #webMethods


  • 5.  RE: How can i display the String Table values in front end using DSP

    Posted Tue September 14, 2004 04:58 AM

    Hi RMG,
    I’m not getting the value.
    I’m having three column in the StringTable like City,Temperature and population.
    If i’m using,
    %loop stringTable%
    %value city%
    %value temperature%
    %value population%
    %endloop%
    I’m getting only blank values. Please give me the syntax to Retrieve the values from each column.(it should be like California 20 100,000 )

    WFR
    Petrus


    #webMethods-Architecture
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 6.  RE: How can i display the String Table values in front end using DSP

    Posted Tue September 14, 2004 07:22 AM

    There can be several problems here I would sugest to print out all your scope data to see what your DSP page has as data at that point.
    You can use this code to try:
    <p>
    %loop -struct%
    %value $key% %value%<br>
    %endloop%
    </p>
    This should list all variable names and their data of your scope DSP


    #Integration-Server-and-ESB
    #webMethods-Architecture
    #webMethods-General
    #webMethods


  • 7.  RE: How can i display the String Table values in front end using DSP

    Posted Tue September 14, 2004 07:03 PM

    petru,

    Make use DSP Scope functionlity and code the DSP template page this way.

    %invoke fullyqualifiedServerName%

    %scope wrapperRecord% (wrapperRecord is the RootTag of StringTable

    %loop stringTable%
    %value city%
    %value temperature%
    %value population%
    %endloop%

    %endscope%
    %endinvoke%

    HTH,
    RMG


    #webMethods-Architecture
    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 8.  RE: How can i display the String Table values in front end using DSP

    Posted Wed September 15, 2004 02:25 PM

    Hi i am a new user to webMethods and this is the requirement .

    How to parse, and get a particular data from a mail using webMethods flow service.For example from a mail i want to get the customer_id,name something like that… which is inside the mail.can u pls guide to solve that.

    thanks

    ran


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Architecture


  • 9.  RE: How can i display the String Table values in front end using DSP

    Posted Wed September 15, 2004 05:10 PM

    Ranjit,

    Check this link,i have replied the same to Khan
    [url=“wmusers.com”]wmusers.com

    Looks like you both work for a same company and both posted the similar question.

    HTH,
    RMG


    #webMethods-Architecture
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 10.  RE: How can i display the String Table values in front end using DSP

    Posted Thu July 08, 2010 04:46 PM

    Hi,
    Seems that we don’t have answer here.
    I have the same problem. Actually I tried many variants and it was unsuccessful. Did anyone knows the solution of this issue?
    Thanks,


    #Integration-Server-and-ESB
    #webMethods-Architecture
    #webMethods
    #webMethods-General


  • 11.  RE: How can i display the String Table values in front end using DSP

    Posted Thu July 08, 2010 08:53 PM

    I think bash above had it right:

    %loop stringTable%
    %value stringTable[0]%
    %value stringTable[1]%
    %value stringTable[2]%
    %end%

    Give that a try and let us know if that works.


    #webMethods
    #webMethods-General
    #webMethods-Architecture
    #Integration-Server-and-ESB


  • 12.  RE: How can i display the String Table values in front end using DSP

    Posted Fri July 09, 2010 07:33 AM

    Raemon,
    Thanks for reply, but I have:
    %loop All%

    %loop -struct% %loop All% %loop -struct% %value All[0]% %value All[1]% %value All[2]% %value All[3]% %end% %end% %end% %end% And it is not working. Of course I have an idea it is not DSP file it's just invoke. Maybe if I will make DSP - it will work, but... Ok! I think I'll check my idea and then write results. Thank You for Your reply
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General
    #webMethods-Architecture


  • 13.  RE: How can i display the String Table values in front end using DSP

    Posted Fri July 09, 2010 11:14 AM

    Hi one more time,
    Ok! I think I have the result:
    %loop All[$index]%

    		<TD>
    %value All[0]% 
    </TD>
    <TD>
    %value All[1]% 
    </TD>
    <TD>
    %value All[2]%  
    </TD>
    <TD>
    %value All[3]%  
    </TD>
    <TD>
    %value All[4]%  
    </TD>
    <TD>
    %value All[5]%  
    </TD>
    
    %end% The process: each line in stringTable = column on output template. Best regards,
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Architecture
    #webMethods-General