... |
... |
@@ -123,24
+123,3 @@ |
123 |
123 |
Retrieves the names of all persons that live in certain city. The city and the ZIP code are given as URL parameters. |
124 |
124 |
|
125 |
125 |
URL for running the query: {{code}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&sqlParameter=Paris,75001{{/code}} |
126 |
|
- |
127 |
|
- |
128 |
|
-{{code language="sql"}} |
129 |
|
-select name, vorname from tabelle where ort like concat(?, '%') |
130 |
|
-{{/code}} |
131 |
|
- |
132 |
|
-This SQL query returns the names of all people who live in a place that **starts **with the letters/characters you are looking for. The '%' character serves as a placeholder for any number of characters. Depending on the DBMS used, the syntax may differ slightly (here: MySQL). The requested value is passed via URL parameters. |
133 |
|
- |
134 |
|
-URL for running the query: {{code}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&sqlParameter=Par{{/code}} |
135 |
|
- |
136 |
|
- |
137 |
|
-{{code language="sql"}} |
138 |
|
-select name, vorname from tabelle where lower(ort) like concat('%', lower(?), '%') |
139 |
|
-{{/code}} |
140 |
|
- |
141 |
|
-This SQL query returns the names of all people who live in a place that **contains **the letters/characters you are looking for. Upper/lower case spelling is irrelevant here, since the query in the database converts both, the value column and the actual filter value to lower case (lower(...)). The requested value is passed via URL parameters. |
142 |
|
- |
143 |
|
-URL for running the query: {{code}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&sqlParameter=aRi{{/code}} |
144 |
|
- |
145 |
|
- |
146 |
|
- |