Select statement inside a rs loop?

[deeem]

Hi there,

I am using asp to display data from a table in access using standard while loop.

Inside the while loop i would like to create a new sum variable by use the following query, but i get the follow error:

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

{While loop here}

{display data from RSJobs here}

varJob_id = RSJobs("job_id")
RSActual.Source = "SELECT jobtran.job_id, Sum(jobtran.qty) AS actual_hours FROM jobtran INNER JOIN job ON job.job_id = jobtran.job_id WHERE job.job_id= '" & varJob_id & "' AND jobtran.category Like 'L' GROUP BY jobtran.job_id;"
RSActual.CursorType = 0
RSActual.CursorLocation = 2
RSActual.LockType = 1
RSActual.Open()

{end while loop}

And yes, before you ask job_id is a text field. Its not my database!


If anyone could help me in this time of need that would be great!

Regards

Damon