Questions

Hi,i am uisng CF7 and develope the page with  have cfmail send the url to customer but i don't want them to see the ID from the link.  Is there the way to hash, encode, decode for not letting them see an ID but when they click on the link, the ID will propertly decode and retireve the record from the table?thankskt

Hi,I want pass a variable for number part in Dateadd() funtion instead of hardcoding it.Eg:<cfset var a = 180>now i want to pass this value of a into "number" part of dateadd function.DateAdd("d", number, now())How can be this done..?

<cfstoredproc datasource="MyDSN" procedure = "MySP">     <cfprocparam value = "1" CFSQLTYPE = "cf_sql_numeric">   </cfstoredproc>for my report query using a stored procedure need parameter.I got Variable REPORTQUERY is undefined.I notice that the default name for query report is ReportQuery, but CFSTOREDPROC  doex not have name property.I am not sure how I can assign the variable using a stored procedure.Your help and information is great appreciated,Regards,Iccsi,

I use CFQUERY to run a query in my cfr file which created by Report Builder.I tried to use CFSET and CFOUTPUT to assign a label caption from CFQUERY.It seems does not work,Can any on advise me how to set a label caption from a query data source?Your help and information is great appreciated,Regards,Souris,

I got following error message   The CFML compiler was processing:  A cfprocparam tag beginning on line 275, column 7.  A cfprocparam tag beginning on line 275, column 7.when I have  followignn code query for my report.<cfstoredproc datasource="MyDSN" procedure = "MySP">     <cfprocparam value = "#ReportQuery.MyID#", CFSQLTYPE = "cf_sql_numeric">   </cfstoredproc>I tried to create a report query using a stored procedure and pass parameter.I would like to know is it correct way to do it or I am on the wrong track.Your help and information is great appreciated,Regards,Iccsi

I have a stored procedure from MS SQL backend and the result heading is WeekResult1, WeekResult2, WeekResult3... etc until Week20Result for report datasource.I would like to assign the heading at run time to May/01/2013, May/08/2013, May/15/2013 ... etc base on user enter date range.I have folloing code on report before export event<cfstoredProcdatatsource = "MySource"procedure = "MyColumnHeading"<cfprocparam    cfsqltype="cf_sql_date"    value="#StartDate#"><cfprocparam    cfsqltype="cf_sql_date"    value="#EndDate#"><cfprocparam    cfsqltype="cf_sql_date"    value="#StartDate#"><cfprocparam    cfsqltype="cf_sql_numeric"    value="#DateDiff#"><cfprocparam    cfsqltype="cf_sql_numeric"    value="#DateDiffType#">>I would like to know how can  I assign my 20 columns heading record by record from stor

I use ColdFuiosn and MS SQL server.I use a stored porcedure for my report using advance on query builder like following.<cfquery name="ReportQuery" datasource="myDataSource">execute MyStoredProcedure MyParam1, MyParam2</cfquery>I got ColdFusion Report Designer is unable automatically to retrieve  meta data for the report fields.Can you please advice how can I manually to get field information to drop on the report designer?Your help and information is great appreciated,Regards,Iccsi

I would like to use user input as CFQUERYPARAM for example,I have txtMyID on the form and would like to use user input as my query parameter.I tried to use   <cfqueryparam value = "#trim(form.txtMyID)#" CFSQLTYPE = "cf_sql_integer">  but does not work,  I tried the following which works, but I need get the value from user enter.  <CFSET MyID = "1">  <cfqueryparam value = "#MyID#" CFSQLTYPE = "cf_sql_integer">Your help and information is great appreciated,Regards,Iccsi

Hi, The second dropbox is displayed when location eq 5 is selected from the first drop box.  When i select the value from second dropbox, i want the value from the first drop box stays the same as location eq 5, and results need to refreseh to reflect with the select from the second box.  Can you pls help?- thx<cfoutput><cfform name="myform" action="" method="post">Location:<select name="location" onchange="this.form.submit();"><cfloop query="variables.qlocations" ><option value="#id#" <cfif isDefined('form.location')><cfif form.location eq "#id#">selected</cfif></cfif>>#location#</option></cfloop></select><cfif form.location eq 5><select name="action" onchange="this.form.submit();"><cfloop query="variables.qAction" ><option value="#id#" <cfif isDefined('form.action')><cfif form.action eq "#id#">selected</cfif></cfif>>#action#</option></cfloop>&l

