J
Joey Martin
I have a tmp_phone that I am comparing to table_phonelistings using the
phone field.
I then want to insert the values (ac,phone) from the tmp_phone table NOT
IN table_phonelistings, into the table_phonelistings.
I think I am doing an incorrect loop as it's timing out. Any help is
appreciated. Here is what I have:
sql2="select ac,phone from tmp_phone where phone not in (select phone
from table_phonelistings)"
set rs=conn.execute(sql2)
sql3="insert into table_phonelistings (areacode,phone) values ('" &
rs("ac") & "','" & rs("phone") & "')"
conn.execute(sql3)
do while not rs.eof
loop
conn.close
phone field.
I then want to insert the values (ac,phone) from the tmp_phone table NOT
IN table_phonelistings, into the table_phonelistings.
I think I am doing an incorrect loop as it's timing out. Any help is
appreciated. Here is what I have:
sql2="select ac,phone from tmp_phone where phone not in (select phone
from table_phonelistings)"
set rs=conn.execute(sql2)
sql3="insert into table_phonelistings (areacode,phone) values ('" &
rs("ac") & "','" & rs("phone") & "')"
conn.execute(sql3)
do while not rs.eof
loop
conn.close