Spry Search Within Multiple Search Fields

In this article Alex will explain how you can, quick and easy, use the Spry Search from the Spry Data Utilities Toolkit to perform a search within multiple search fields.

Example #2: Searching for a Date range

In this example we have a database table events which stores some events with dates. We want to be able to search for events within a date range, so instead of the "First Name" and "Last Name" fields the search form will contain "From Date" and "To Date" fields. The SQL statement will look slightly different:


We are searching for a match where the value in event_date column is between colname AND colname2.
Variable are also being set up in slightly different way.

Here is the PHP example:


As you can see the Type is set to Date. Runtime value, of course, is set to the name of the corresponding field. In this case is $_POST['Date_From'].

ASP Example:


And the Runtime value of the variables is set to an unlikely value:

Conclusion

Hopefully you have found this tutorial to be useful. More information on working with advanced recordsets can be found in Dreamweaver Help. You can access it by clicking Help button in the Advanced view of the Recordset dialog.