ColdFusion

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6d46.html

I got an error message when I connect to a MS SQL server with SSL connection.The error message is connection verification failed for data sourcejava.sql.SQLNonTransientConnectionexception:[Macromedia][SQLServer JDBC Driver]The SQL Server login requires SSL Conection.Any suggestions for this error message,Your help and information is great appreciated,Regards,Iccsi,

where do i find or obtain Adobe product end-of-life cycle support information - specificall Adobe Cold Fusion?

We have a CF application which is running fine locally under a v9 developer licence. We now need to transfer to a production server. We have bought a v10 enterprise licence which we were hoping to downgrade to 9 to avoid making any changes to the setup. v10 seems quite different. We have been told via the reseller that there is no way to downgrade the licence. Any suggestions?

Hi guys,am trying to open up a .exe file like notepad or whatever windows program with using <cfexecute> but seems it doesn't work at all. I'm able to write the command in cmd and run the exe file but when i put the command in cfexecute so i get nothing.here is the command i would like to run:"C:\Program Files (x86)\Vc\vc.exe" -e "\Crystal\BF_Faktura_D.rpt"altso, run/start a simple .exe windows program. I think there is something about security access from CF server or something like that.ANY HELP?

Hi Everyone!We have been having issues with session variables being dropped/changed. Basically what is happening is a user submits a web form and the session variable is changed. We also have problems on other pages where a user will enter their username and password, but once page navigates to the next page or even within the same page when a form is submitted, session variables gets reset. We noticed CFID and Token is different when we navigate or page gets refreshed. I have checked session management settings all over and don't think that's the problem. I have searched and found similar issues but none of the proposed fixes have seemed to work for us. I should also say this problem does not occur for every user. It seems intermittent which adds to the fun...    Our pages all worked fine under Windows 2003 and CF8. We built new W2k8 servers with CF10, moved our files over and set up the new sites so it can’t be left over isapi connectors in IIS. Here is the problem in a nut

It appears that  cfinput 'datefield' always aligns to left, I have tried everything I can think of to get it to align center (in the td, in a div,  style in the input, etc) and it just wont align center, I even tried putting a bunch  of   in front of the input and it puts them on the right. Any Help would be appreciated.

My application needs to support dynamic THIS scope variables.As it stands, onApplicationStart, I load an XML config file, parse it, and it contains a structure which mimics the variable structure ColdFusion supports.  Problem is, once I'm in the onApplicationStart() I've already passed the pseudo-constructor area where THIS-scoped variables are supposed to be set.In the onApplicationStart, I could not redirect to the same URL that was requested because I would never get to the <cfreturn true /> that is needed to start the application.Also, we use URL rewriting, so even though the URL may look like : http://sub.domain.tld/this/that, the actual page being called looks like: /sub/app/templates/request.cfm?path=/this/thatAnyways, in the pseudo-constructor, it checks if the application exists, and if so, iterates over a variable that holds this structure which holds the THIS-scope variables, and puts them into their respective places on subsequent page loads, but, as I understand

Hi,We recently moved an application from CF 7 to CF 10 and have since noticed that browsing to a non secure page (http) to a https page makes the server lose our log-in session. Our site has a log-in page, and this is served securely. When the user logs in they can access all other pages that securely link from that log-in page. But, as soon as they click on a non-secure page, the session is lost.  This is a clean CF 10 install, not an upgrade. Are there any known issues with sessions and HTTPS in CF10 that we should be aware of? I printed out the session/cookie scopes on each page and it seems we get a new JSESSIONID for http/https sites, even though they have the same domain.  Our cfapplication tag is defined as:  cfapplication name="ourSite" clientmanagement="yes" sessionmanagement="yes" sessiontimeout="#CreateTimeSpan(0, 0, 20, 0)#" setclientcookies="yes" setdomaincookies="no" clientstorage="Cookie" scriptprotect="all"Can anyone please shed some light on this? The do

Hi Folks,Anyone know what number of  graphics available in the cfgraph tag?Where I can find more  information about this?[ ]'sFabiano Magno Pechibella

Hi, When i try to dump the Ram from cfm, i got error :Variable Ram is undefined.  However, when dump the rfalg inside the cfc, it got all the results.  Can anyone please tell why?      Thanks <!---.cfc---> <cfcomponent name="costingReport" access="public" description="generating report">          <!--- object constructor --->    <cffunction name="init" access="remote" output="false" returntype="Any" hint="constructor">        <cfreturn this />    </cffunction>    <cffunction name="FindR" access="public" returntype="any">             <cfargument name="parentID" type="string" required="yes" />            <cfset var rflag = 'No'>        &nb

I need change label caption on the report using Report Builder and data source from a stored procedure.Your information and help is great appreciated,regards,Iccsi

Been using Photoshop on subscription over a year with no problems and yesterday I went to open it and it just wont open. No error messages, just the timing circle appears then disappears.Tired closing it through task manager but it doesnt appear on the list.Any ideas would be greatClair

I have two table in different page...i want to pass data from first table in the first page to the second table in the second page using checkbox...anyone know how to solve this matter? thanx..:)

