Changes for page DB-Abfragen

From version 6.1
edited by jdr
on 19.07.2021, 14:11
Change comment: There is no comment for this version
To version 5.1
edited by jdr
on 19.07.2021, 14:04
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -107,6 +107,11 @@
107 107  
108 108  == Examples ==
109 109  
110 +{{info}}
111 +Starting with {{formcycle/}} Version 6.6.3, the parameter //queryParameterValues// can be used instead of the parameter //queryParameter//. The former is recommended for new projects because the parameter //queryParameter// will not be supported in a future version of {{formcycle/}}. The following examples therefore show one servlet query with //queryParameter// and one with //queryParameterValues// for each SQL query.
112 +{{/info}}
113 +
114 +
110 110  {{code language="sql"}}
111 111  select name, first_name from table where first_name like (?)
112 112  {{/code}}
... ... @@ -114,6 +114,9 @@
114 114  This SQL statement returns the names of all persons with a certain first name. The first name to search for is specified via an URL parameter.
115 115  
116 116  URL for running the query:
122 +{{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameter=Robinson{{/code}}
123 +
124 +URL that can be used starting with {{formcycle/}} version 6.6.3 for running the query:
117 117  {{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameterValues=Robinson{{/code}}
118 118  \\
119 119  
... ... @@ -124,6 +124,9 @@
124 124  Retrieves the name of a person with a certain ID. The ID is given as an URL parameter.
125 125  
126 126  URL for running the query:
135 +{{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameter=100{{/code}}
136 +
137 +URL that can be used starting with {{formcycle/}} version 6.6.3 for running the query:
127 127  {{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameterValues=100{{/code}}
128 128  \\
129 129  
... ... @@ -134,6 +134,9 @@
134 134  Retrieves the names of all persons that live in certain city. The city and the ZIP code are given as URL parameters.
135 135  
136 136  URL for running the query:
148 +{{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameter=Paris,75001{{/code}}
149 +
150 +URL that can be used starting with {{formcycle/}} version 6.6.3 for running the query:
137 137  {{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameterValues=Paris&queryParameterValues=75001{{/code}}
138 138  \\
139 139  
... ... @@ -144,6 +144,9 @@
144 144  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.
145 145  
146 146  URL for running the query:
161 +{{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameter=Par{{/code}}
162 +
163 +URL that can be used starting with {{formcycle/}} version 6.6.3 for running the query:
147 147  {{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameterValues=Par{{/code}}
148 148  \\
149 149  
... ... @@ -154,4 +154,7 @@
154 154  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.
155 155  
156 156  URL for running the query:
174 +{{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameter=aRi{{/code}}
175 +
176 +URL that can be used starting with {{formcycle/}} version 6.6.3 for running the query:
157 157  {{code language="none"}}http://myserver/formcycle/datenquelledb?mandantName=myself&name=demo&queryParameterValues=aRi{{/code}}