This has never happened to me: something actually works in IE and NOT in FF! Current version of FF is 3.06. The CFdatefield input does not function in any Mozilla-based browser and throws a Javascript error: Error: "_f is undefined" "Source File: http://localhost:8500/CFIDE/scripts/ajax/package/cfcalendar.js" This points to a line in the JS: "ColdFusion.Calendar.setUpCalendar=function(_6,_7,_8,_9,_a,_b,_c){ var _d=ColdFusion.DOM.getElement(_6+_b+"_cf_button",_b); var _e=ColdFusion.DOM.getElement(_6,_b); var _f=null; var _10=null; if(_e.value!=""){ _f=_e.value; _10=_f.split("/"); } " Where the last two lines seem to have a problem. Can anyone help? This appears to be either a new issue (with a new release of FF maybe) or it's a local issue with my code (everything is possible I guess :). Robert

I use cf_sql_date as my report data source format.The report shows ts '2013-05-13 15:00:00 for the report.Please advise how I can change the format like mmm/dd/yyyy to my report for the date and hh:mm:ss for the time format for the report.Your help and information is great appreciated,Regards,Iccsi

Could people recommend a nice menu library that could be used easily with ColdFusion application?

My cfcookies are only good for "domain.com" and if a user goes to "www.domain.com" the cookie is not valid.  Any ideas on how I can make the cookie valid for the entire domain?  I have entered the domain as ".domain.com" in the cfcookie tag.  Coldfusion version is 8.Thanks!Mike

F1 !!!!! Need HELP asap. I get a server error by trying installing the hotfix APSB13-13 for CF 9.0. I try to install the hotfix under java-version 7.21, 7.11, 6.10, 6.14 and 6.16. What can I do?

Hi,Used the following URL to access the CF Adobe ColdFusion 10 Configuration and Settings Migration Wizard:http://localhost/CFIDE/administrator/After installing Cold Fusion 10, The CF Adobe ColdFusion 10 Configuration and Settings Migration Wizardscreen appears. The Login button is pointing to the following URL:http://localhost/CFIDE/administrator/enter.cfmEither after entering the password or just selecting the Login button, the following screen:HTTP Error 404.0 - Not FoundThe resource you are looking for has been removed, had its name changed, or is temporarily unavailable.The question I have is what should the Login button be pointing too?Thanks,Mike

We started testing the migration of one of our main websites from CF9 to CF10 and everything seemed to be going well.  When we started testing our web services though things got a little weird.  All of our web services were throwing error messages.  Both installations co-exist on the same Windows 2008 R2 server running inside of the same instance of IIS.wsVersion = 1AXIS errorSorry, something seems to have gone wrong... here are the details:Fault - Error attempting to create Java skeleton for CFC web service.; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.NullPointerException : null] AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service.; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.NullPointerException : null] faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}hostname:DevwsVers

I am using "&amp" in a coldfusion variable and assigning this to another variable. And I dumped this variable but am not getting results as I expected instead it outputting as below.<cfset x = "abdul & latheef"><cfset y = x><cfdump var = "#x#"><cfdump var = "#y#">Actual Output:x = abdul &amp latheefy = abdul &amp latheefExpected Output:x = abdul & latheefy = abdul & latheefAny idea about this why am getting output as I explained in Actual Output: . Timely help well appreciated.

The release note was confused.Adobe has identified a critical vulnerability affecting ColdFusion 10, 9.0.2, 9.0.1, 9.0, and earlier versions for Windows, Macintosh, and UNIX. This vulnerability (CVE-2013-3336) could permit an unauthorized user to remotely retrieve files stored on a server.

