%@ Language=VBScript %> <% Option Explicit %> <% Dim oConn, oRs1, sSql, count 'DB Connection Variables %> <% Set oConn = Server.CreateObject("ADODB.Connection") %> <% oConn.Open Application("CONNSTR") 'Init DB Connection %> <% '------------ Init Page Variables ------------ %> <% %> <% %> <% '------------ =================== ------------ %> <% dim browserdetect, browser Set browserdetect = Server.CreateObject("MSWC.BrowserType") browser=browserdetect.Browser %>
![]() |
| (*fields are required) | Mailing Address(Required) |
![]() |
|
|
|
|
|
| <% sSQL = "select Prodid, product from products where status='Active' order by Product, Prodid" set oRs1 = Server.CreateObject("ADODB.Recordset") oRs1.Open sSQL, oConn, 3, 3 %> |