I have the following code... [cod

[tylerjones]

I have the following code...

sqlTmp = "Select EducationComment, RelocationComment, Resume, Comments FROM dbo.JobSeeker JS WHERE (Downloaded = 0) AND (AgencyID = '" & session("agencyID") & "') AND (JobSeekerID = " & userID & ")"

		set tmpRS = server.createobject("adodb.recordset")
		tmpRS.ActiveConnection = conn
		tmpRS.open sqlTmp, , adopenforwardonly, adLockReadOnly

		if not tmpRS.eof then
			EducationComment = trim(rs("EducationComment") & "")
			RelocationComment = trim(rs("RelocationComment") & "")
			ResumeField = trim(rs("Resume") & "")
			Comments = trim(rs("Comments") & "")
		end if

		tmpRS.close
		set tmpRS = nothing

All the fields are text fields in a SQL Server 7 database. As soon as I try to assign the values to a variable I get an exception has occurred error. Does anyone have any ideas why? It doesn't seem to matter whether the field actually contains data or is null... I get the error either way. Thanks.

 

[MarkSweetland]

You're using rs instead of tmpRS...


if not tmpRS.eof then
EducationComment = trim([red]rs[/red]("EducationComment&quot & "&quot
RelocationComment = trim([red]rs[/red]("RelocationComment&quot & "&quot
ResumeField = trim([red]rs[/red]("Resume&quot & "&quot
Comments = trim([red]rs[/red]("Comments&quot & "&quot
end if


Mark The law, in its majestic equality, forbids the rich, as well as the poor, to sleep under the bridges, to beg in the streets, and to steal bread.

Anatole France

 

[tylerjones]

Ah, you're right. But unfortunately, that was not the problem. Thanks for pointing that out though. However, I'm still getting the same exception occurred error.