End of query request - what is wrong

jgRugby_123098
jgRugby_123098 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

Best Answers

  • marcel_luthi
    marcel_luthi 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:

    SELECT *
    
FROM CHARGE_DETAIL
    
WHERE INVOICE_NUMBER IN (217653436,
    
217668183,
    
819802440,
    
820092602)

    Does this helps?

  • GrantSmith
    GrantSmith 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

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

Answers

  • marcel_luthi
    marcel_luthi 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:

    SELECT *
    
FROM CHARGE_DETAIL
    
WHERE INVOICE_NUMBER IN (217653436,
    
217668183,
    
819802440,
    
820092602)

    Does this helps?

  • jgRugby_123098
    jgRugby_123098 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,

  • jgRugby_123098
    jgRugby_123098 Member

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

  • GrantSmith
    GrantSmith 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

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

Categories