Questions

Hi CFers,Anyone know how I can block the user to which the same answer the survey satisfaction only one once?IP address or COOKIE, what is the better way to do?P.S. records in the XML file no DB.Tks,Fabiano Magno Pechibella

We need a user definable spreadsheet for use in our web app. We need to be able to allow the client to set up the spreadsheet, create the calculations, formatting, rounding and decimal places, and then save all to a database.Is there something like this out there for ColdFusion?Thanks.-A-

I am trying to connect to SQL Server 2012 with flag MULTISUBNETFAILOVER=TRUEI have created the DSN and it works fine for some time and next day i will get the below erorr. I have verified the DB server and its up and working fine and able to connect to it from management studio. Once I restart the server the issue get fixed. Does any one had any idea on why this issue is happening. I am using the sqljdbc4.jar for this connection.The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I have a CFC that returns (via ajax) an array with a length anywhere from 1 to n. I need to display the contents of that array on a webpage in a table (one row per array element). Since I do not know the length of the array, what would be the best way to render the table? My first thought was to build the table inside a string variable and then use jQuery's html() method. I also considered using ColdFusion to format the table in the CFC and pass that back to the ajax call. Either way seems very tedious. Was wondering if there is a better way.

Hi fellows,I have a survey of satisfaction and desire that the User meets only once. How can I do this? Can I use cfcookie? More like do?Tks,Fabiano Magno Pechibella

Recently I installed ColdFusion 11 Developer version (on Windows 8 & IIS) to test the migration of a CF9 based website that uses Oracle as its underlying DB. 1 of the first problems I encountered are the PLSQL stored procedures that seem to be very slow, like 10-50 times slower than with CF9. So I did a test where I execute the exact same SQL statement, which returns ~11000 rows, with both cfstoredproc and cfquery. The processing time of the stored procedure is 111645ms while the processing time of the cfquery is 362ms. The query doesn't return any (C)LOBs, per row there are 4 columns returned, 3 having a number, 1 having a varchar2 with a max size of 256 characters. I uninstalled CF11 several times but everytime I get the same results, no matter what I try in the CFIDE. Maybe I'm missing something obvious here, but for now I don't see it...

So as the title says, I can't log into the Administrator and changing the password via Coldfusion10\cfusion\bin\passwordreset.bat doesn't seems to be actually changing the password since I still get "invalid username/password" when I try to log in after resetting the password.Even further, I used the old method of altering neo-security.xml and changed "admin.security.enabled" to false. This DID allow me access to the administrator, but even then, when I enable password protection and reset the password from the administrator, I still am unable to log in!!One detail which may be a clue for solving this problem: when CF was installed, it was set to not use the default "admin" username. When I try to log in though, I try with both "admin" and the custom username with no luck.Any ideas on how to fix this? It seems like the password encryption system is broken and storing the reset password hash wrong or something.... EDIT: Forgot to mention that I restart the service after resetting the pa

