An unhandled data type was encountered.

[Mayoor]

When trying to execute this code, specifically Response.Write(strCheckBoxSubscript) the following error is returned

Response object error 'ASP 0106 : 80020005'

Type Mismatch

/login/calendarchanges.ex.asp, line 0

An unhandled data type was encountered.

For vItem = 1 to Request.Form.Count            
		 if left(Request.Form.Key( vItem),3) = "fld" then
			strCheckBoxSubscript = Split( Request.Form.Key( vItem ), "_" )
			Response.Write(strCheckBoxSubscript) ' the problem lies here......
			Response.end

			aryParams( 0 ) = Array( "@PlayerID", VAR_INTEGER, PARAM_In, 4, session("PlayerId") )
			aryParams( 1 ) = Array( "@TournamentId", VAR_INTEGER, PARAM_In, 8, Request.Form("TournamentID_" & strCheckBoxSubscript))
			aryParams( 2 ) = Array( "@TournamentDetailID", VAR_INTEGER, PARAM_In, 4, Request.Form("TournamentDetailID_" & strCheckBoxSubscript))
			aryParams( 3 ) = Array( "@ChangeDate", VAR_VarChar, PARAM_In, 8, Request.Form("ChangeDate_" & strCheckBoxSubscript))
			aryParams( 4 ) = Array( "@TournamentChangeTypeID", VAR_VarChar, PARAM_In, 4, Request.Form("TournamentChangeTypeID_" & strCheckBoxSubscript))
  			Dba_ExecProcedureNonSelect "sp_InsertCalenderChangesViewed", aryParams, "baseline" 
			
		End if     	 
    Next

 

[Mayoor]

Any idea what it may be?

Any ideas appreciated!

 

[ChrisHirst]

as it would, With strCheckBoxSubscript being an array

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[Mayoor]

Hi can you explain how it is an array?

the decalration in my code is as follows..

Dim vItem 
Dim strCheckBoxSubscript
Dim aryParams(4)

 

[ChrisHirst]

this might be a bit of a clue

strCheckBoxSubscript = Split( Request.Form.Key( vItem ), "_" )

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[Mayoor]

right all I want to do is hold the vlaue of what ever is on the right side of the "_" in the variable strCheckBoxSubscript.

Any ideas how I can do this without using the array on the right. I take what your getting at is the fact that the Split( Request.Form.Key( vItem ), "_" ) is of type array?

 

[ChrisHirst]

split will create an array. so the right hand side will be

strCheckBoxSubscript(1)

or

mid(Request.Form.Key( vItem ), instr(Request.Form.Key( vItem ),"_" ) +1)

or

right(Request.Form.Key( vItem ), len(Request.Form.Key( vItem ))- instr(Request.Form.Key( vItem ),"_" ))

take your pick

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.