Use a
That 'attachment' setting should force the browser to give the user the Open /
Save dialog.
>Works a treat thank you - but now I have a new issue if anyone can help
>please. The CSV file opens in the browser rather than comes up for download
>- I suspect this is a browser issue rather t
...@acoderslife.com]
Sent: Saturday, March 19, 2011 7:04 AM
To: cf-talk
Subject: RE: Converting Boolean in the query
IIF() is not a sql function, it is a CF function. You will need something
like this instead...
Select case when myBitFiled=1 then 'Yes' else 'No' end as my
al Message-
From: Kevin Parker [mailto:tras...@internode.on.net]
Sent: Saturday, March 19, 2011 1:19 AM
To: cf-talk
Subject: Converting Boolean in the query
Appreciate a little bit of advice please.
I am creating a small bit of script to dump some data to a csv file. I want
to convert a Boole
: webmas...@advancedimaging.com.au
w: www.advancedimaging.com.au
m: 0418 815 527
++
http://au.linkedin.com/in/krparker
-Original Message-
From: Kym Kovan [mailto:dev-li...@mbcomms.net.au]
Sent: Saturday, 19 March 2011 16:42
To: cf-talk
Subject: Re: Converting Boolean in the query
2nd go with all of the info this time :-)
the YesNoFormat() function is the go on the cfml side outside the query
if you can do that rather than inside the SQL
Inside SQL you need a CASE as there is no IIF, this explains nicely:
http://www.sql-server-performance.com/faq/iif_tsql_p1.aspx
Kym
the YesNoFormat() function is the go on the cfml side outside the query
if you can do that rather than inside the SQL
Kym K
On 19/03/2011 16:18, Kevin Parker wrote:
>
> Appreciate a little bit of advice please.
>
> I am creating a small bit of script to dump some data to a csv file. I want
> t
Appreciate a little bit of advice please.
I am creating a small bit of script to dump some data to a csv file. I want
to convert a Boolean field to a Yes or No inside the query.
I've used this technique in my SELECT statement from scouring the net.
IIF(PractitionerNews, 'YES', 'NO') AS MyConver
7 matches
Mail list logo
