ColdFusion Forum

So this is the code I am using... <cfform name="badassForm" method="post" action="saveBadassForm.cfm" id="badassForm"> <cftextarea name="txtMessage" height="800" width="600" richtext="yes" value="#myText#"></cftextarea> </cfform> I am trying to use the cftextarea with the rich text editor on my site but it is not the root folder of the...

I have a problem where the Approved value (SQL) has a 1,0 or NULL value. I can not figure out how to show the null value when returned for the filtered input. <cfset vApproved = 0> <cfif isDefined("form.cboApproved")> <cfif form.cboApproved eq ""> <cfset vApproved = 0> <cfelse> <cfset vApproved = #form.cboApproved#> </cfif>

So I have a form that has an array passed in. When generating the online form, I loop through the array and create the same text boxes for each value in the array. So my text boxes (relating to landscaping) have names like mow1 for the first array value, mow2 for the second, etc. When I submit the form I need to loop through the form fields in...

Hi there, Realise that this might not be a CF answer to a CF question, but does anyone know of any script that will paginate th eoutput of a CF query? I have CF displaying notes added to a item. Rather than display them down the page in a table I'd like to show just one note with forward and backward links to the next note from the queryset...

I'm supporting a web site (6 web servers and 2 DB servers) that's using ColdFusion MX Version: 6,1,0,83762. We have logging set up where we get email notification of errors. We have gotten 90 of these errors, since Oct. 2007, about undefined form elements, but they are clearly defined on the page. There are 10 different pages that this error...

Hello, This is going to sound strange but I have a webpage that displays a form showing the last record added. This is because further records share a lot of the same data, so only a few fields have to be changed. I use the max(ID) to do this: <cfquery name="lastid" datasource="swwdrawings"> select * from tblDrawingsData where ID =...

Hi, This is driving me mad - can someone guide me in the right direction please? I am outputting the results of a query to a webpage - in this case drawings in a database. The user selects the drawing type and the result pages shows the details. I have pumped the output into a form and have generated a checkbox for each returned row. I...

Hi, I have a CF query that extracts all the information from a db and sprays in into a table. I'd like a drop down list box that can filter this data based on the value in the box. IE at loading it shows 'All' jobs, but when changed to 'Completed' it just shows Completed jobs. I'd like to use the onChange event to trigger this. What's the...

Hi All, I am trying to figure out coldfusion. I previously used php mysql website development, but my friend decided to use the coldfusion setup and now is needing help. Now I keep getting the error "Error: Element Undefined in Form". <cfquery name="auto" datasource="mysqlcf_auto" dbname="auto" username="auto" password="pswd1"> INSERT...

I want to call a javascript function if my cfif logic is True. How do I call the javascript function? I just want to have a popup alert saying that the choice already exists, and then send the user back to the main page. <cfif isDefined("Form.Add")> <cfquery name="validateName" datasource="Security_Access" dbtype="ODBC"> select sysID...

Hi there, Simple question: how do I create CF charts without using CFCHART? My company uses CF4 which doesn't have this function, and they have no plans to upgrade! Thanks Neil

How to Upload a File in Coldfusion Use the cffile tag for uploading files to the server. Note that allowing people to upload files is fraught with danger and only trusted users should be allowed to upload files. Checks should be made to make sure that only allowed file types are uploaded. The Client-Side First of all, let us deal with...

I have a textbox and a submit button in coldfusion page. user can enter multiple comma separated values in the textbox. on click of the button, i want to print only the strings from the textbox ignoring the delimiter comma or spaces. how should i do it? is there any function in coldfusion for that? i want to avoid javascript.. have to use...

Hello everyone, i am facing a problem with multiple checkbox. I have set few checkbox as a selection, then send to database for search result. For example the checkbox including hotel features like, aircont, 24 hour reception, swiming pool etc. after tick the check box , will send to result page to get the Hotel match with the selection...

Hi, I've created a form that allows the user to upload an attachment. I can save the attachment with <cffile> and create a directory (if none exists) with <cfdirectory>. However, I want to save the absolute filepath to a database field so I can use it as a hyperlink later. I've tried to concatenate the directory path with a trimmed...

Hi there, I'm looping through a query and displaying the results in a table. One of the fields is a filepath shown as a hyperlink. I'd like to have an cfif statement that only shows the link if the file exists, but I can't get the code to work - it's not finding the file. Should point out I`m storing the path absolutely - ie...

Hi, Not sure if this is doable in CF, but is it possible to combine a text and select box - ie so the user can type in text if it's not in the drop down, then add that value back into the list? Thanks Neil

Hi, I've been mulling it over but I can't get my head around how to achieve the following: I have a page that displays jobs for a user. I'd like a checkbox which, when checked, removes jobs with the status of 'Completed', stays checked on the refresh of the page and then adds the Completed jobs when unchecked. Is this doable? I've tried...

Hi, I have a table in a db that stores a users skillset. There are 3 columns: the users name, the skillset (eg Access) and their proficiency ('Beginner' etc). Currently I'm storing these as a separate line, so with 10 skillsets each user will have ten rows. But that means i have to create 10 select boxes for them to choose their...

Hi, I'm outputting the results of a query to generate some select boxes. The query runs through a list of skills to generate the boxes. Inside this I`m looping through another query to show a choice of skill levels: <cftransaction> <cfquery datasource="taskbook" name="getSkills"> select LoginNameFK, SkillType, SkillLevel

I have a coldfusion web app that allows an admin to create pdf's from an sql query by clicking a link in a cfgrid. There are 3 admins with three different levels of access. My inclination for a solution is to have a pdf created check box in my cfgrid that checks the db to see if the pdf has been created. I would then have another checkbox in...

Hi, I have some data I need to total by Month. i can create a query to do this for a particular month: <cfset vStart=createDate(year(Now()), 3, 1)> <cfset vEnd=createDate(year(Now()), 3, 31)> <cfquery name="getSum">

On a listing page, I'm trying to display Charts thumbnails and Thumb picture if there's one available. So I need an CFIF statement similar to this: If there's a thumb, show it, otherwise show chart. Here's what I got so far: <cfif Len(Trim(ImageThumb))> <div style="float:left; "> <a href="#itemLink#" #sTarget#...

Hi i am strugling to get mt call to a SOAP web service running on websydian server. i can run the web service using SOAPUI here is my raw XML: POST http://172.26.1.37:10010/p6dev/service/basicsite/services/soap HTTP/1.1 Accept-Encoding: gzip,deflate Content-Type: text/xml;charset=UTF-8 SOAPAction: "CustomerSpecificRequest" User-Agent:...

Hello I have a table that looks like this: <td><div align="center"><strong><cfset dtDiff = (qsearch.ReceiptDate - qsearch.LAST_SOLD) /> #DateDiff( "yyyy", "12/30/1899", dtDiff )# Years, #DateFormat( dtDiff, "m" )# Months, #DateFormat( dtDiff, "d" )# Days, </strong></div></td> Which returns: -2 Years, 3 Months, 8 Days