What is wrong with this code?

Results 1 to 2 of 2

Thread: What is wrong with this code?

  1. #1
    Pekkis Guest

    Default What is wrong with this code?

    rs.Open "SELECT * FROM Kortit WHERE korttiid1=&#039" & form_id1 & "&#039 AND korttiid2= &#039" & form_id2 & "&#039 ORDER BY Date DESC", conn, adOpenKeyset, adLockPessimistic <BR><BR>Error says:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e07&#039 <BR><BR> [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression. <BR><BR> /kortti/lue2.asp, line 20

  2. #2
    Join Date
    Dec 1969
    Posts
    100

    Default RE: What is wrong with this code?

    Hi,<BR> Did you check whether both the variables are expecting strings.

Posting Permissions

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