ADO Error -Too few parameters. Expected 2

Results 1 to 2 of 2

Thread: ADO Error -Too few parameters. Expected 2

  1. #1
    Nick Tulip Guest

    Default ADO Error -Too few parameters. Expected 2

    Hi<BR><BR>I have this script in which the query below is being pulled from the database but I get this error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e10&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 2. <BR><BR>/new/viewcoupon.asp, line 26 <BR><BR>Below is line 26<BR><BR>&#039MySQL= "select * from Coupons where (country) = &#039" & country & "&#039 and (city) = &#039" & city & "&#039 and (category) = &#039" & category & "&#039 and (coupon) = &#039" & coupon & "&#039Order by value"<BR><BR>Please email me at lunitikmzk@aol.com with a response.<BR>Thank you for any help.

  2. #2
    jhomminga@cmaiglobal.com Guest

    Default RE: ADO Error -Too few parameters. Expected 2

    You have an empty value going to the database so the WHERE clause can’t evaluate NULL or EMPTY unless eplicitly asked for with ISNULL etc.<BR><BR><BR>One of the WHERE clause members is either NULL or EMPTY<BR><BR><BR>Try Len(variable & “”) = 0 to test for NULL and EMPTY<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
  •