Too few parameters...

Results 1 to 2 of 2

Thread: Too few parameters...

  1. #1
    Join Date
    Dec 1969

    Default Too few parameters...

    I am getting the error message below and I do not understand why. When I track the results in the database I get correct values, but when attempting to out put in my page I get an error message. These statements are inside a Select Case statement, although I would hope that would not have a bearing on it working or not.<BR>Here is the error message I am getting:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)<BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.<BR><BR>Here are my SQL statements:<BR><BR>dim objMP3, objMP3SQL,objMP3ProdSQL,objMP3Prod<BR> <BR>Set objMP3Prod = Server.CreateObject("ADODB.Recordset")<BR>objMP3Pr odSQL = "Select prodID FROM sfProducts WHERE prodName = &#039;" & Request.Querystring ("prodID") & "&#039;" &#039;& objProdRS("prodID")<BR>objMP3Prod.Open objMP3ProdSQL, cnn<BR> <BR>Set objMP3 = Server.CreateObject("ADODB.Recordset")<BR>objMP3SQ L="Select * FROM (sfAttributeDetail INNER JOIN sfAttributes ON sfAttributeDetail.attrdtAttributeId = sfAttributes.attrID) WHERE sfAttributes.attrProdId = mp30011" &#039;& objMP3Prod("prodID") & ""<BR>objMP3.Open objMP3SQL, cnn&#039;, , adLockOptimistic, adCmdTxt

  2. #2
    Join Date
    Dec 1969

    Default, Databases, errors. (eop)


Posting Permissions

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