>How can you:
>
>1) Return a recordset/rowset from a SQL Server and determine how many records there are.
>
Do you know how to do it in VB ? Same thing.
'Create object. In this case Connection to a database
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Place here your connection string"
'Open the connection
Conn.Open
'Create recordset
Set Rs = Server.CreateObject("ADODB.Recordset")
'Open recordset with the connection which we have created earlier
Rs.Open "SELECT * from users", Conn, 1,3
'Loop thru records
do while not rs.EOF
Response.Write rs("name") & "
" ' if it's = name then delete, as you know
is an HTML tag for line break
rs.MoveNext ' Movenext
loop
'Deinitialize the Connection and Recordset
set Rs = nothing
set Conn = nothing
>2) Create procedures and functions.
>
You put your function at the top of the page
Function MySub
End Function
>Does ASP have an equivalent VB EXIT SUB/FUNCTION OR END Statement???
Response.end