|
This example shows the use of the
SearchOperators property.
The VBSdb object will return you only those Products with a price less than
or equal to the value inserted into the "Max Unit Price" field.
Search condition
This is the code implementing the example:
<!--#include file="VBSdb/inc.asp"-->
<%
VbsDbNew objVbsDb
objVbsDb( "MdbPath" ) = "data/nwind.mdb"
objVbsDb( "Sql" ) = "select ProductName,UnitPrice from Products"
objVbsDb( "ViewMode" ) = "Grid"
objVbsDb( "GlobalStartScreen" ) = "Search"
objVbsDb( "SearchOperators" ) = "UnitPrice|<="
objVbsDb( "GlobalFieldHeaders" ) = "UnitPrice|Max Unit Price"
VbsDb objVbsDb
%>
This demonstrative program connects to
Nwind.mdb, the well known Microsoft Access sample database: the names of companies,
products, people,
characters, and/or data mentioned herein are fictious and are in no way
intended to represent any real individual, company, product, or event.
To download a copy of Nwind.mdb, please visit
Microsoft's site.
| 