1. Please build a database name in sqlserver: house and run the following script in house
ifexists(select*fromsysobjectswhereid=object_id(N´[dbo].[City]´)andOBJECTPROPERTY(id,N´IsUserTable´)=1)
droptable[dbo].[City]
GO
ifexists(select*fromsysobjectswhereid=object_id(N´[dbo].[Area]´)andOBJECTPROPERTY(id,N´IsUserTable´)=1)
droptable[dbo].[Area]
GO
CREATETABLE[dbo].[City](
[id][int]IDENTITY(1,1)NOTNULL,
[name][nvarchar](10)NULL
)ON[PRIMARY]
GO
CREATETABLE[dbo].[Area](
[id][int]IDENTITY(1,1)NOTNULL,
[CityId][int]NULL,
[name][nvarchar](20)NULL
)ON[PRIMARY]
GO
INSERTINTOCity(id,name)Values(1,"Guangzhou")
INSERTINTOCity(id,name)Values(2,"Shanghai")
INSERTINTOCity(id,name)Values(3,"Beijing")
INSERTINTOArea(id,CityId,name)Values(1,1,"Tianhe")
INSERTINTOArea(id,CityId,name)Values(2,1,"White Cloud")
INSERTINTOArea(id,CityId,name)Values(3,2,"Hongkou")
INSERTINTOArea(id,CityId,name)Values(4,2,"Baoshan")
INSERTINTOArea(id,CityId,name)Values(5,2,"Jing'an")
INSERTINTOArea(id,CityId,name)Values(6,3,"Haidian")
INSERTINTOArea(id,CityId,name)Values(7,3,"Chaoyang")
2. Create a file
Create file CityData.asp
<%@LANGUAGE=VBSCRIPT%>
<%RSDispatch%>
<SCRIPTRUNAT=SERVERLanguage=javascript>
<!--#INCLUDEVIRTUAL="/_ScriptLibrary/RS.ASP"-->
<!--#INCLUDEVIRTUAL="/jsconn.asp"-->
functionDescription()
{
this.GetAreaAsArray=DoGetData;
}
public_description=newDescription();
functionDoGetData(cityId)
{
varsql,rst,strText,conn,i,j
conn=newActiveXObject("ADODB.Connection");
conn.ConnectionString=connstr;
conn.ConnectionTimeout=30;