Type mismatch

Results 1 to 3 of 3

Thread: Type mismatch

  1. #1
    Join Date
    Dec 1969

    Default Type mismatch

    mysql = "SELECT * FROM Products where ProdID=" & request.form("txtid")<BR> Set myrs = Server.CreateObject("ADODB.RecordSet")<BR> myrs.Open mysql, "products", myconn &#039;1, 3,2<BR><BR><BR>Error Type:<BR>Provider (0x80020005)<BR>Type mismatch.<BR>/2gather.asp, line 27<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Type mismatch

    hmm.. not sure about this but at first glance I would say you are doing to much there.<BR><BR>you are opening the sql statement and then you are trying to open the table as well. Maybe leave out the "products" from you myrs.Open line and see what happens.<BR><BR>Just my quick thoughts, hope it helps<BR><BR>Stephen

  3. #3
    Join Date
    Dec 1969

    Default Read the docs...

    http://msdn.microsoft.com/library/en-us/ado270/htm/mdamth03_2.asp<BR><BR>See any place there where it says you are supposed to provide *both* a SQL statement *and* a table name? Nope. So don&#039;t.<BR><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