This is driving me nuts!!!!

[Guest_imported]

I am still having problem with this code.
Here is the select part, the error it is throwing and where it is throwing the error.
I need your help, please!!!!!!!
SqlStmt = " SELECT Training.TrainingID, Training.Courses, " &_
" Training.CourseType, Training.PosNumber,Training.CourseStatus, " &_
" Reason.Reasons,Personnell.LastName,Personnell.FirstName, " &_
" Personnell.MiddleInitial,Personnell.HireDate,Personnell.JobTitle, " &_
" Personnell.DeptAssignedTo,Personnell.JobGrade,Personnell.AcctFund " &_
" FROM Personnell, Training,AccountingFund,Grading,Reason " &_
" WHERE Personnell.PosNumber = Training.PosNumber " &_
" AND Training.PosNumber = Reason.PosNumber " &_
" AND Reason.PosNumber = AccountingFund.PosNbr " &_
" AND AccountingFund.PosNbr = Grading.PosNbr " &_
" OR Personnell.LastName = " & "'" & Request.QueryString(" LastName &quot & "'" &_
" OR Personnell.FirstName = " & "'" & Request.QueryString(" FirstName &quot & "'" &_
" OR Personnell.JobGrade = " & "'" & Request.QueryString(" JobGrade &quot & "'" &_
" OR Personnell.JobTitle = " & "'" & Request.QueryString(" JobTitle &quot & "'" &_
" AND Personnell.PosNumber = " & iRecordId & &quot"

This is the error:

Error Type:
(0x80020009)
Exception occurred.
viewHR_recs.asp, line 68
This is where line 68 is:
<TR>
<TD ALIGN=LEFT> <FONT CLASS='Arial10' COLOR=RED><B>
Position Number
</TD>
<TD ALIGN=LEFT>
<%
Response.Write(&quot;<INPUT TYPE='TEXT' NAME='Pos_Number' VALUE=&quot; & rsGlobalWeb(&quot;posNumber&quot & &quot; >&quot
%>
</TD>
</TR>

 

[GaryC123]

Instead of -
<%
Response.Write(&quot;<INPUT TYPE='TEXT' NAME='Pos_Number' VALUE=&quot; & rsGlobalWeb(&quot;posNumber&quot & &quot; >&quot

Try it like this

<INPUT TYPE='TEXT' NAME='Pos_Number' VALUE=&quot;<%=rsGlobalWeb(&quot;posNumber&quot%>&quot;>

 

[onpnt]

have you response.write the rs to the screen seperately to see if that is the problem.
try breaking it up a bit also
<%
Response.Write(&quot;<INPUT TYPE='TEXT' NAME='Pos_Number'VALUE=&quot
Response.Write(chr(34) & rsGlobalWeb(&quot;posNumber&quot & chr(34))
Response.Write(&quot; >&quot
%>
ouput should be
<input type='text' name='Pos_Number' value=&quot;posNumber&quot;>
makes for easier debugging

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[Guest_imported]

None worked!
One by Gary is throwing the same error as the error I posted.
One by onpnt is throwing error on this line:
Response.Write(chr(34) & rsGlobalWeb(&quot;posNumber&quot & chr(34))
REALLLLLLY frustrating.
The same exact code was working yesterday.

 

[onpnt]

did you response.write rsGlobalWeb(&quot;posNumber&quot
to see if that also gives you a error. and if so is it the same error. It just sounds like there is a problem in the DB with that field. Maybe check the settings on it and make certain you are passing a value and you are not either at the EOF or BOF in the RS

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[GaryC123]

You have a closing bracket in the last line of ur sql statement without an opening one, if it should be there at all

 

[Guest_imported]

I apologize to all of you for wasting your time.
You guys are indeed gracious.
I have a so-called dba who just sits around pretending to be a web developer and keeps updating data.