type mismatch

Results 1 to 2 of 2

Thread: type mismatch

  1. #1
    Join Date
    Dec 1969

    Default type mismatch

    Why does this give me a "Type Mismatch"?<BR><BR>strSQL = "SELECT count(*) as cntrec FROM "& strTable &" WHERE "& strTable &".field like &#039%"& strClient &"%&#039"<BR><BR>intresult = objrs("cntrec")<BR>If intresult &#062; 0 Then<BR>Response.Write ("greater then 0")<BR>End If

  2. #2
    Join Date
    Dec 1969

    Default RE: type mismatch

    This has come up numerous times in the last couple of weeks. Just type your result variable to an integer (CInt) or long (CLng) and it&#039ll work fine.<BR><BR>intresult = CLng(objrs("cntrec"))<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts