ColdFusion

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

I have a report that passes a date (time stamp) to a subreport. Sometimes the date being passed is  null (or an empty string) and the report . When this happens get an "Incompatible java.lang.String value assigned to parameter GradDate1 in the ColdFusionReport dataset.". I want to change the value of the Param being passed to current date.  Where and How can I change the date in the parama being passed. I've tried many things (functions, in the query, etc) and can't get anything to work. We are on CF 9. Please help!

I am trying to edit the report query, changing the joins on the tables, and Report Builder crashes repeatedly.  Anyone experienced this? Is there a patch for Report Builder I don't know about?Nathan Manning

with cfreport i can add some function to my report.i would access to recordset (passed to cfr) for ordering it.query to cfr -> ordering recordset in cfr -> printis this possible?thanks

I am using Report Builder 8.I am grouping on a date field, but some of the people returned have a null value. I need to show an alternate heading if that group's date is null, I would actually like it to head it with "No Date"However, I can not figure out how/where to put it that conditional statement.Thanks!Michelle

Does CF10 Server support SHA2 certificates for ssl LDAP?

I am using CF9 and have generated a report using CF Report Builder that has a report parameter that function correctly.I am trying to be able to get the variable value from the the address line and then display the cooresponding report page.I have set a default value in report builder and written a simple viewing cfm.  <cfreport template="NC_ImpactReport.cfr" format="pdf"> <cfreportparam name= "CFVarProjectID" value=55></cfreport>When I run this I get the report returned correctly for record '55'http://website/nc_impactreport.cfmAnother program will have the hyperlink (http://website/nc_impactreport.cfm) with the selected record id(ie55) all on one line.How do I get the variable value from the address line into the cfm correctly to pass it into the report?Thanks,Kurt

Hello,I have been following the ColdFusion 10 lockdown guide (this question also relates to CF9 though) and we are recommended to change the /cfide/scripts directory to a custom directory as /CFIDE/Scripts should be blocked by request filtering.See point "2.2.8.1 CFIDE URIs" and "4.1.5 Setup Virtual Directory alias for /CFIDE/scripts/"Is there any way to edit the paths the WSCONFIG.exe tool uses so instead of it adding the 'jakarta' and 'CFIDE' virtual directories to all sites it adds the 'jakarta' and my own 'CFScripts' virtual directory which points to a different path than /cfide/scripts?My reason for asking this is after some CF10 upates we have to re-run the WSCONFIG.exe tool, this results in all my sites containing a /cfide/ virtual directory which I don't want - scripts should be accessible from /CFScripts which i have to manually add to each new site. If WSCONFIG.exe could add this for me it would save much time and allow a more secure setup.I hope I have provided enough inform

I'm running a cfindex in Solr of some 35,000 documents. The process keeps getting "maxWarmingSearchers exceeded" errors andI have found no mod of the setWarmingSearchers, cache and other things mentioned in various posts about the error. I finally found mention of useColdSearcher in solrconfig.xml normally being set false, but this could be set to true to avoid using maxWarmingSearchers. Is there a way to add that as an attribute in the cfindex attributes so useColdSearcher can be set to TRUE for a specific cfindex command but leave it as false in solrconfig.xml for general purposes?

In my LOGIN and LOGOUT module I am calling a cfc method using javascript ajax. But I want to pass password after encoding.Is there any way to encode the password to be send to CFC method so that I should be able to decode the same also in the CFC method.My javascript code is like below.xmlhttp.open("POST","cfc/useraccess.cfc?method=checkUserAccess&username="+username+"&password="+password,true);xmlhttp.send();I want to pass this password in encoded form.Any one have any idea on this.Your help is well appreciated.

Hi guys totally new here and honestly new to CF as well,So here is the situation I have to move coldfusion sites from an old sun solaris 5.8 system running coldfusionmx7 to a Windows server 2008 R2 system running Coldfusion 10. So far I have moved one site over for testing and I am getting a 500 internal server error Cannot find CFML template for custom tag sae_request_check ColdFusion attempted looking in the tree of installed custom tags but did not find a custom tag with this name. If you are using per-application custom tag mappings, ensure that per-application settings are enabled by the administrator. Again I am totally new to coldfusion I was able to get it running on the windows server but this transfer is a bit beyond me any advice is greatly appreciated.Thanks in advance