View Single Post
  #4 (permalink)  
Old May 14th, 2004, 07:06 AM
bmains bmains is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnectionString
set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open ("select * from Users", objConn)

do while (not objRS.EOF)
  objConn.Execute("insert into Main (userID, page) values ('" & objRS("UserID") & "', '" & Request.ServerVariables("SCRIPT_NAME") & "')")
  objRS.MoveNext
loop

Something like that. Although what are you trying to do?
Reply With Quote