Questions

Hello , I am making migration from CF 8 to CF 11. Using MS SQL server. Raised an issue when check the result from cfquery tag.In CF8 all fields which are defined in DB as uniquieidentifier, when I receive the result there are in lowercase , something like this ''4eert4erte4tert4ert4545 .... The same request to the same DB and MS SQL server, but using CF 11 returning the result in capital letters , something like ''4EF56DSE76534SFJSF ....... Do you have an in idea how I could fix this. I assumptions are that this is comming maybe from some settings of the connector of CF to MSSQL , I am not sureis this connector actually is using the JDBC driver . I really stuck in this so any ideas will be welcome.

See the following code: spreadsheetObj = SpreadsheetNew('Metrics',false);SpreadSheetSetColumnWidth(spreadsheetObj, 3, 10);SpreadSheetAddRow(spreadsheetObj,'Merchant ID,Merchant Name,Return Customer#chr(13)##chr(10)#Conversion Rate');SpreadSheetSetRowHeight(spreadsheetObj, 1, 50);SpreadsheetFormatCell(spreadsheetObj, {textwrap=true}, 1, 3);SpreadsheetFormatRow(spreadsheetObj, {textwrap=1}, 1);Even using both Cell and Row formatting I can not get the text to wrap. This is what the resulting file looks like: If I click on C1 and click the "Wrap Text" option in Excel, it formats correctly.. so the line breaks are there. This is CF10 by the way and I believe we run CF11 in production which I think I read solves this problem. Just wondering if anyone else has seen this or documented a fix. I've also tried XLSX and XLS.

I have developed a CRM that is based on sales leads that post to a database.  The CRM index page performs a select query and displays a filtered recordset based on the SQL.  This index page refreshes every 30 seconds via a Meta Tag refresh.  But I am thinking that there must be a more robust/efficient method.  Ideally I would have a popup appear each time that new record posts that when clicked would bring up the detail for the record.  And if such a robust method exists, what might better the overall refresh of the data other than a Meta refresh?  Any direction you can advise would be appreciated,.

So an application I have inheritted has been running for some years with CF8 and Flex. It assigns tasks, appointmnts, rest days, holidays of our operators. The operators open the application on their laptop or available PC. But we think that this system is somehow old and slow and we think we needs more interaction with the operators. One xample of what we need. It would be nice if the operator can inform the app about realtime changes so that another operator can be despatched for backup. Also the operators want to have their own space and communication channels.We want to make the system easier to use. If possible using Coldfusion only. With Ajax? I don't know if this is possible. Any ideas?

We recently upgraded from CF9 to CF11.  I am having an issue where CF is throwing Element undefined in URL when the variable is clearly defined in the URL. Here's the flow...The user clicks an icon to update an item.  A new window is opened and variables are passed in the URL.  User makes the changes, presses submit, CF makes the updates then the Window closes.  This worked fine in CF9.  Since the update when the user presses submit the window never closes and CF throws the error.  Nothing changed in the code.Thanks in advance for any help!Gary 

CF11 will give the above error even the self-signed root certificate is added... how to fix??

While try to setup a CF11 and use cfldap to a LDAP server with SSL (self signed cert), the self-signed root cert is added into the default "cacerts" file, but still failed to bind.  It works from version CF7 to CF9.  I even tried in CF10, also not work.  Any body can help???  Million thanks!!!!!

I have lately upgraded to CF10 from CF9.Just lately I have noticed that I cannot get gmail smtp mail server verification within CFAdmin.I am using the same settings as before.  In fact, on an old machine using CF9 I still get mail server verification.MAIL SERVER: smtp.gmail.comUSERNAME: name@gmail.comPASSWORD: xxxxxxxxxxSERVER PORT 25x  Enable SSL socket connections to mail serverAny insight would be greatly appreciated!  wayne

Hello, I am in the process to deploy .car file from ColdFusion 9 into ColdFusion 11.When I open ColdFusion 11 Administrator -> Package & Deployment -> ColdFusion Archives -> It shows Internal Server Error 500.Application Log file shows the error below:Element CAR.ARCHIVES is undefined in REQUEST. The specific sequence of files included or processed is: E:\ColdFusion11\cfusion\wwwroot\CFIDE\administrator\archives\index.cfm, line: 247Any help on this would be highly appriciated.Thank you in advance !!

Hi, How can i catch different SMPP error type return by SMSC server ?I want to catch result like 0x45,0x01,0x0B,0x58,0x15.... in my code. I can see eventgateway.log logging the error message but how do i get error type in my code ? Thanks

coldfusion10 - just installed it.  could get in before i loaded the updatesserver is running fine otherwise

Am converting from Verity to Solr search. Anyone have any luck increasing the length of the summary generated by Coldfusion under Solr? I noticed that with Solr, the summary will list the first few words of whatever you enter for the "body" of the CFINDEX whereas Verity's summary is longer and goes to a paragraph/sentences where it finds the search word criteria (or close to it). Under the Solr, the summary doesn't seem that useful. I want to increase the summary text so it display more...hopefully, useful information.

DateFormat(query.fromDay, "m/d") + "  "  + DateFormat(query.toDay, "m/d")I wanted to show my report field like ' from 10/20/2014 to 10/25/2014 and have above code in the expression.I got error when run the report.It works for one expression like DateFormat(query.fromDay, "m/d"), but it does not work to combine 2 of them together.Your help and information is great appreciated,Regards,Iccsi,

