Post the exact query code you're running through CFMX... because its a "complex" query, you're likely using a variable in the where statement somewhere... Maybe you're assuming the variable to be one thing and it isn't..
And yes, I've had CFMX not return anything or error completely when the exact same where works in SQL..
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.