
Revised specifications
======================


ASP and HTML filenames and descriptions:
=======================================
SelectQuery.asp  -:- to display a list of email addresses from the database

submission form/s needed:
=================
NO FORM NEEDED THE DATA IS ALREADY CAPTURED IN ENTERGENOCIDE.HTML



SQL Query :
========
SelectSql= "SELECT Name,Email,DBOwner FROM Email_Addresses WHERE " &_
"           DBOwner='GENOCIDE';"  'please note single quotes in SQL is
same as double quotes bu double quotes in string terminates the string so
use single quotes

variables to be used to hold data elements:
 ===========================
SelectSQL is variable that will hold my SQL QUERY
RS,SET Conn,dsn, variables used for database dao access

colmn1 , colmn2 to hold the two data columns from the recordset

In-line scriptlets (ASP) to deliver sql query:
==============================================
<%
 set Conn= Server.CreateObject("ADODB.Connection")
 	dsn ="DSN=INFO;UID='';PWD=''"
   selectSQL = "SELECT Name,Email,DBOwner"&_
 	      "FROM Email_Addressess" &_
 		"WHERE DBOwner ='GENOCIDE';"

 ' On Error resume next
 	Conn.open dsn
   Set RS = Conn.Execute(selectSQL)

   if Conn.Errors.Count = 0 then

 	do while not RS.EOF
 	  if RS.EOF then
 		exit do
 	  end if
        Name : <%=RS("Name")%><BR> 'display the field values for name and email
        Email: <%=RS("Email")%><BR>

%>


<%
 	end if

 		RS.MoveNext
 	loop
    else
 	response.write"__________ SQL=" & selectSQL
    end if
    RS.Close
    Conn.Close
%>


