ColdFusion Forum

I'm trying to copy a file which is located on my C drive over to a network path. I'm getting the error below when trying to perform the copy. The file C:\query.sql does exist on my C drive so I'm curious as to why it can't reference it. Is it looking at the web server's C drive instead?? An exception occurred when performing a file...

I want to validate this two checkbox variables on an action page and also an update page <cfinput type="checkbox" name="gender"checked> </label></td> <td>Female</td> <td><label> <cfinput type="checkbox" name="gender"> </label></td><cfinput type="checkbox" name="gender"checked> </label></td> ...

I'm trying to retrieve the username of the user logged into a machine when a person visits my page on our intranet. I've looked over cfntauthenticate but that's not going to do what I need it to do. Is this even possible with coldfusion or should I be looking to asp?

Hi all! How can I update only selected records from recordset at once? We have a form page form.cfm and processing page update.cfm. In form page there is a list of rows generated with <cfoutput query>. Each row contain checkbox, textfield1, textfield2. Processing page has a query procedure. I tried cfloop, but always got an error: If checkbox...

While developing my website I notice that sometimes when there is an error in my database the error page shows my connection string with the username and password for my database. Just wondering what the proper way is to prevent this from happening.

I'm having an issue with quotes and double quotes on my iif statement. I'm trying to call a javascript function but can't seem to get the syntax correct. I know it's failing because I have this setup: <a href="javascript:alert('hi');">. I don't know how I can setup the quotes in order to get this working properly. It could just be friday, but...

I'm using Coldfusion MX7, but I don't see an Oracle datasource in my coldfusion administrator. I've looked around trying to figure out how to get an Oracle datasource loaded so I can query Oracle db's, but can't find any info on how to get this working. Does anyone know how to do this or point me in the right direction??

I recently switched over to a new hosting company and my update query doesn't work. Any ideas on what I can change to make this work? I changed it a ton of times but it would not save the file name from my form into my mysql database. UPDATE tblCust Set item1 = '#cffile.ServerFile#' where tblCust.CustID = #Session.CustId#

I have some text fields in my database, and I'm displaying them on the screen, but no matter what type of element I nest the output in, the text is being displayed on one huge line. How can I get this to display in an element in a multi-line format??

How can the Application.cfm files within the ColdFusion MX v7 CFIDE folder be recreated without disturbing live sites on the same server? Will CF need to be reinstalled? Is there a repair utility? Are the files unique for each installation? A .vbs file was run on the server which added lines of CF code (intended to protect against SQL injection...

Hello, I've been working on trying to figure out how to script something where if a user enters more then one search term in the same fieldbox, it would query both of them and output it to a cf page. My scripting/issue is very similiar to an early thread by an individual here http://bytes.com/forum/thread655581.html Basically in my...

how can i read excel data and import into sql using cfm??? I have a CFM form for user to import excel file into database and save file in the folder at server location. I would like to read that excel file and import data into sql database each time the user upload the file and create new record. Any idea how to solve this problem, every...

Hi, I created a chart using cfchart and export it to excel. However, the chart exported cannot be displayed. This problem does not happen when i convert it to PDF. Please help.

I have a query that I was using cfcontent and cfheader to output to an excel file. I think that cfreport can do that but i don't get it. Does it require reports to be created though the Report Builder? Of not, will this work? <cfreport format="Excel" query="Request.qProjects" name="projectResults" filename="ProjectQueryResults"> And if it...

Hi Guys, I need to make a pin like ADD - 00001 through ADD - 99999. I used the ID colomn in the table to generate this number like below: <cfset #Pin# = #RIGHT('ADD - 0000'& #MyQuery.id#,13)#> Now I have problem replacing the 0000 with numbers without loosing the 5 digit format. for example if the id value is 29 my pin should be ADD -...

Hi, I've been trying to implement a more OOP oriented approach to dealing with user security on one of my websites, and I am trying to validate the user against an array of roles, however I am struggling with a type error: The argument ROLES passed to function setRoles() is not of type array. If the component name is specified as a type...

The delima was I had a list of numbers that I needed to find the maximum value of. Simply doing Max(ListName) did not work because the Max function requires only two parameters. What I ended up doing to get around this was converting my list to an array and doing the ArrayMax function <cfset myList = "1,3,1,2,5,2,2,3,2,3,4"> <cfset maxNum...

Hi, I'm having trouble fully implementing the edit section of a contact admin system, so far I have written the following: - Bean (Contact.cfc) - Data Access object (ContactDAO.cfc) - Gateway (ContactGateway.cfc) - index.cfm - Deals with the business logic - display/form.cfm - Produces the form for both add and edit behaviour

I have created a coldfusion for www.lfcsb.co.uk/Form.cfm using this tutorial http://www.fordwebs.com/cfform.cfm. However, as you will see if you navigate to my page, there are no input boxes. Could someone help me please, Stephen if you need to see some code, for the surname section, this is the code: <tr> <td align="right"><span...

Hey Guys, I have just started working on ColdFusion, so I am relatively new to it than most of you may be. I am trying to create 'Sticky Stay-Filled' forms so that when the form is submitted, the details entered on the form show up on the page following the submit. Just FYI, the form is submitted to itself. I have done this in PHP almost a...

I am running a website at GoDaddy where I have their least expensive plan that supports Linux/ColdFusion/mySQL. Apparently this plan supports a small number of active database connections (50). I wrote my ColdFusion code in Dreamweaver and just assumed it would take care of issues like this, but I guess it doesn't. If I have a few windows open...

Hi, I'm writing a contacts section for a cms on a website, I've decided to write the section in OO code. So far I have my Contacts object and a page structure I would use for a procedural site. /com/Contacts.cfc <cfcomponent displayname="Contact" output="false" hint="Contact component"> <!--- properties: used for self-documentation...

Hi Community, i have a problem. I want to know the original sender, when I forward a message via Outlook. Example: Person A sends a message to person B. Person B forwards the message to person C. Person C gets the message via cfpop and wants to know the original sender (person A). I tried it with queryname.header but I only see person B...

what i have to do is make sure that they only select a certain amount of items i have looked everywhere but it must be a simple thing that i cannot think of please any help would be great!! so i think that all i need to do is track the number that is selected when they click submit but i cannot find the answer please help me. ...

Hello, I'm doing something wrong here, and it's driving me nuts. A very strange thing is happening with a query that populates an XML export function. 1. I have a query and its XML export routine sitting in a file. That file, in turn, is called by a "New Spry dataset" block in a file that my form points to. 2. When I set up the...