Home About Us Services Experience Technology Resources Careers News Contact Us
Mission and Values
Leadership Team
Certifications
Capability Statement
Consulting
Development
Turnarounds
Support
Success Stories
Presentations
Publications
Awards
EDI
RFID
Extranet
Voice and Speech
Natural Language
Handheld and Mobile
Articles and Reference
Code Samples
Downloads
Regular Reading
Email Subscriptions
Services Recommendations
Software Recommendations
Current Opportunities
Careers for Developers
VBScript Code Samples
Overviews  |  ADO Connection and Recordset Handling  |  Display QueryString Values
Display Form Values  |  Display Server Values


Overviews
GLOBAL.ASA Introduction
 
ADO Connection and Recordset Handling
Dim cn(20)
Dim rs
Dim n
For n = 0 To 20
  Set rs    = CreateObject("ADODB.Recordset")
  Set cn(n) = CreateObject("ADODB.Connection")
  cn(n).Open "DRIVER={SQL Server};SERVER=SQLSERVER;DATABASE=Pubs;UID=sa"
  rs.Open "select * from authors", cn(n)
  rs.Close
  Set rs = Nothing
  cn(n).Close
  Set cn(n) = Nothing
Next
Display QueryString Values
Response.Write "QueryString Variables:<BR>"
For Each QueryVariable In Request.QueryString
   strVariableName  = QueryVariable
   strVariableValue = Request.QueryString(QueryVariable)
   Response.Write(strVariableName & "='" & strVariableValue & "'<BR>")
Next
Display Form Values
Response.Write "Form Variables:<BR>"
For Each FormVariable In Request.Form
   strVariableName  = FormVariable
   strVariableValue = Request.Form(FormVariable)
   Response.Write(strVariableName & "='" & strVariableValue & "'<BR>")
Next
Display Server Values
Response.Write "Server Variables:<BR>"
For Each ServerVariable In Request.ServerVariables
   strVariableName  = ServerVariable
   strVariableValue = Request.ServerVariables(ServerVariable)
   Response.Write(strVariableName & "='" & strVariableValue & "'<BR>")
Next
© The Intellection Group, Inc.  All Rights Reserved
Privacy Statement    Disclaimer