"" then
varid=request.querystring("id")
if varid=1 then
varcat="client"
elseif varid=2 then
varcat="Purchaser"
elseif varid=3 then
varcat="Place"
elseif varid=4 then
varcat="Lighting"
elseif varid=5 then
varcat="Transmission"
elseif varid=6 then
varcat="Current"
elseif varid=7 then
varcat="Application"
elseif varid=8 then
varcat="projYear"
end if
else
varcat="id"
end if
str= "select * from Tblcustomer order by "& varcat
rst.Open str,myconn,1,3, 1
while not rst.EOF%>