Ok now I am trying to insert the recordset into a new table...I tried to model my insert statement off of your earlier function...but this is where I am lacking in knowledge... here is my code so far...
I feel I am close I just need a little guidence.
If not getregioncodes.eof then
Do while not getregioncodes.eof
For each zipcode in getregioncodes.zipcode sql2 = "INSERT INTO NewDealercodes (deaID,
zipcode) Values ('"&deaID&"',
'"&zipcode&"')"
Next
getregioncodes.MoveNext
loop
response.write "SQL is " & sql2 & "<BR>"
set addzipcodes= conn.execute(sql2)
end if
I know it has to do with my "zipcode" in the FOR statement. But I don't know how to define it from the recordset.
|
