Friday, January 16, 2009

Selecting data from a single table without having to write a XSL stored procedure

Use the MetaData function. Specify the table name, the parameter and set it to select a single node. You can use the getAttribute function to extract the value.

    xmlTest = MetaData("LSCMCONTRACTITEM", {"UIDCONTRACTITEM":"124"}, {"LOOKUPS":"NO"}).selectSingleNode("//LSCMCONTRACTITEM");

    Response.Write("<br>UIDCONTRACT: " + xmlTest.getAttribute("UIDCONTRACT"))

1 comment:

  1. Hi, is this possible for multiple parameters? Thanks.

    ReplyDelete