CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009
    Posts
    596

    [RESOLVED] SQL Help

    Good morning all,

    When I run my report I get an error message that says "Too few parameters, expected 3". It's the "Location in (30, 31, 32)" that I'm trying to get to work in the query and it's not happening. I've tried it with and without quotes on the 30, 31, 32. Can someone please tell me what I'm doing wrong or show me another way to get this to work. Please.

    SELECT
    OEINVH.`CUSTOMER`, OEINVH.`BILNAME`, OEINVH.`TERRITORY`, OEINVH.`INVFISCYR`, OEINVH.`INVFISCPER`, OEINVH.`INVNETWTX`
    FROM
    `OEINVH` OEINVH
    WHERE
    OEINVH.`LOCATION` IN (`30`,`31`,`32`)
    ORDER BY
    OEINVH.`TERRITORY` ASC

  2. #2
    Join Date
    Dec 2009
    Posts
    596

    Re: SQL Help

    Never mind; figured it out. Thanks anyway

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured