<?xml version="1.0"?> <xsql:query connection="xmlbook" max-rows="1" rowset-element="Ok" row-element="Airport" xmlns:xsql="urn:oracle-xsql"> SELECT tla "Code", description "Description" FROM AIRPORT WHERE tla = UPPER('{@code}') <xsql:no-rows-query max-rows="4" rowset-element="Error" row-element="Airport"> SELECT tla "Code", description "Description" FROM AIRPORT WHERE UPPER(description) LIKE UPPER('%{@code}%') ORDER BY 2 </xsql:no-rows-query> </xsql:query> |