ColdFusion Forum

This page will link to a number of tutorials. Coldfusion Language Coldfusion Variables Using Coldfusion Variables Coldfusion Image Gallery How to upload a file in Coldfusion Watch this space...

Hi, I have a query which updates the projects table of my database, however when I try to run my query with blank values i get the following error: Data truncation: Data truncated for column 'date' at row 1 I have done some researching and I believe the problem is to do with the data that is being sent by my cfqueryparam function. Here...

Hey Everyone, Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place. what i am trying to display previously entered multiple fields. I am able to get my serial fields to display correctly, but i can not display my...

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

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

Hello, I am trying to autosubmit a hidden form. So far I have...... but it sends me into an infinite loop. Anyone got any ideas. I am such a noob... <form method="post" name="form1" action="<cfoutput>#CurrentPage#</cfoutput>">

can anybody tell me what is coldfusion

Hey Everyone, Well i don't know if my question should be in javascript/ajax or coldfusion, i figure this is more of a coldfusion question. But if this is in the wrong section let me know an all gladly delete my question an put it in the correct section. Well what i am trying to do is pretty simple. I have a input field and someone starts...

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

my code is: addRecord.cfm <cfinclude template="head.cfm"> <p> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0"> <tr> <td> <div align="center">

need to import Excel data into Mysql database using coldfusion script. How can i do it. Is there any utility or any script can do it. Thanks in advance.

Hey Everyone, Well i am having a problem outputting for my report and hoping someone can explain what i am doing wrong. What the report is about is comparing my company's part price's to d and h, synnex and techdata. What i was told to do was take are part numbers and combine them with d and h, synnex and techdata to display only one column...

Hi, How do I insert a null or blank field into a database using coldfusion? I'm new to CF and its proviing a bit tricky! My database date field accepts null values (I think - theres no default value or validation rule). The input box on the form is this: <input type="text" name="QuotePDate" maxlength="10" size="12" /> and is handled...

Hey Everyone, Well for the last few days i been trying to figure out how to delete attachments and download attachments to my computer. The deleting is sort of working and i don't know where to begin on downloading. Right now with the deleting it will delete from the attachments folder on the server but it does not delete from the database an...

I was under the impression that the Now() function retrieved the date/time from the server running coldfusion, but that doesn't seem to be the case. Ever since the time change my server shows for example: 1:40pm but when I look at the output of the Now() function I'm getting 12:40pm. Any ideas on how to fix this?

So, how do I count the number of days between two dates? I have set my variables to carry dates: <cfset dtFrom = #CreateODBCDate(dateFormat(form.Pump_FromDate, 'dd/mm/yyyy'))# /> <cfset dtTo = #CreateODBCDate(dateFormat(form.Pump_ToDate, 'dd/mm/yyyy'))# /> <cfset dtDiff = (dtTo - dtFrom) /> But can't output the number of days between...

what can be the problem? Since i tried to write this values like: <cfset totResponse = #GETTOTSCORE1.a# + #GETTOTSCORE2.b# + #GETTOTSCORE3.c#> <cfset avg = #GetSum1.score1# + #GetSum2.score2# + #GetSum3.score3#> <cfset totAVG = avg / #totResponse#> first calculation to calculate total response and I got error in value...

<cfif (Attributes.icq NEQ "") AND IsNumeric (Attributes.icq) AND IsValid("integer", Attributes.icq)> <cfset Variables.oStudentProfile.icq = Attributes.icq /> <cfelse> <cfset temp = Request.oClientError.setError("icq", "Your ICQ must consist of numbers only.") /> </cfif> Ok, so if the student enters something in this field I want...

need logic so when the page is refreshed that it returns to the location of the change, not to the top of the page. Currently, when the page is refreshed, it takes you back to the beginning of thepage, not the area you may be working on. What we need the page to do is when enter or tab is pressed and the page refreshes, take you back to the...

how to repalce “ this character in coldfusion <cfscript> str_fnvalue = replace(str_fnvalue," “ ","&ldquo;","all"); str_fnvalue = replace(str_fnvalue,"”","&rdquo;","all"); <cfscript> I put the cose like this but not working correctly.i tried to replace it with a word but..it not double quots...it is "&ldquo" "&rdquo;"

I need to retrieve some data from an xml document using a web server, it's not working so I took out everything that was not necessary and put everything back line by line until I hit the problem, I found out which line was causing the problem and so I've created a cfm to test it and it gets the error " Content is not allowed in prolog." Here's...

I would like to learn ColdFusion and would like to know about the best way to do that, any suggestions? John D

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

Hey Everyone, Well this is my first time asking a question on here so please forgive me if i post my question in the wrong section. What i am trying to do is upload multiple files like gmail does. I found a script that does this on easycfm.com (Topic 13543). But anyway when i try to upload multiple files it will create multiple records...

I had the following code that would create a javascript confirmation page. This code lived inside a form which wouldn't submit until the user clicked the Ok button. <input type="image" onclick="return confirm('You will not be able to change your answers if you submit now.\nAre you sure you want to submit this test?');" name="SubmitTestButton"...

hi i need a code for importng a csv file intoa sql in coldfusion