Too Few Parameters?

Results 1 to 4 of 4

Thread: Too Few Parameters?

  1. #1
    sarina Guest

    Default Too Few Parameters?

    Ok, so now that I have my multiple fields with the same name working, I seem to be having another problem...I keep getting a "Too few paramaters. Expected 1" Error. Now, I&#039ve checked an error website and according to that website, that error means there&#039s an error in the field/tablename in my WHERE or ORDER BY. I have neither. Why am I still getting this error and how can I fix it?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Too Few Parameters?

    The website is correct -- it&#039s usually a misspelled field name. But could also be that the database table has been changed by someone or that you&#039re not connecting to the same database anymore, etc, etc. It boils down to a field name being used that doesn&#039t exist in the table/view/etc. I would double and triple check the fields used in the query that fails. Response.Write the query and try it in your query tool.

  3. #3
    Join Date
    Dec 1969

    Default RE: Too Few Parameters?

    Too few parameters is a general error message telling you that there is something wrong with the sql-syntax.<BR><BR>Best way to get a sollution: post the quey as it is being fed to the database.<BR><BR>Bart.

  4. #4
    DavidM Guest

    Default Several Reasons:

    These are all things that happen constantly to cause this error, no matter how sure you think you are that these errors don&#039t exist, go through them all 1 at a time.<BR><BR><BR>1. You mispelled a field name you are pulling from.<BR>2. The Variable being passed to the SELECT statement is not being passed at all.<BR>3. If your variable in the SELECT statement is an integer, you may have the syntax wrong.<BR><BR>These are the main 3 reasons I get that error. If you can&#039t fix it try posting code and labelling what each variable is if any.

Posting Permissions

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