Thank you for your responses. Rudy's suggestion worked perfectly! I simply inserted that small bit of code into my huge select on the real app, and it works perfectly!
I need to turn this SQL statement into CF syntax:
if :dr_dr_flag='D' then return (:amount*(-1)); else return (:amount); end if
The code that follows is from a simple test page with just enough code to test this.
My query:
<cfquery name="rsDocid" datasource="cgofprod">...
This is exactly what I have been trying to do - except I need to take it a bit further... I need to give the user the ability to enter the parameter they want to query by, then send the results of that query to excel.
What I REALLY would like to do is: have a list menu, with the options of...
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.