Test your application by saving the master page and previewing the initial page with the form. You can also
use View ??? Live Data Settings to try different values for your form variable; be sure to change the Method
to Post in the Live Data Settings dialog box.
Passing multiple values from a form
For more complex recordsets, you have to write the SQL statement in Dreamweaver??™s advanced Recordset
dialog box. The same technique described earlier in the ???Filtering a detail page recordset in Advanced
mode??? section applies here. Declare a variable that uses one of the following runtime values:
Server Model Name Default Value Runtime Value
ASP and .NET theVariable % Request.Form(???Fieldname???)
ColdFusion theVariable % #Form.Fieldname#
JSP theVariable % request.getParameter(???Fieldname???)
PHP TheVariable % [???Fieldname??™]; ?>
The WHERE clause of the SQL sets the fieldname to the variable, as in this example:
WHERE dbadata.Location = theLocation
Multiple form variables can also be set up in the advanced Recordset dialog box. Assume that you want
your master page to display a list of employees in a particular department at a specific office. The form
might include a drop-down list that displays a number of departments as well as a radio button group for
the different offices.
Pages:
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288