|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: using Recordset Filter Method |
|
From: |
Savitha |
|
Date: |
10/13/1999 1:35:56 PM |
|
IP: |
207.115.48.67 |
You can trying writing a javascript to filter the records when a search button is clicked:
To keep it simple say, the filter is user="ABC" and variable MyVar="ABC"
There is a recordset called MyRecordset, the Javascript is as below:
<SCRIPT LANGUAGE=javascript RUNAT = Server>
function SearchBtn_onclick() {
newSQL = "Select * FROM Users WHERE user =" + MyVar + "";
if (MyRecordset.isOpen()) {
MyRecordset.close();
}
MyRecordset.setSQLText(newSQL);
MyRecordset.open();
}
</SCRIPT> |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
