WebGate Anywhere Developer Center

<tml:query>

Description:
The content of the query tag contains the search term of the collection. The language the search term is formulated in depends on the database.
Attributes:
General WebTML attributes are hidden -> show general attributes
Name Value(s) Version Usage

Details:
NOTE:

In releases before WGA 2.1 the <tml:query> tag was only allowed within <tml:collection>.
From WGA 2.1 on the tag can also be used outside <tml:collection>. Normally the attribute id="..." will be used to be able to refer to the result of the query later.

Tag-Infos:
  • fullquery: The in the end executed query after implicit additions and modifications.
Examples:

    <tml:collection>

      <tml:query id="adressen">
        select * from adressen
      </tml:query>
      <tml:forach>
        <li><tml:item name="lastname"/></li>
      </tml:foreach>
    </tml:collection>


    <tml:query id="bill" db="names" type="view">
      people;Bill Gates;True
    </tml:query>
    <tml:item context="query:bill" name="phone"/>
      Searches the view "people" in the (Notes-) database "names" with the entry "Bill Gates" and returns the telephone number.

    <tml:query return="Name">Select * from customers where no. = '1'</tml:query>
      Returns the field name of the first hit of the SQL-request.
Syndicate
RSS 2.0
Dokumentationen
© Innovation Gate