Skip to content

    • Connectors

    Connectors

    End of query request - what is wrong

    Member
    in Connectors

    I continue to get an end of query request and not sure what I'm doing wrong. Please help me understand what I'm missing. I have tried adding and adjusting - just not working. Below is the query.

    SELECT *
    FROM CHARGE_DETAIL
    WHERE INVOICE_NUMBER =
    217653436,
    217668183,
    819802440,
    820092602,
    END

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      Answer ✓

      Where is this query being used? In general the syntax looks odd, if you care about the specific invoice numbers the general MySQL query would be:

      1. SELECT *
      2. FROM CHARGE_DETAIL
      3. WHERE INVOICE_NUMBER IN (217653436,
      4. 217668183,
      5. 819802440,
      6. 820092602)

      Does this helps?

    • Coach
      Answer ✓

      @jgRugby_123098

      Since your invoice number field is a string you need to use strings in your IN clause. You can do this by putting them in single quotes

      1. SELECT *
      2. FROM CHARGE_DETAIL
      3. WHERE INVOICE_NUMBER IN ('217653436',
      4. '217668183',
      5. '819802440',
      6. '820092602')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      Where is this query being used? In general the syntax looks odd, if you care about the specific invoice numbers the general MySQL query would be:

      1. SELECT *
      2. FROM CHARGE_DETAIL
      3. WHERE INVOICE_NUMBER IN (217653436,
      4. 217668183,
      5. 819802440,
      6. 820092602)

      Does this helps?

    • Member

      Marcel -

      What you provided seems to get me off that trap. Now, I'm running into the error of :

      ORA-0122:invalid nubmer

      I will do some research on this. Do you happen to know what this means?

      Thank you,

    • Member

      I looks like I now need to change the database field from a string to a number.

    • Coach
      Answer ✓

      @jgRugby_123098

      Since your invoice number field is a string you need to use strings in your IN clause. You can do this by putting them in single quotes

      1. SELECT *
      2. FROM CHARGE_DETAIL
      3. WHERE INVOICE_NUMBER IN ('217653436',
      4. '217668183',
      5. '819802440',
      6. '820092602')
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories