Passing value to an array

[intscript]

Good day everybody, please help me why i got this error. I cant pass the value to an array. Error message is type mismatch



Do until objRSYield.eof

LotNo = objRSYield("vcLotNo")

SQLQtyIn = "Select iLotQty from tbl_Dicing where vcLotNo = '"&LotNo&"' "
Set objRSQtyIn = Server.CreateObject("ADODB.RecordSet")
objRSQtyIn.Open SQLQtyIn, objConn, 1

QtyInFnd = objRSQtyIn.recordcount


//i got error here (type mismatch)

Arr(0) = 0


if not objRSQtyIn.eof then
Arr(0) = objRSQtyIn("iLotQty") // i got error here (type mismatch)
end if

objRsYield.Movenext
Loop

[shweta123]

Hi,

You can debug by checking the value of objRSQtyIn("iLotQty"). It may not be containing any value.

[clain]

Hi,

You can debug by checking the value of objRSQtyIn("iLotQty"). It may not be containing any value.

yess thats true... even it can hve the 'null' or ' ' or \0 or even sharectre nulllll