|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
