Receiving 'No Value Given . . .' Error

[OrWolf]

I'm getting the following error when I attempt to grab this recordset. It works without the JumpTo variable which is not a required field, so it may contain blanks. That's why I did what the SQL statement shows below and attempted to make it a value or zero everytime, however that didn't work either. This same statement works just fine without the JumpTo field.


From Screen:
SQL---- SELECT RA_SurveyAnswers.AnswerID, RA_SurveyAnswers.PossibleAnswer, IIf(IsNull([JumpTo]),0,[JumpTo]) AS JumpNo FROM RA_SurveyAnswers WHERE (((RA_SurveyAnswers.RAS_ID)=22));


Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters

/awareness/risk assessment/RA_DSurveyQuestions.asp, line 45


ASP Code (Line 45 is the 'Set rs2' instruction):
aSQL="SELECT RA_SurveyAnswers.AnswerID, RA_SurveyAnswers.PossibleAnswer, IIf(IsNull([JumpTo]),0,[JumpTo]) AS JumpNo FROM RA_SurveyAnswers WHERE (((RA_SurveyAnswers.RAS_ID)=" & iRASID & &quot);"
response.write &quot;SQL---- &quot; & aSQL & &quot;<p>&quot;
Set rs2 = objConnection.Execute(aSQL)

 

[OrWolf]

Please disregard. Problem solved. I was using a test database and the 'JumpTo' field existed in the live database, but not the test database.