The location specified in ACTION will depend on your set up.
The dataset records are retreived from is determined by the value of the input parameter 'DataSet'. If there is no DataSet input then the first dataset is used.
To enable WebDataServer to select records to return in response to form submission, create form inputs with names which exactly match (case sensitive) the names
of fields in your data. Records with data values which match all the values for input fields, will be returned. Text field matches require exact (not case
sensitive) string equality. However you can request that 'start with' or 'contains' matching be done. To do so, include an input
parameter whose name is the field name with Crit added to the end. For example lastNameCrit. Make the value of this input 'starts with'
or 'contains' (without the quote marks) and the desired search will be done.
Note: if a form input is left blank, then no matching is done on the field - it is assumed that the user has decided not to use this field in their selection criteria.
Numeric field matches are done using arithmetic comparison. The criteria can be 'lt', 'le', 'eq','ge', or 'gt'. Number fields inputs can be paired to create a range of values by having two inputs which use the field name and two criteria inputs (both named with the field named plus 'Crit'). Generally you'll want one criteria value to be 'ge' and the other to be 'le'.
Criteria | Text use | Numeric use |
---|---|---|
is | string equality | arithmetic equality |
starts with | string start with | N/A |
contains | string contains | string contains |
ge | N/A | arithmetic greater than or equal to |
gt | N/A | arithmetic greater than |
eq | N/A | arithmetic equality |
le | N/A | arithmetic less than or equal to |
lt | N/A | arithmetic less than |
You can also use form inputs to override dataset configuration parameters including the maximum number of records to return and the template files used to format the results. To override a configuration parameter create an input whose name is the same as the configuration parameter name and give it the desired value. Of special significance is the DataSet input, which specifies which dataset to search and will generally be a hidden input. If no dataset is specified then the first dataset is searched.
What if I want to allow multiple entries for the same field?
For example you might want to let the user enter multiple zip codes to search in. This will work fine. Just make multiple inputs with
the same name (the field name). Records that match any of the entries will be returned. You can have one criteria input which applies to all the user inputs or have separate criteria for each user input - they'll be paired in the same order they appear in the form.
Note: You may have only set of such fields in which the same record can match multiple times. For example with a contains
search on 'dog' and 'cat', the string 'dogs and cats' will match both entries.
You can also use the 'GET' method for sending data to WebDataServer. Do so you could put something like this in your form:
<A HREF="/DataServer/WebDataServer.acgi?PID=12345&SortField=ROLE&DataSet=Players">Click here to see the players.</A>
Remember however that the HREF string is limited in length, spaces are not allowed in values (substitute plus (+) signs) and the inputs
values cannot be modified.