calling recordset items out of order in sql

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

calling recordset items out of order in sql

Author

Topic

jimsurf
Starting Member

18 Posts

Posted - 2006-10-20 : 15:15:03

I am using classic asp and SQL Server 2000. I am having a weird problem where all values in the recordset are empty if I call them in a different order in which they are called in the sql statement.
I had this problem once a long time ago with access but I can't seem to find any info on it now. In other words,

strSQL = _
" SELECT CandidateFirstName " & _
" , CandidateLastName " & _
" , CandidateEmail " & _
" , SubmissionDate " & _
" , CandidateCoverLetter " & _
" , CandidateResume " & _
" , SubmissionDate = CAST(CONVERT(varchar(10), SubmissionDate,101) AS DATETIME) " & _
" , JobID = J.JobID " & _
" , JobNumber = J.SystemID " & _
" , Active " & _
" , Region " & _
" , JobType " & _
" , JobTitle = CASE WHEN JobTitle IS NULL THEN 'N/A' ELSE JobTitle END " & _
" , JobTerm " & _
" FROM WS_ResumeLog RL " & _
" LEFT OUTER JOIN WS_Jobs J ON RL.JobID = J.JobID " & _

as I iterate through the recordset in asp, and attempt to call region after a call to jobtype the region value is empty.

RS.Open strSQL, Conn
If Not RS.EOF Then

Response.Write RS("JobType")
Response.Write RS("Region")

even though Region has a value, it writes out nothing.

Is this an ado or mdac issue???

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources