Summary

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

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.nlo
	1	+XWiki.mko

Content

...	...	@@ -123,3 +123,24 @@
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	+