Too Few Parameters?

Results 1 to 2 of 2

Thread: Too Few Parameters?

  1. #1
    Terrax Guest

    Default Too Few Parameters?

    Ok, in my ASP page I am making a simple query to update one of the records in my database, but I run into the "Too few parameters" error. I know that this means I am probably spelling something incorrectly so it wants me to define the paramter, but the thing is that I even copied my SQL straight out of Access to ensure it worked perfectly but it still does not work! If anyone can give me any insight into why these errors happen I would very grateful...<BR><BR>Here&#039s the SQL if it means anything:<BR>UPDATE NewsTable SET NewsTable.[Text] = "blah" WHERE (((NewsTable.Index)=1));<BR><BR><BR>Terrax@mediaon<BR>

  2. #2
    jason Guest

    Default RE: Too Few Parameters?

    your problem is probably the double quotes round the parameter - use singles<BR> sql ="UPDATE NewsTable SET NewsTable.[Text] = &#039blah&#039 WHERE (((NewsTable.Index)=1))"<BR><BR>jason

Posting Permissions

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