hi...i've been trying to get my code to work for awhile...i can't seem to find the problem...im trying to insert information from tempusers_tbl to users_tbl...they are both in the same database...im using ASP as my scripting language and ACCESS as my db...here is my code...
--------------------------------------------------------
<% @ Language="VBScript" %>
<% Option Explicit %>
<html>
<head><title>4.Insert MAIN DB 1 </title></head>
<body>
<%
Dim connection
Dim name
Dim sSQL
Dim sConnString
sSQL = "Insert into users_tbl select name from (select name from tempusers_tbl tb where NOT EXISTS (select null from users_tbl where name = tb.name))"
Set connection = Server.CreateObject("ADODB.connection")
sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("users.mdb") & ";"
connection.Open sConnString
connection.execute(sSQL)
connection.Close
Set connection = Nothing
%>
Thanks...
</body>
</html>
--------------------------------------------------------
thanks for your time...
--------------------------------------------------------
<% @ Language="VBScript" %>
<% Option Explicit %>
<html>
<head><title>4.Insert MAIN DB 1 </title></head>
<body>
<%
Dim connection
Dim name
Dim sSQL
Dim sConnString
sSQL = "Insert into users_tbl select name from (select name from tempusers_tbl tb where NOT EXISTS (select null from users_tbl where name = tb.name))"
Set connection = Server.CreateObject("ADODB.connection")
sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("users.mdb") & ";"
connection.Open sConnString
connection.execute(sSQL)
connection.Close
Set connection = Nothing
%>
Thanks...
</body>
</html>
--------------------------------------------------------
thanks for your time...