80020009 Exception occurred

[earme]

Hello,

I'm getting the following error in my asp:

(0x80020009)
Exception occurred

It says that it's happening at

 If Trim(varTemp) = "" Then

in the following statement:

Function RestoreNull(varTemp)
	If Trim(varTemp) = "" Then
		RestoreNull = Null
	Else
		RestoreNull = varTemp
	End If
End Function

varTemp is the value of a field of a recordset that gets passed to it. Before this is called it checks to make sure that .eof is not true.
I know that the field isn't a BLOB field or text field, but I don't know much more about it as it's happening offsite and I can't replicate the problem here.
I've never had problems with that statement before.

Any suggestions?
Earme

 

[snowboardr]

If varTmp is empty, and you try to trim it...then I would
say you would get this error (havn't tried it myself)

If varTmp <> &quot;&quot; then TmpVarTemp = Trim(varTmp)

If TmpVarTemp = &quot;&quot; then
etc...

www.vzio.com
ASP WEB DEVELOPMENT