We're using CF7 (still) and needs to publish a webservice which takes as input a complex request with a struct of array of struct of array of struct......etc. From what I can see itcan't be done in CF7. Can it be done in CF10?Sample desired input to webservice .   =======================================================================================================<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ther="http://hi/there" xmlns:web="http://webservice.cfcs.common.things">   <soapenv:Header/>   <soapenv:Body>      <ther:savethings>         <ther:Thing>            <web:EDate>?</web:EDate>            <web:Id>?</web:Id>            <w

I have a group in my report and I have a report header.I have a label and a field on the group header, but it only print every page on top of the page.I want it print every time it change group, do I need do any change configuration for this.Your help and information is great appreciated,Regards,Iccsi

Hi All,We are getting this exception on our production servers (WIndows 2003) while sending emails using cfmail (ColdFusion 10) and local smtp server.A problem occurred when attempting to deliver mail. This exception was caused by: javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.BindException: Address already in use: connect. We are sending emails using cfmail (with spooling = "No" because we are sending email attachments which will be deleted after sometime)  and the email is not delivered to the users and we can see this exception in the application and in the Coldfusion mail logs as well  after upgrading. to CF10It seems the Coldfusion is opening more number of sockets to send emails but the sockets are already in use.In one click we will be sending around 20  to 50 emails including attachments and we are using local smtp server to send the emails..We don't see any logs related to this in the smtp logs

I'm pretty new to ColdFusion, and I'm reverse engineering a site for some folks to figure out how to make some minor changes to it. First order of business is to get a functional local development environment so I can test changes rapidly as I move through the learning process. To this end, I installed CF10 as a developer version on my Windows 7 x64 workstation. I installed it as "built-in" (Tomcat) installation (no IIS), as vanilla as I can get in hopes that would be the simplest way to get going.I have a copy of the website on my machine locally, and I've put all of the files and folders for it in the "wwwroot" folder. I have no need for multiple instances, or Wheels or any of the extensions, so none of that is set up. the installation is about as "stock" as it can be.I can browse to the admin page of the website and it loads perfectly. However, once I choose an option and click "Submit", it redirects to a directory-only URL (like "localhost:8500/admin/membership/" using CFLOCATION.

I use Report Builder for summary at group footer.I tried to function builder likeSum(Query.MyField), but the report builder does not like this for some reason.I tried to use Query.MyField, Report Builder still does not like it to give me ColdFusion does not recognize it.I need to have calculation field like sum(MyField1 * MyField2)/ sum(MyField2) and sum(MyField2) base on group elements. for my summary field and need change color if it is neccessary.Does Report Builder support client side code like Javascript to change client side behavior?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 have a cfsearch that is displaying  a record that was deleted from the database weeks ago.  I have run the code below and the record keeps coming up.  What am I doing wrong?  Here's the code:<cfquery name="getstudents" datasource="myDatasource">SELECT ID, fname, lname, fullNameFROM student</cfquery><cfindex query="getstudents"      collection="myCollection"      action="update"      type="custom"      key="ID"     title="fullName"      body="fname, lname, fullName">                                                             &nbs

Verified issues with swsoc.exe in ColdFusion 8 causing connection issues over time.  Must use the ODBC connector in our environment.  This appears to be a common problem when searching on the internet, however, no fixes are listed.

Hi, I have been working on a specialized patient data application and I am trying to build a master report of a Patient's Chart containing all the data collected on a patient.  This involves several tables and would be 10 to 12 subreports, but I am running into problems in report builder putting in more subreports than can fit in a single page in the report editor.Does anyone know a work around for this? Can you define multiple pages?  What would be your solution to my problem?Nathan ManningNew Millennium Software

I created a report function to find and return a graduation date. I only need to execute the function once per person.The query returns all colleges a person attended, I only want to report the colleges they attended before their graduation date (or current date if they have not graduated).I tried to create an expression in the "Print When Condition" CF did not like what I tried. I don't believe I'm referencing the return varible correctly.We are on CF 9 and I have already spent too much time on this project. Any and all help will be appreciated.

I have a Transcript report and I only want to print any other institude name and credit earned (transfer information) that occurred before the student graduated. I am selecting only the institudes that have a 'receive date' prior to the 'grad date'. This works great on the students that have graduated. If they haven't graduated the 'grad date' is empty and I error out when comparing it to the receive date. Here is the query that calls the transfer information:selectnmedu.soc_sec, nmedu.credits, nmedu.date_rec, institut.inst_txt, institut.homeinst, nmedu.graduatedfrom nmedu, institutwhere institut.inst_cod = nmedu.inst_codand institut.homeinst = 0and nmedu.credits <> 0and nmedu.soc_sec = '#param.socsec#'and nmedu.date_rec = '#param.graddate1#'ORDER BY  inst_txtWhen the student has not graduated I get the following error message: Incompatible java.lang.String value assigned to parameter GradDate1 in the ColdFusionReport dataset. If they have graduated it works great.I'm runnin