Is this possible ?Installation of CF9 32 bits on Win7 64bits ?I did it, with CGI and ISAPI for IIS7.IIS 7 is OK, (http://127.0.0.1  is correct)After CF9 install, I ran the WebServer ConfigurationToolhttp://127.0.0.1 gives an error 500 :then I uninstall C F9 , now I have a 404.2 errorI looked in install recommandation on the web (google).I think I did the right way.Then I am wondering if this is a question of 32bits and 64 bits ?Thanks for urgent Help.(I have an other PC with CF9 32bits on Win7 32bits, it is OKand a CF9 64bits on Windows serveur 2008 64bits, it is OK)Pierre.

How do I determine how many CF licenses I need in a virtual server environment?   Is it determined by the main server or is it based on how many cpu's are allocated to each virtual server?

Hi,Can I use ColdFusion 11 Enterprise license on ColdFusion 10? Do Adobe CF have downgrade privilege option from CF11 to CF10? Thank you.

We have a .Net CMS and have been asked if we can integrate a ColdFusion application into it, does anyone know if that is possible.Thanks,Paul

When I click on "File Search" the search box appears, I enter the search criteria and it finds nothing. I have installed a standalone search product in the meantime but it's a real pain to get out of builder, run the search, and then pull up each file to make changes. Any idea what this problem might be?

To debug I want to see what variables are in the attributes.  I can't figure out the instructions for CFDUMP.  Any help appreciated.

Need the steps to enable SharePoint 2010 Secure Store Service to authenticate single sign on with a ColdFusion 11 app and display the ColdFusion app in a SharePoint webpart.On this page Adobe - ColdFusion Support Center : More DownloadsColdFusion 11 SharePoint Integration WebpartsThe ColdFusion 11 SharePoint Webparts allows ColdFusion applications to be displayed as a webpart in SharePoint.Download Sharepoint Integration Webparts (ZIP, 13 KB)The Readme in the zip file only provides the steps for SharePoint 2007 and 2003.  I'm looking for the steps and needed files for SharePoint 2010 with Secure Store Service since Single Sign On is no longer used. This other page Integrating ColdFusion applications with Microsoft SharePoint using ColdFusion 9 | Adobe Developer Connection is for older SharePoint versions not 2010.Thanks in advance.Doug

I have just decided to set up my site using ColdFusion clustering in the staging environment. I need to find out what code adjustments are required when we move to a cluster environment. I have two machines where Coldfusion server is installed. Till now Steps I followed:On CFServer_1 I have created a instance.(cfinstance_1)On CFServer_2 I have created another instance. (cfinstance_2)On CFServer_1 I have created a Cluster using these two instances.Now on CFServer_1 I have created a IIS site(testsite.com) pointing to my codebase.Now On CFServer_1, Using the Web Configuration Tool I have associated testsite.com with the cluster.Now my question is Do I also need to set up the code base on the second server(CFServer_2), Create a site in IIS with same name(testsite.com) and associate the site with the cfinstance_2?

the university where I work just updated their Oracle test database to a new version and now my clob fields don't display in coldfusion.  I have code to add to the query to capture the first 4000 characters, but what do I do about the few records that contain more than 4000 characters? We need to resolve this before we upgrade the production database...   Have  coldfusion developers addressed this issue with the new Oracle upgrade?

Why does this work?<cfset projectList = Application.Projects.getProjects(CompanyID=request.User.CompanyID)>BUT, this throws an error?(Could not find the ColdFusion component or interface Application.Projects)<cfinvoke component="Application.Projects" method="getProjects" returnvariable="projectList"><cfinvokeargument name="companyID" value="#request.User.CompanyID#"></cfinvoke>I understand that cfinvoke is trying to look for an 'Application' directory, correct?  The Projects.cfc is located within a directory names 'sys'.  Would it be a better idea to use:<cfinvoke component="sys.Projects" method="getProjects" returnvariable="projectList"><cfinvokeargument name="companyID" value="#request.User.CompanyID#"></cfinvoke>Basically, is the above the same as:<cfset projectList = Application.Projects.getProjects(CompanyID=request.User.CompanyID)>

We have switched to using CFWindows for our modal dialogs in our application.  While we have debugging turned on for our IP addresses, and the debugging information shows up just fine on normal pages, nothing appears in cfWindows. Today I went about trying to recreate the debugging information and manually write it out to the window HTML. I began by using the following code in onRequestEnd, which worked fine on pages called normally:<cfset tempFactory = createObject("java", "coldfusion.server.ServiceFactory")><cfset tempCfdebugger = tempFactory.getDebuggingService()><cfset qEvents = tempCfdebugger.getDebugger().getData()>After taking the time to format the output as desired, I finally tried this on a cfWindow. However, I received the following error on the third line of code:Detail  Its possible that a method called on a Java object created by CreateObject returned null.ErrNumber 0Message   Value must be initialized before use.This implies that it'

Hi! I have a tag called #PubsPageLink# that contains an href link, but I want the #title# tag to use that same variable, as well. Obviously, using... <a href='http://#PubsPageLink#'>#title#</a> ...is too simplistic an approach. But what would be an effective way to grab that href variable and apply it to separate tag?#PubsPageLink# is currently setup to output a text link that reads "Read More..." <cftry><CFQUERY NAME="Pubs" datasource="Library" maxRows="4">SELECT citation, title, journalName, PubsPageLink, Year(FROM_UNIXTIME(Pubs.datePublishedConfirmed)) AS DateFROM PubsORDER Pubs.DatePublishedConfirmed DESC</cfquery><cfoutput query="Pubs"><cfif #citation# is not "">                    <strong>#title#</strong> | #PubsPageLink# <em>#journalName#</em> #date#<br><br></cfif></cfoutput><cfcatch></cf

I need to upload multiple files (potentially all images, all PNG) to the server from a mobile device to a CF8 server. Probably as many as 50 small png imagesCould anybody give me some pointers as to the best possible approach to this.ThanksMark

Since this tag is deprecated in CF11, how do I get rid of shading?  I need a solid color bar.  thanks

I need to convert my minutes in my HH:MM record to decimal.For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hoursand if i have 10 hours and 30 minutes I need to return 10.50 hours.How do I do this?

Hi - we've just upgraded from cf8 to cf9 and are getting a fair few of these errors - "Error Executing Database Query. Incorrect string value: '\xE2\x80\x8BWe ...' for column" as we try to insert a row in the db.The query is inserting the following string "We are seeking a" - nothing innocuous in the text and certainly no instance of this string '\xE2\x80\x8B' (despite what the error message says).Has anyone else run into this, any ideas what's going on?Thanks very much for any help you can offer as I'm completely stuck.Thank you.Kind regards,Nick

I have just installed CF11 on our dev and QA servers and am getting a strange issue on only one of them. On our QA server, instead of the calandar control showing up when <cfinput type="datefield"> is used, I get the text "Date Picker". I can't find anything on this on any help forums so I was hoping someone has come across this as I can't seem to figure out the issue. What baffles me is that it works fine on one server with the same CF version. Thanks is advance. 

I'm trying to use CFFTP to retrieve files from a remote FTP site to download to my local directory. I would see the file in the local directory but with 0 kb. Wondering what was going on, I tried accessing just the directory and got an 'Access is Denied' error. The funny thing is that it was working fine a few weeks ago until we made some server changes. We had some FTP sites set up but closed them. Could closing them have anything to do with it? I'm definitely not an expert when it comes to this stuff.We're using CF9 and IIS7 btw. Can someone explain what's causing this and how do I go about fixing it? Any help would be appreicated.<cfftp    action="getFile"    connection="objConnection"    remotefile="s692605.FRTB0001_RES.DAT238710"    localfile="E:\Inetpub\test\s692605.FRTB0001_RES.DAT238710"    stoponerror="yes"    failIfExists="false" passive="yes" timeout="600" transfermode="auto"  /