Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: about data types

  1. #1
    Join Date
    Feb 2007
    Posts
    6

    Default about data types

    Hi,
    I use SQLLookupRule component to get a query result.I define the action-outputs variable as string type.but when
    I look at the variable's value.System report the variable's data type
    is'org.pentaho.core.connection.memory.MemoryResultSet'.how can I get the String value.
    Thanks for any help.
    carolWang

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi,

    Hi Carol,

    When you want to retrieve a single value from a result set you can do that in a javascript action.

    e.g.

    my_string = query_result.getValueAt(0,0).toString();

    query_result is the name of the result set and my_string is then the output variable of the javascript action containing the String.

    Regards,
    Ingo

  3. #3
    Join Date
    Feb 2007
    Posts
    6

    Default The problem is solved.

    The problem is solved. thanks for Ingo's reply.

    cheers
    carol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.