Solved

CFDocument - Check mark

Posted on 2013-01-14
2
538 Views
Last Modified: 2013-01-15
My database has check boxes in it. When an item is checked in a form, it passes through to the database as a checkbox.
I output some results to a cfdocument and if the field is checked, the number 1 shows up instead of a check mark. An idea how i can get this to show as a checkbox as opposed to the number 1 or 0?
0
Comment
Question by:bcrosby007
2 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 500 total points
ID: 38778494
Find yourself (or make) an image of a box for unchecked and one with a check mark in it.

Then simply

<cfif myquery.itemYN eq 1>
<img src="checked.gif">
<cfelse>
<img src="unchecked.gif">
</cfif>
0
 
LVL 7

Author Closing Comment

by:bcrosby007
ID: 38778672
Perfect. Thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question