|
This example shows the use of the
SearchScreenRepeat property. Select an
employee last name and the corresponding first name will be displayed.
Search condition
The current filtering condition is
This is the code implementing the example:
<!--#include file="VBSdb/inc.asp"-->
<%
VbsDbNew objVbsDb
objVbsDb( "MdbPath" ) = "data/nwind.mdb"
objVbsDb( "Sql" ) = "select * from employees"
objVbsDb( "SearchScreenRepeat" ) = true
objVbsDb( "SearchFields" ) = "EmployeeId"
objVbsDb( "InputSelectFields" ) = "EmployeeId|select EmployeeId,LastName from Employees order by LastName"
VbsDb objVbsDb
lngFirstName = VbsDbGetOutputFieldValue( "FirstName" , objVbsDb )
response.write "The current filtering condition is " & session( "VbsDbFilterWhereClause_" & objVbsDb( "GlobalId" ) )
VbsDbClose 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.
| 