source: ISOcat/trunk/mod-ISOcat-access-data/access/dc_pid2id.acc @ 2029

<accessor debug="false">
        <name>ISOcat.access.data.dc.pid2id</name>
        <descr>Get the id of a DC based on its PID.</descr>
        <param mandatory="true">
                <name>pid</name>
                <descr>the DC PID</descr>
                <type canonical="true">string</type>
        </param>
        <idoc>
                <seq>
                        <instr>
                                <type>sloot.xquery</type>
                                <operator>
                                        <xquery>
                                                declare variable $pid as node() external;
                                                
                                                &lt;sql>
                                                        SELECT
                                                                id
                                                        FROM
                                                                core_data_category
                                                        WHERE
                                                                pid = '{string($pid)}'
                                                        ;
                                                &lt;/sql>
                                        </xquery>
                                </operator>
                                <pid>var:pid</pid>
                                <target>var:sql</target>
                        </instr>
                        <accessor-debug>
                                <instr>
                                        <type>copy</type>
                                        <operand>var:sql</operand>
                                        <target>ffcpl:/trace/dc_pid2id.sql.xml</target>
                                </instr>
                        </accessor-debug>
                        <instr>
                                <type>sqlQuery</type>
                                <operand>var:sql</operand>
                                <target>var:result</target>
                        </instr>
                        <instr>
                                <type>sloot.xpath2eval</type>
                                <operand>var:result</operand>
                                <operator>
                                        <xpath>(/results/row/id)[1]</xpath>
                                </operator>
                                <param>
                                        <return>
                                                <canonical/>
                                                <string/>
                                        </return>
                                </param>
                                <target>this:response</target>
                        </instr>
                </seq>
        </idoc>
        <exception>
                <debug/>
                <trace>ffcpl:/trace/dc_pid2id.exception.xml</trace>
                <response>
                        <string/>
                </response>
        </exception>
        <response>
                <debug>ffcpl:/trace/dc_pid2id.response.xml</debug>
                <mime>application/xml</mime>
        </response>
</accessor>