View Single Post
  #3 (permalink)  
Old January 14th, 2009, 10:38 AM
dalezjc dalezjc is offline
Authorized User
Points: 287, Level: 5
Points: 287, Level: 5 Points: 287, Level: 5 Points: 287, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2006
Location: Colorado Springs, CO
Posts: 60
Thanks: 1
Thanked 0 Times in 0 Posts

Originally Posted by dparsons View Post
Hmm. Two things:

First by doing this:

asp Code:
<%response.write rsqdb("name")%>

You are making the assumption that your recordset will always have data in it which you should not do.

You might want to try something like this:

asp Code:
if not rsqdb.EOF then
response.write rsqdb("name")
end if

Second, the following code is unnecessary:

Finally, the answer to your question: The reason you are getting the error about the column not existing is because it doesn't. While you select j.Name in your sql query you alias it as JobName so, therefore, you must reference it as such:

<%response.write rsqdb("JobName")%>

Thanks for all the tips regarding my code. I just tried to cut and pasted only the relevant parts, but I didn't do a good job of that.

I also tried "JobName" in the response.write, but I'm still getting the same error.

Reply With Quote