xml| Refresh | No refresh ASP Query XML code, realize no refresh, fuzzy query function
<title> ways to not refresh page queries </title>
<meta http-equiv= "Content-type" content= "text/html; charset=gb2312 ">
<script language= "JavaScript" >
<!--initialization, loading data into a list box in the data island-->
function Loadinsel ()
{
var employeeid,employeelastname; Store employee ID and employee name separately
Root=document.all.xmlemployees.childnodes.item (0); Returns the first element--employee
for (i=0;i<root.childnodes.length;i++) {
Getnode=root.childnodes (i); Get a child node of Empolyee
Employeeid=root.childnodes (i). getattribute ("Emid");/Get Employee ID
for (j=0;j<getnode.childnodes.length;j++) {
Employeeinf=getnode.childnodes (j). NodeName;
if (employeeinf== "LastName") {
Employeelastname=getnode.childnodes (j). Text; Get Employee Name
}
}
Write the resulting EmployeeID and employeelastname into the Select
if (employeeid!= "" && employeelastname!= "") {
Option1=document.createelement ("option");
Option1.text=employeelastname;
Option1.value=employeeid;
Employeelist.add (Option1);
}
}
}
<!--initialization, retrieving data from the data island, loading the list box-->
function Findemployee () {
var Employeelastname,employeeid; Store employee name and employee ID separately
Employeelastname= "";
Employeeid= "";
Findtext=window.findcontent.value; Get a search condition
Clear list Box
Employeecount=employeelist.length
for (i=employeecount-1;i>=0;i--) {
Employeelist.remove (i);
}
Root=window.xmlemployees.childnodes (0);
for (i=0;i<root.childnodes.length;i++) {
Getitem=root.childnodes (i); Get a child node of Empolyee
Employeeid=root.childnodes (i). getattribute ("Emid"); Get Employee ID
for (j=0;j<getitem.childnodes.length;j++) {
if (Getitem.childnodes (j). nodename== "LastName") {
Employee_temp=getitem.childnodes (j). Text;
if (Employee_temp.indexof (FindText)!=-1) {//Find match
Employeelastname=employee_temp; Find the employee whose name matches
}
}
}
Write the qualified employee information into the Select
if (employeeid!= "" && employeelastname!= "") {
Option1=document.createelement ("option");
Option1.value=employeeid;
Option1.text=employeelastname;
Window.employeelist.add (Option1);
Employeeid= "";
Employeelastname= "";
}
}
}
</script>
<body bgcolor= "#FFFFFF" text= "#000000" >
<table width= "80%" border= "1" >
<tr>
<td> Please enter the query criteria:
<input type= "text" name= "Findcontent" >
<input type= "button" Name= "Submit" value= "Find" >
</td>
</tr>
<tr>
<td> Query Results:
<select name= "EmployeeList" >
</select>
</td>
</tr>
</table>
<?xml version= "1.0" encoding= "gb2312"?>
<%
Servername= "wyb" ' Server name
user= "sa" user name
pw= "" ' User password
Databasename= "Northwind" database name
Set Conn=server. CreateObject ("Adodb.connection")
Conn. Open "Driver=sql Server; Server= "&servername&"; Uid= "&user&";p wd= "&pw&";D atabase= "&databasename
Set Rs=server. CreateObject ("Adodb.recordset")
Sql= "Select Employeeid,lastname from Employees order BY EmployeeID"
Rs. Open sql,conn%>
<!--put information from the database into the data island-->
<xml id= "Xmlemployees" >
<employee>
<%do While not rs.eof%>
<employeeitem emid= "<%=rs (" EmployeeID ")%>" >
<lastname><%=rs ("LastName")%></lastname>
</employeeitem>
<%rs.movenext%>
<%loop%>
</employee> </xml>
<%rs.close
Set rs=nothing
%>
</body>
