May 13th, 2013, 09:08 AM
[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.
OEINVH.`CUSTOMER`, OEINVH.`BILNAME`, OEINVH.`TERRITORY`, OEINVH.`INVFISCYR`, OEINVH.`INVFISCPER`, OEINVH.`INVNETWTX`
OEINVH.`LOCATION` IN (`30`,`31`,`32`)
May 13th, 2013, 10:51 AM
Re: SQL Help
Never mind; figured it out. Thanks anyway
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!