Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    8

    Unanswered: Strange behaviour from NO_DATA_FOUND

    <deleted>
    Last edited by appoooh; 10-29-03 at 08:58.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Strange behaviour from NO_DATA_FOUND

    This is because you have used a parameter name "address" which has the same name as a column in the People table. So this line:

    AND address = People.Address

    is treated as:

    AND People.address = People.Address

    Therefore, only the "author" parameter is actually being used in the SELECT.

    You should prefix your parameter names, either like this:

    p_author

    Or in the SQL like this:

    AND CheckAuthor.address = People.Address

Posting Permissions

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