ColdFusion Forum

Hello, I recently moved my scripts over to a server running Coldfusion MX instead of 5. Now the scripting I'm using to upload a file doesn't work. I've checked it and it all looks okay - any ideas why it isn't working? The path quoted by the CF variable is an absolute one: //marlin/assetinl/scripts/TaskBank/Docstore

I get this error while using the cfspreadsheet. I do not get the error in the development environment but I get it in the staging environment. The error -- "coldfusion.excel.ExcelProcessException: An exception occurred while using action=write."

I am trying to show a category, for example shoes and then show all the shoes in that category and then show the next category and all the products in that category and so on. I am able to show all the products but the category part I can't think of how to do. I have this so far displaying the products: <CFLOOP QUERY="Prods"...

Hello I'm trying to make a sertain radio button the default. How would I get about doing this? Here is my coding so far: <td> Edit&nbsp;<input type="radio" name="Ptype" value="Edit"<cfif #Session.PType# IS "Edit">CHECKED</cfif> onClick="this.form.submit();">&nbsp;&nbsp;&nbsp;Print&nbsp;<input type="radio" name="Ptype" value="Print"<cfif...

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

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:...

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 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">

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'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

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'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, 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 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, 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...

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...

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...

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...

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

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 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...

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, 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...

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 =...

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...