Use Query as Record Set

[maduko]

I'm working with a script intended to pull records from a table. It's a long story- but the page is currently getting them via a query.

The following line appears to work- but it's VERY slow. Any suggestions on how to speed it up or call a table but use criteria?

objRS.Open "qryEMAIL" , objConn ,adOpenKeyset ,adLockReadOnly,adCmdTable

 

[guitardave78]

Can you show the full script and the query?

it may be possible to use

set objRs = objConn.execute("SELECT ........")

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[maduko]

There is no query. Here is the full script that pulls e-mail addresses from a table. In the mail object the address is inserted using objRS("email") for each message.

.....
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DBQ=" & Server.MapPath("newsletter.mdb")& ";Driver={Microsoft Access Driver (*.mdb)}"
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.Open "email" , objConn ,adOpenKeyset ,adLockReadOnly,adCmdTable
......

 

[guitardave78]

So is email a query inside access?
If it is then you can transfer the sql from sql view of the query and use it directly. CAn you show me that as well? Or am i missing somthing lol

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[maduko]

The "email" in the above script refers to a table.

I do have a query in the DB however, which is what precluded the question. It's nothing more than a select * where email <> "".

Pulling from the table doesn't work because some records do not have email addresses.

 

[guitardave78]

Ok

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DBQ=" & Server.MapPath("newsletter.mdb")& ";Driver={Microsoft Access Driver (*.mdb)}"

Set objRS = objConn.execute("SELECT * FROM email")

objRS will contain all of the email records and can be used to loop forward through them

so

if not objRS.eof then
  do while not objRS.eof
    response.write(objRS("COLUMN_NAME") & "<br>")
    objRS.MoveNext
  loop
end if

}...the bane of my life!

http://www.fuzzyd.co.uk