Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -129,7 +129,7 @@
129	129	select name, vorname from tabelle where ort like concat(?, '%')
130	130	{{/code}}
131	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.
	132	+This SQL statement returns the names of all persons who live in a place that **starts **with the given characters. The '%' character serves as a wildcard 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	133
134	134	URL for running the query: {{code}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&sqlParameter=Par{{/code}}
135	135
...	...	@@ -138,9 +138,6 @@
138	138	select name, vorname from tabelle where lower(ort) like concat('%', lower(?), '%')
139	139	{{/code}}
140	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.
	141	+This SQL statement returns the names of all persons who live in a place that **contains **the given characters. Upper/lower case spelling is irrelevant becauce the statement converts both, the value column and the actual filter value to lower case (lower(...)). The requested value is passed via URL parameters.
142	142
143	143	URL for running the query: {{code}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&sqlParameter=aRi{{/code}}
144		-
145		-
146		-