We recently upgraded from CF8 to CF9 Enterprise.  I'm getting an "Unable to create temporary file" error onmy CFIMAGE resize calls.  We use sandbox security.  I assume I need to grant write access to whatever folder CF uses for temp files, but which folder is it?   The same code (and sandbox settings) ran fine in CF8....Note, if I attempt to add C:\JRun4\servers\cfusion\SERVER-INF\temp to the sandbox for this particular app, CF crashes on all requests across all apps on the server with a:Security: The requested template has been denied access to C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfclasses\cfapp2ecfc1510154633.class.The following is the internal exception message: access denied (java.io.FilePermission C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfclasses\cfapp2ecfc1510154633.class read) ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsys

Hi there,i am trying to set up CF10 parallel to CF9 with the apache webserver. I've tried it with the Beta of CF10 but it didn't works. Now we perchuased CF10 and the problem is still the same. We ar usiung a CentOS 5.7, and the apache server 2.2.3.I installed CF10 with the server configuration, everything went fine. The first problem came up to, when i tried to start up the cfusion instance:Running the ColdFusion 10 connector wizard======================================================================Configuring the web server connector (Launched on the first run of the ColdFusion 10 start script)Running /etc/httpd/conf connector wizard...=======================================There was an error while running the connector wizardConnector installation was not successful=======================================Well, then i've activated the build in webserver, and i was aviable to access to the admin site. I created a new instance a tried to connect it manually to the apache webserver wit

Does anyone have a solution that combines jQuery File Upload with coldfusion - I am not very patient when it comes to jQuery and I am assuming a clever person has worked this out?! It is a great UI and if it it could work with CF and upload the image names to a database that would make me have sex wees!!!Thanks in advanceJan

Yesterday, I applied recommended hotfix APSB13-13.  Today, I can't get into my CF Admin panel.  I'm receiving a HTTP Error 500.0.I'm assuming this is an IIS issue related to a new DenyUrlSequence, but I can't find the solution anywhere.  I've confirmed that, in my web.config file at the web root, I have an entry removing the DenyUrlSequence, which SHOULD allow the local machine to access the CFIDE/administrator folder.1) Can anyone help me pinpoint the problem OR2) Can anyone tell me how to roll back the hotfix, so I can start over?Thanks in advance for any help/guidance.

I am trying to display a list sorted by year, then title and then subtitle. if there are no subtitles, titles should appear by itself. if there are subtitles then they should appear under titles, all in alph order.Here is a pic of what i am trying to get: http://www.flickr.com/photos/irfanirfan/8740957103/Here is the code I have so far, any poniters would be helpful.<cfquery name="getYear" DATASOURCE="LibDB" DBTYPE="ODBC"> SELECT distinct Year FROM Everything WHERE deleteflag = 0 ORDER by Year DESC</cfquery> <cfoutput> <cfloop query="getYear">  <br><a onClick="Toggle('#getYear.Year#')" class="toggle" style="border-top: 0px;" onMouseOver="this.style.cursor='pointer';">   <b>#getYear.Year#</b></a><span id="toggle#getYear.Year#" style="display: true"><img src='images/max.gif' alt='Maximize' border=0></span><br>  <div id="div#getYear.Year#" style="display: none;" class="toggle"> &n

I created a form with LiveCycle and I am able to populate the fields on the main page, but I am unable to populate the fields on the master page.  I have a footer on the master page that has a few fields that I want to display data in.  Is it possible to populate fields on a master page?  If so, what is the heirarchy of subforms on the master page?

hi my mail code is below:<CFSET Path1 = "#APPLICATION.ROOTPATH#/index.cfm?fuseaction=customerReport&isemailPopUP=Y&fileName=#trim(txt_fileName)#"><cfmail    to=""    from=""    subject="">Please note that the following file has been posted '#trim(txt_fileName)#'.Direct Link to File: <#Path1#></cfmail>Eg of the mail receivedsbody:  body:  Dear body:  body:  body:  Please note that the following file has been posted '1  ColdFusion Coding Standards.docx'.body:  body:  body:  :  body:  Direct Link to File: <http://website.com/sales/index.cfm?fuseaction=customerReport&isemailPopUP=Y&fileName=1  ColdFusion Coding Standards.docx>body:   body:  body:  Now the problem is when the user clicks on the hyperlink to download the file ,special characters link _ (underscore) or some unicode characters are inserted in the file name be