passing multiple query values into memory?

**Centurion** · Centurion, February 16th, 2010 01:07 PM

Hello ppl,

I am running a query which returns various records.

I want to put the ID's of each record returned into memory so that in the next stage I may run my Insert code based on the ID's that were returned in the query.

How can i do this?

**Centurion** · Centurion, February 16th, 2010 01:38 PM

My theory was:

Code:

do until rs.EOF
  for each x in rs.Fields
    RUN THE INSERT CODE HERE
  next
  Response.Write("<br />")
  rs.MoveNext
loop

**jmurrayhead** · jmurrayhead, February 17th, 2010 05:39 PM

Typically, you can do something like

Code:

do while not rs.EOF
    cn.Execute("INSERT INTO tablename (col1) VALUES(" & rs("col1") & ")")
    Response.Write("<br />")
    rs.MoveNext
loop

Above, cn is the name of your connection object.

Thread: passing multiple query values into memory?

LinkBack

Thread Tools

Display

passing multiple query values into memory?

Similar Threads

help with if statement passing multiple criteria

passing 1 or more values in one querystring to show in form inside text boxes

Capturing keystrokes in textbox and passing values to function

href, passing values

when using multiple search values

Bookmarks

Bookmarks

Posting Permissions