Tuto WEBDEV 25

178 Part 5: Let’s continue the development Test of query with parameters ▶ To run the test of query with parameters: 1. Click . 2. A window is displayed, allowing you to type the different query parameters. Remark The parameters can be ignored by unchecking the box in front of their name. In this case, the selection condition associated with the parameter is ignored. For example, if ParamCustomerName is ignored, the query will take into account the orders of all customers. Remark: If all parameters are unchecked, the query returns the entire result. 3.  Type the following data: • Uncheck ParamCustomerName and ParamStatus. • Select the ParamPaymentModeID parameter. In the lower section of the screen, type "1". • Select ParamMinPrice. In the lower section of the screen, type "1500". • Select ParamMaxPrice. In the lower section of the screen, type "3000". 4. Validate the window. The query result corresponding to the specified parameters is displayed. 5. Close the window. We are now going to create the page used to: • specify the parameters of this query, • run this query, • display the query result.