#1
  1. cave painting, the 1st Opn Src
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Posts
    532
    Rep Power
    0

    Manipulate xsl like an sql query


    Code:
    --- xml file ---- 
    <SEC>
      <ROLE profile="prod" >
       <SecClassName>FilesAC</SecClassName>
      </ROLE>
      <ROLE profile="prod" >
        <SecClassName>FilesAD</SecClassName>
      </ROLE>
      <ROLE profile="test" >
        <SecClassName>FilesAC</SecClassName>
      </ROLE>
      <ROLE profile="test" >
        <SecClassName>FilesAM</SecClassName>
      </ROLE>
    <SEC>
    ---- xsl file ----
    <xsl: value-of select="if (SEC/ROLE/@profile ="<?pho echo $Profile ?>")">
    I can get the data to return as a list, Not I'm trying to translate my sql thought process to xpath and I'm looking for the 'Distinct' and 'where' clause.

    I want to return a 'Distinct' list of @profile, This will be my var array (radiobuttons), $Profile EDIT: Ah Ha, use distinct-values for node
    then, on another page, I want to show the SecClassName 'Where' it matches @profile=' . $Profile .'
    Last edited by dba_frog; May 23rd, 2011 at 08:00 AM.
    Curious by Nature,
    Linux by Choice
    Lawson ERP reference tools: Lawsuss.com

IMN logo majestic logo threadwatch logo seochat tools logo