Error in ASP...Reply ASAP

Originally Posted by dotnetdev1

Hi Friends,
I am stuck with the following error..Please help me..
The Line 187 is....<% End If ....Actually I tought that the tag was missing but...I tried by adding the tag at the end of End If but..still My problemwas not solved...Please help..

Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/assistdev/INCLUDES/GEN_INCLUDES/DSB_EN_HHSTU_crtAP_HHSTU_001.asp, line 187
End If

Thanks
DND

Originally Posted by dotnetdev1

Hi friend,
Thanks for your reply...I am done with that error..But Now I am facing another error when I am continuing to next page please help me with this

The Error is as follows:

Error Type:
DataAccessV2_2.clsFWDAC.DoRunSP()>Microsoft OLE DB Provider for SQL ServerclsCOMPHOHLD - SaveStudentInfo (0x80040E14)
Household Component Call Fails: SaveStudentInfo - clsCOMPHOHLD - SaveStudentInfo - (ApplicationNumber - 9000218 ) Error Desc: Invalid length parameter passed to the substring function. SPName=USP_UPD_STUD_INFO_EXT, Parameters: Param0 = 9000218; Param1 = 9000236~NO~NO~NO~NO|9000240~NO~NO~NO~NO; Param2 = HHSTU;
/assistdev/PGM/ASP/HHSTU.asp, line 126

And The Code in Line 126 is as follows:

If Len(Request.Form("btn_Continue")) <> 0 then
Call DoValidate()

Call DoContinueDblClick("")
---LINE 126--Response.Redirect m_objHousehold.SaveStudentInfo()--LINE 126--
If Err.number <> 0 then
Call DoLogError()
Response.End
End if


Thanks
Chaitanya...