Questions
Recently active
How can I change the adobe logo to my company logo on the login page?
1. In my ColdFusion 11 website (with SQL Server 2008 R2), the following cfquery is throwing the above error:<cfquery name="deleteGrantModificationItems" datasource="#dsource#"> DELETE col_key FROM myTable WHERE col_key = <cfqueryPARAM value = "#appkey#" CFSQLType = "CF_SQL_VARCHAR"> </cfquery>2. When I run the sql profiler to capture the query, I get:eclare @7246612 int et @7246612=NULL exec sp_prepexec @7246612 output,N'@P1 varchar(8000)',N'DELETE col_key FROM myTable WHERE col_key = @7246612 ','000000001644' select @72466123. when I run the above in the Query Analyzer, I get the following error:Msg 208, Level 16, State 1, Line 1Invalid object name 'col_key'.Msg 8180, Level 16, State 1, Procedure sp_prepexec, Line 1Statement(s) could not be prepared.What could be the issue? Please help.
Hi,We have code that is creating an excel workbook with the POI library and then using CFHeader to set the filename with content-disposition as shown in the code below. After setting the content-disposition,we write the Excel workbook to the browser. The code is below. This works wonderfully in CF 9 but when we upgraded to CF 11 we found that this is no longer working. The same code works fine in CF 9 but not in CF 11. The filename is being ignored and the file is now being given the name of the cfm script being called with the correct xls extension.Any suggestions as to what is causing this in CF 11 and not in CF 9 would be appreciated.Code:<cfheader name="Content-Disposition" value='attachment; filename="#arguments.fileName#" ' > <cfscript> // Write the workbook to the ByteArrayOutputStream to obtain the ContentLength local.workBook.write(loc
Currently getting the following error. The START_DATE argument passed to the insertApplication function is not of type date.If the component name is specified as a type of this argument, it is possible that either a definition file for the component cannot be found or is not accessible.The error occurred in D:/web-sites/Web/poolDischarge/components/poolDischarge.cfc: line 5452 : <cfargument name="Mailing_State" type="string" default="#arguments.discharge_state#">53 : <cfargument name="Mailing_Zip" type="string" default="#arguments.discharge_zip#">54 : <cfargument name="Pro_Discharge" type="boolean" default="0" required="yes">55 : <cfargument name="Maintenance_Company_ID" type="numeric" required="yes">56 : <cfargument name="Start_Date" type="date" required="yes">Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser Mozilla/5.0 (Windo
Anyone use this feature on coldfusion administrator yet? I tried to follow the following link Database-related enhancements in ColdFusion 10 - ColdFusion, English documentation - Adobe Learning Resourcesbut I have no luck getting it to work with Microsoft Sql Server 2008 R2
I couldn't figure out why I got this error. I have set default var query. Please help. If qLocal has records then return fine, but when qLocal records is empty will throw errors. I've set a default.<cffunction name="getName" access="public" returnType="query" output="false" hint="This method returns a query."> <cfargument name="id_fk" required="no" default="0"> <cfargument name="id2_fk" required="no" default="0"> <cfset var qQuery = ""> <cfquery name="qLocal" datasource="#db#"> SELECT * FROM tbl WHERE id = <cfqueryPARAM value ="#id_fk#" CFSQLType ="CF_SQL_INTEGER"> AND id2 = <cfqueryPARAM value ="#id_fk2#" CFSQLType ="CF_SQL_INTEGER"> </cfquery> <cfif qLocal.recordcount> &
Hi,Noticed that there is JQuery modules in the directories with Cold Fusion 11.In the URL "http://stackoverflow.com/questions/15756532/use-jquery-datepicker" shows using JQuery local for the date picker on the server. But it show a module datepicker.css.I cannot find the module.Does JQuery need to be downloaded in order to obtain all the modules for the datepicker?Thanks,Mike
It was working earlier today and then stopped working after I had to restart the CF service. It is completely inaccessible. Running:Server DetailsServer ProductColdFusionVersion10,0,12,286680Error:The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in scheduletasks.cfm: line 188I've searched around and can't figure how to correct the issue. Any assistance would be greatly appreciated.
What is the maximum memory that could be allocated for JVM heap size for a CF10 instance and what should be the minimum.
I am unable to get the Cold Fusion 11 custom tag example for directory lists to work.It compiles in Visual Studio 2013 Community [Release, x64].But when I try to run it on my server [Windows 2008 R2 64 bit], I get "Unable to load library"I have other tags in the same subdirectory that work so I don't THINK I have a permissions issue - but I'm not POSITIVE here.Since it's one of Adobe's examples I don't think I have a C++ issue.The logs aren't helpful - they tell me the library didn't load but they don't say WHY.What's my next step?
Note: I thought I put this on the Builder section but 1) can't find. 2) there seems to be no activity there.I have added CF Builder 3 to my Win 7 platform and I find it really hard to configure to my way of doing hand coding.Something as simple as right clicking a cf tag to edit tag is not available that I can find and the tabs at the top for selecting different types of functions is replaced by one bar.This is my Homesite window and it works great for me.Can anyone give me some help in getting Builder 3 to replicate this or something as easy to use.Thank you in advance.
Hello, all,Is there a way to pass session variables from a parent .cfm to an iFrame .cfm when J2EE is enabled in CFAdmin?V/r,^_^
I thought someone from Adobe reviewed comments to the documentation before allowing them to be published?ColdFusion 10 Documentation - ColdFusion, English documentation - Adobe Learning Resources
After migration from CF8 to CF11, my users cannot save the application and continue at later time. The application still work fine under CF8. The application uses the registry to store the values. I have Pool Discharge Permit ApplicationYour application has been saved. Click here to continue your application now.To return to your application at a later time, simply re-visit the Pool Discharge Permit link you used to get to this application. Or you can add this page to your "Favorites" list.(Please note: returning to a saved application only works if you are on the same computer.)You can also print your application in its current state for mailing or faxing. Click here to print. Thanks
"Error validating html input.Invalid HTML input. Error=The input was too large. The specified input was 5,040 bytes and the maximum is 5,000 bytes.I don't see a setting to change this in the CF admin? Please advise.
I am trying to figure out how to get json data that is coming from an iframe response into a coldfusion parameter or structure that I can use. The iframe is within a form and when submitted it executes the doMonerisSubmit function in the javascript. Below is the javascript which returns the information but I need to get it into CF. If it was using a cfhttp post I could do it, but I'm at a loss as to how to capture it when it's being executed in this javascript. I've been working on this off and on for the past month and I'm no closer to a solution now than I was a month ago. Any insight would be appreciated.Thanks.<script>function doMonerisSubmit(){var monFrameRef = document.getElementById('monerisFrame').contentWindow;monFrameRef.postMessage('','https://esqa.moneris.com/HPPtoken/index.php');return false;}var respMsg = function(e){var respData = eval("(" + e.data + ")");document.getElementById("monerisResponse").innerHTML = e.origin + " SENT " + " -
Bought CF - am trying to open CFM files I already have in their original format. So far, no luck. All I get when I mport/open files is plain text, like it was created in Notepad. All formatting's gone. The complexity of the original formatting makes it far too time consuming to attempt recreating it. If CF is the wrong program (so much for the sales pitch) any ideas on which program will help me to open existing .cfm files so they appear the way they should? Any ideas, hints, help?Thanks in advance for any assist on this.
HiThis is the portion of code <a href="linuxpath/filename.doc">filename.doc</a>when I click on filename.doc its asking the option to save in mozilla but in IE its directly opening in browser in bad format .The same code is working fine in CF9 , we just installed CF11 in new Linux env and facing this issue Can anyone help on this please Thanks Amar
Similar to Java Webservices and SOAP - Changing an element name, I have the same question, except I am trying to change the name of the soapresponse of my cfc method. It seems by default cf9 concatenates the function name with the word return. Is there a way I can have a choice of the naming? I've tried customising the wsdl file but nothing works.
I am new to coldfsion.I have some doubt in building coldfusion code with ant script to generate a war file<target name="war" > <echo message="Creating WAR file ..." /> <war destfile="${distrib.dir}/${warFileName}" webxml="./WEB-INF/web.xml"> <fileset dir="./src" /> <fileset dir="./build/src"> <include name="**/*.jar"/> </fileset> <fileset dir="${distrib.dir}/configfiles"/> </war> <echo message="WAR file created." /> </target>I generated the war file and unzipped the war file and seen that code is just copied in war as like tar file. .Is generated war file right ?Is any other way to generate war file for coldfusion code ?Please help me on this.
Hello everyone, I'm trying to read CSV file and output with ColdFusion. I store all records in array and I have to pull out just first and last column with all records. My current code gives me just a row with all columns. Can anyone help with this please? Here is my code:<cffile action="read" file="#ExpandPath('Status.csv')#" variable="myfile"><cfset myarray = ListToArray(myfile,chr(13))><cfset cnt = ArrayLen(myarray)><cfloop index="index" array="#myarray#"> <cfoutput> #index# <br/></cfoutput></cfloop>
I have a report that I create with Coldfusion, that includes a number of CFChart objects. I recently installed a new SSL certificate, and now all the charts show up as broken links. It shows up fine if I try and display this as HTML. On the chance it was something weird about my (lengthly) report, I created the following sample code that I saved in a file called foo.cfm:<cfset sDir = "C:/"><cfset filename = "foo123.pdf"> <cfdocument format="pdf" filename="#filename#" overwrite="yes" marginleft=".7" margintop=".3" backgroundvisible="yes">TEST 12345 <br><br> <div style="height:500px;float:right; margin-left:10px; margin-top:10px; margin-right:10px; margin-bottom:10px;"> <cfchart format="png" chartwidth="400" chartheight="360" showborder="n
Hello everyone,I'm working on my project and I have a problem looping through my array. As many of you know arrays in coldfusion start at position 1, inmy case if I put that my cfloop starts from 1 I'm getting an error because that does not match my array. Here is my sample of code:<cfloop index="i" from="i-1" to=#(cnt)# step="1"> <cfset myrow = #replace(myarray,chr(10),'')#> <cfset myrow = ListToArray(myrow,",",true)><cfoutput> (#myrow[1]#), (#myrow[2]#) <br/></cfoutoput></cfloop>Does anyone know how I can fix this problem? I tried to use array in my loop but I got another error with that option.Thanks in advance for any advise.
I am new to CFB and am struggling to get it set up to work with virtual hosts on my local development server.Here's the setup;Windows XPApache 2.2 (using virtual hosts)CF 11RDS enabledCF Builder 3I can get CFB working with RDS, Debugging, etc when I disable virtual hosts. However, as soon as I try to use it with virtual hosts I cannot get RDS and debugging to work.Below are screen captures of my CFB server setup.
Hi everyone. I have a select box with part numbers that you choose first, and depending on which part number you choose, some input boxes display to enter measurements into. Then you click Submit and it outputs the info. into a table that has some calculations it does first. This works just fine if I use just one input box for each part number. It even works when I have 2 input boxes. If I go through and do everything the first time, it works just fine. The problem is when I try to choose a different part number, I get an error. It's saying that "" can't be converted to a number on my X value. I'm assuming it would say the Y Value too if it would get that far. Does anyone know why this is happening or how to fix this? Here's my code:<cfif NOT isDefined("form.submit")><cfif isDefined('form.PartNumber')><cfset page.select_Part = form.PartNumber></cfif><cfif isDefined('form.X')><cfset page.select_X = form.X></cfif><cfif isDefined('form.Y')>&
Remix with Firefly Community Gallery
Thousands of free creations to fall in love with and remix in Firefly.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.