I'm still using CF8 and Oracle 11G back-end.When I use NVL in the query of query I got error....Can't I use NVL to check on null value? Please helpHere is my codes:<cfquery name="GetC2" datasource="#Trim(application.OracDSN)#">     SELECT CamID2, rel2_2,p_ln2,p_fn2,ins,l_year     FROM prt_temp     WHERE Ins = 'CC'     AND l_year =  '1481' AND NVL(Child_LN2,' ') <> ' ' AND NVL(Child_FN2,' ') <> ' '    </cfquery>   <cfif GetC2.Recordcount NEQ 0>       <cfquery name="CheckRel2C2" dbtype="QUERY">     SELECT CamID2, rel2_2     FROM GetC2     WHERE NVL(Rel2_2,' ') <> ' '     AND NVL(p_ln2,' ') = ' '     AND NVL(p_fn2,' ') = ' '     AND Ins = 'CC'     AND l_year =  '1481'   <

Hello, everyone,I've got a project that I'm working on that has (basically) the following folder structure:/       (webroot)-main----qry----disp-org----qry----dispI've got a form in /org/disp that has a CFSELECT that I need to bind to a CFC in /main/qry.  I've tried "cfc:main.qry.cfcName.functionName(param)", and "cfc:/.main.qry.cfcName.functionName(param)", and I keep getting the "component cannot be found" error message.  How can I get this to work?V/r,^_^

We are updating our Applications to use single sign on and are running into a problem with database access. We are using CF11 Enterprise and SQL Server 2008 on IIS 7.5.We have set up the ColdFusion Application Service to run under an AD service account and have created the data sources in CFAdmin leaving the username and password blank. The data sources verify and all seems good. The problem comes when running a query. The credential passed to the database is the service account and not the windows authenticated user. As such the query fails. What are we missing to get CF to pass the Windows Authenticated user credential instead of the service account?ThanksTim

HEllo, we bought cold fusion 9 in 2011, now we want to upgrade the version.What cold fusion version can we donwload  to update? 9.0.2?, 10? what of them are free?

Hello,I created sample webservice (just because my other one didn't work):# cat test.cfc<cfcomponent>    <cffunction name="echoString" access="remote" returnType="string" output="false">        <cfargument name="input" type="string">        <cfreturn arguments.input>    </cffunction></cfcomponent>and now i'm trying to use that webservice by soapUI by sending:<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" >   <soapenv:Header/>   <soapenv:Body>      <def:echoString soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">         <input xsi:type="xsd:string">333</input>      &

I've sent an email to Adobe, and a member of Adobe sales team promise to call me last week, but nobody called me. So i'll try this forum.We are about to upgrade some of our customers ColdFusion 10 Standard servers to ColdFusion 11 Standard. While trying to find information about ColdFusion 11 Standard licensing, we could not find the exact answer regarding to the amount of virtual processor cores.So the question is: How many processor cores does ColdFusion 11 Standard allow on virtual server (vmware) (Windows Server 2012 R2)?Regards,Toni

Hi I am using CF11 on IE10 window server2012 with IIS8.0. I am using cftextarea with basic toolbar, it loading the toolbar but when I try to select any control from tool bar it throws the below JavaScript error:"SCRIPT5007: Unable to get property 'toLowerCase' of undefined or null reference fckeditorcode_ie.js, line 30 character 416"Please help me.........Thanks in advance.

My Coldfusion 11 server is running in a virtual machine.When I add a server I enter following data:Server Name: CF KOVApplication Server: CF+TomcatHost name: 192.168.0.100Webserver port: 8500Select 'Is Remote'This will add a server which status is 'Stopped'.When I read the manual of Coldfusion Builder 3 I see that I have to start a Admin Server Instance with adminstart.batThis adminstart.bat isn't installed.Where can I find this bat file?Should I stop the service 'ColdFusion 11 Application Server' and all other Coldfusion services?While installing COldfusion 11 I used the option 'Server configuration' and not the 'JEE configuration'

Any one has a link where I can download the CF Builder 2. Our licensed can't be found.

I have a report which has 40 columns and orientation is landscape. left and right margin is 0.0972 in.It shows all columns on pdf format, but missing last column when use Excel format.Are there any limitation for Excel format report?If PDF format has the last column, why Excel does not pick the last column?Your help and information is great appreciated,Regards,Iccsi

Property inspector of my ColdFusion Report Builder 10 missing suddenly, I tried to use View --> Panels --> Properties and Windows --> Inspector Properties, but it does not show.Are there any way to show Properties Inspector from hiding?Your help and information is great appreciated,Regards,iccsi,

I have a web application written in CF8 with Oracle 11g as the back end. This application has been used very often for more than 6 years. Currently I am moving to CF10 and did only a little modification to the CF codes. When I ran the new application in my test server, everything seems to be working just fine except when it calls an Oracle Package. This action produces an error:  Error Executing Database Query The strange thing is everything work before and after calling the procedure, I tested using cfabort This Oracle Package is still working in production server (CF8)  but not when it is called by CF10. My question is: Is there any changes for CF10 when calling a procedures? or is there any hotfix that I'm not aware of? The code is as follow:   SELECT case trim(to_char(SYSDATE, 'DAY')) WHEN 'MONDAY' then '1' else '2' end AS TodaysDate                 from dual    &