...
On the other hand, when the XML documents is created, the date format will follow the definition of the attribute '''xmlDateFormat'''.
=== SQL Query Examples ===
A solid understand of SQL syntax is helpful when creating forms that interact with your database. Below are common and useful example queries.
===== Like Query =====
Sometimes it is useful to match a row where the matching string is not exact. To do this use the SQL Like and % wild card. In this example we want to retrieve all customers that have an email address with a specific email domain 'frevvo.com'. The % wild card must be coded into the configuration.xml query. It cannot be passed down to the query as part of the URI template.
Code Block |
---|
<query name="customers">
<retrieve>
<statement>
SELECT * FROM customers WHERE emailAddr='%{domain}%'
</statement>
</retrieve>
</query> |