From Anthony Ekperechi [tonycom1@h...]



Dear Sir/Madam,



Could you help me with ASPs to enable me connect to SQL7 with combobox. The



box can have some fields from a database, when clicked and submitted, the



desired result will be printed. eg A car dealer with many brands of cars



such as Mercedes, BMW, Ford, Record, etc.



I will be very grateful to receive your assistance.



Best wishes,



Tony.

<% Dim con, rs 



set Con = Server.CreateObject("ADODB.Connection")

Con.Open "YourDSN","YourID","YourPassword")

Set RS = Con.Execute ("Your Query")

%>

<Table>

<% Do until RS.EOF%>

	<TR>

		<TD>

		<%=RS("fieldName")%></TD></TR>

<% rs.MoveNext

Loop

%>



There ya go...

Really genaric, but you can do with it what you like

-----Original Message-----

From: StephenB [mailto:stephenb@w...]

Sent: Wednesday, January 24, 2001 6:16 AM

To: ASP Web HowTo

Subject: [asp_web_howto] connect to SQL7 with combobox





From Anthony Ekperechi [tonycom1@h...]



Dear Sir/Madam,



Could you help me with ASPs to enable me connect to SQL7 with combobox. The



box can have some fields from a database, when clicked and submitted, the



desired result will be printed. eg A car dealer with many brands of cars



such as Mercedes, BMW, Ford, Record, etc.



I will be very grateful to receive your assistance.



Best wishes,



Tony.