<%Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = bonfield; User Id = bonfield; Password=bonfield"
%>
<%sql="select * from brand, model where brand.brandID=Model.brandID and brand.brand_type=1 and latest=1 order by brandnamename"%>
