Custom Expression - Type Mismatch (0x800A000D)

Does it say what line causes the issue?

Type mismatch

/interact/include/commonfunctions.asp, line 381

What is the line 381 in commonfunctions.asp file?

Here is the offending code, Line 381 is marked in bold.
[codebox] Function CustomExpression(strValue, data, field, table)

If table = "" Then table = strTableName

If table = "franchise" And field = "DB" Then

str = "select count() from `DROPBOX` where `FranchiseNbr`='" & strValue & "' and `DBType`='PAYMENT'"

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection
if not rsTemp(0)=0 then

strValue = "<a href=""java script:createWindow('DROPBOX_view.asp?editid1=" & strValue & "','dropbox','width=470,height=250,scrollbars')""><img border=0 src=images/mail.gif></A>"

else

strValue=""

end if

rsTemp.Close : set rsTemp = Nothing

End If

If table = "franchise" And field = "DBEQ" Then

str = "select count() from `DROPBOX` where `FranchiseNbr`='" & strValue & "' and `DBType`='EQUIPMENT'"

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection
if not rsTemp(0)=0 then

strValue = "<a href=""java script:createWindow('DROPBOX_view.asp?editid1=" & strValue & "','dropbox','width=470,height=250,scrollbars')""><img border=0 src=images/equip.gif></A>"

else

strValue=""

end if

rsTemp.Close : set rsTemp = Nothing

End If

CustomExpression = strValue

End Function[/codebox]

Make sure this SQL query returns the actual data. Try to print it on the web page instead of executing.

It's printing properly. I've uploaded this to my demo account if you could take a look. It's the franchise_list page. jforstner@mn.uscable.com

Please send the URL to support@xlinesoft.com.