Questions

I have this query which worked great in AccessSELECT e.wall +l.wall As wall2yr, e.lall +l.lall As lall2yr, l.TEAMID, l.TEAMNAME, l.GY AS LaterGY, l.finalrating AS LaterFinalRating, e.finalrating AS EarlyFinalRating, e.GY AS EarlyGY, LaterFinalRating+EarlyFinalRating  AS twoyear FROM TEAMSEASONRATINGINFO AS e INNER JOIN TEAMSEASONRATINGINFO AS l ON l.teamID = e.TeamID AND l.GY = e.GY+1 WHERE l.GY =#url.GY# AND e.finalrating > 0AND l.DIVISION = #url.DIVISION#ORDER BY e.finalrating+ l.finalrating DESCNow I have switched to MS SQL and I am geting this error[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'LaterFinalRating'.     Is there something different the way MSSQL handles INNER JOINS or aliases?       

I'm setting up a new server to test ColdFusion 10 (will be upgrading from 😎 and I don't have the option for MS Access with Unicode from the driver list when adding a new DSN. Based on this referrence (http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe6.html) it looks like it should still be included, but I'm not seeing it. Any ideas how to get the option back?

In Adobe-9, can i set different deadline date for different reviewer?

le doc est de 48 Mb et il me marque a la fin Erreur de conversion trop long.Comme faire pour obtenir la conversion de l'archive?

Hi,I have CF 9.0.1 installed, and I'm not able to define a Solr collection.I get this error in the Administrator: "An error occurred while creating the collection: org.apache.solr.common.SolrException. Check the Solr logs for more detail."And in the Solr log, I get this:"JNDI not configured for solr"Any hint?Thanks.

I create a collection by indexing a bunch of .pdf files and then I use CFSEARCH to search for a string in the filename.In CF8 with Verity this was easy:*searchterm*In CF10, even if I don't use the leading * I cannot match any alphanumeric sequence.  For instance I want to search for M1234 in a filename that has M12345678 but Solr finds nothing.  If I get rid of the M and just search for 1234 it will find it.  Some of the strings however it makes a huge difference in the number of results returned.  I need to be able for the user to input an alphanumeric search term and CF return the results.  I'm finding this impossible.

I have been managing websites in IIS6, but I understand that things have changed radically in IIS7 and that "all I need to do" is consume the services available in Microsoft.Web.Administration's servermanager and Microsoft.Web.Management and I'll have all the services and methods I need to replicate what I was doing in IIS6.Well and good if you're savvy on that whole "consume services" thing, which I suck at.I am told I can find this in c:\windows\system32\inetsrv\Microsoft.Web.Administration.dll and, indeed, it is there.Try as I might, I cannot figure out how to pull this into an object so I can consume it.  I've tried:<cfobject type="COM" action="CREATE" class="Microsoft.Web.Administration" name="objMicrosoftWeb"><cfobject action="create" class='Microsoft.Web' name="objMicrosoftWeb" type="com"><script> set myServerManager = CreateObject('.NET', 'ServerManager', 'c:\windows\system32\inetsrv\Microsoft.Web.Administration.dll');</script><cfobject name="se

I want to display files from the day a viewer logs in, through the next 30 days. I tried the code below but it does not work. What am I doing wrong?<cfoutput><cfset mydatetime=#now()#></cfoutput>    <cfquery name="getdevotional" datasource="#application.database#">SELECT display_date, titleFROM mobilewhere display_date BETWEEN (#DateFormat(Now(),'YYYY/MM/DD')#) AND (#DateFormat(DateAdd('d', 30, mydatetime),'YYYY/MM/DD')#)</cfquery>

I have 2 running sites (plus cfadmin) on an IIS 7.5 server.  I want to run the command line to use wsconfig to update the connector on the smaller production site before trying it on the larger one or all.If I run this command to get a list:wsconfig.exe -listThere are 5 configured sites and 2 unconfigured sitesConfigured Site Number and Site Name:  0              All  1              Default Web Site (All)  2              cfadmin (All)  3              site1 (All)  5              site2(All)Unconfigured Site Number and Site Name:  4              ftp.site1  6 &nb

I have coldfusion 10 installed as our main server. I am using sessions to store some information and have set sessiontimeout=#CreateTimeSpan(0,0,45,0)# in the application file but for some reason the session is timing out way before 45 mins - around 10 mins. Is there a reason for this? I thought having the timeout in the application file would overwrite anything set in the coldfusion admin. Is this not true?Thanks

It says:  'There was an error opening this document. Acrobat cannot open this file because a task is still active in Acrobat. Please return to Acrobat and end the task before opening this file. '  I have no tasks open and have tried to Quit Acrobat but nothing works! Please help.  Working from MacBook Pro...

Hello,     I am new to this so bear with me, I am on my laptop with Internet 7, and windows 64 bit I was uable to install adobe flash player.  I was getting all flags from you tube and my on line school that I needed to update my flash player.  So I went to adobe and down loaded the free upgrade.  I could not get past step 2 of the 3 part process.  1.) First time it was because it already existed, so I went in and uninstalled the flash player I did hve (i had already tried the update your version, through adobe, they unistall and reinstall for you) this was a bad idea now I have no flash pllayer and it will not get past part 2.2.) Second flag I was getting was the internet was open and I could not install a new program. Frustrating because I had to have the internet open to install the flash player.  So I tried to save and run, and nope 60% and could not install.  I have tried saving it to a disk and a flash drive, nothing.  It sho

Hi,I am trying to bind the selectedNode in a cftree to cfinput<cfform name="form1" method="post"> <cftree name="mytree" format="html">    <cftreeitem display="cust_name" value="cust_name" query="entries" queryasroot="no" expand="no"> </cftree><cfinput type="text" name="display" bind="{mytree.selectedNode.getProperty('cust_name').value}"> </cfform>I get an error:Error parsing bind expression at character 0:{ in  {mytree.selectedNode.getProperty('cust_name').value}Is there anything I am missing ?Thanks

I am not an Ajax / JSON guy (yet).  I am trying to find a solution for a problem I walked into  (new client) and they are upgrading from 8 to 10. the cfgrid works okay in cf8, but fails to update in cf10.Right now, about all I have to go on is the console output, to whit:Exception: ColdFusion.Grid is undefined File: http://localhost:8500/billing/index.cfm?do=c.maintTable Line: 100 Column: 0Warning: Selector expected.  Ruleset ignored due to bad selector. File: http://localhost:8500/CFIDE/scripts/ajax/resources/ext/css/ext-all.css Line: 10 Column: 2Warning: Selector expected.  Ruleset ignored due to bad selector. File: http://localhost:8500/CFIDE/scripts/ajax/resources/ext/css/ext-all.css Line: 12 Column: 2Warning: Unknown property '-moz-opacity'.  Declaration dropped. File: http://localhost:8500/CFIDE/scripts/ajax/resources/ext/css/ext-all.css Line: 21 Column: 18Warning: Error in parsing value for 'filter'.  Declaration dropped. File: http://localhost:8500

I know Coldfusion doesn't officially support Apache 2.4 yet or at least I haven't found any documentation saying it does, but was wondering if it can.  Has anyone successfully gotten CF8 or any other version successfully working with Apache 2.4 using the connector?  Currently I'm having to support an app where we have linux Apache 2.2 servers sending traffic to CF8 servers on Win2K3.  Since we're using mod_jrun22 for the connector I doubt it would work with 2.4.  Security is requesting we upgrade to the latest version of Apache if possible so I'm investigating the feasibility of this since CF8 is so old.  Push come to shove we'll go to the latest of 2.2, but they really want 2.4.  Any info is appreciated.

Ideally I would like to download ColdFusion 8 Developer, but I'd settle for 10 if that's all we can get. But all of the links to download ColdFusion give a 404 page. Help?

I installed CF10 Server onto a VPS. it only has 2 GB RAM and I intend to upgrade that tomorrow, but nevertheless, CF10 is acting very strange -- or maybe it's just my programs. These programs have been running for many years, but I just moved them to this new server, so that could be half the problem.Anyway, the problems.  I can visit the site and get error "A".  Hit Ctrl-R and I'll get error "B". Or maybe error "A" again.  Or maybe this time the site will come up.   I can click the menus and move around, and then I'll get error "A again. Or "B". No rhyme or reason.  Sometimes the query will time out.  All over the board.I Have Not Applied Any Updates.  I just bought this -- do you need to apply updates to a new purchase (downloaded from Adobe, applied license)? While I have run CF servers since 1996, they've always been on managed platforms where I didn't have to worry about updates, or they've been local dev copies where the usage was minimal a

I am a ColdFusion user since version 3 (building web site with cfml).I do not know anything about the ColdFusion product itself.I am now wondering why new tags needs to access CFIDE directorywhich is the CF administrator directory ?I feel that engine and administration have been mixed up in same directory.Is there a reason ?I think about last CF vulnerability and hacking, afraid this mixup grows the vulnerability ?My question may be totally out, as I do not know about CF product architecture.Thanks for any clarification.Pierre.

Hi,I recently did an upgrade from a perfectly working 9.0.0 installation of enterprise edition ColdFusion, to version 9.0.2 with CHF1. And with this, some cfm pages that used to work earlier in 9.0.0 are broken. I realised that it is breaking on pages that have cflayout type = "tab", so assume its something to do with tabs in the pages.The error displayed when visiting such pages:36 : <cflayout type="tab" name="mytabs" tabHeight="650">37 : <cflayoutarea title="someName" name="Tab1"  >38 : <cfinclude template="someFile.cfm"  />39 : </cflayoutarea>Please let me know what is causing the issue, and where I can look at to have my tabbed pages display properly in version 9.0.2. Note - 1. these used to be perfectly fine in 9.0.02. pages without tabs are all working fine. no issues here. even graphs are loading fine.Thanks!

Security vulnerablity exists within CF administrator log in page (/CFIDE/administrator/login.cfm) HTML form.  Does anyone know how to apply a solution or work-around?  Web site security scanning reports the CF adminstrator log in page uses <input> password field autocomplete=on (default).  Solution is to edit web page form appending attribute "autocomplete=off".  But since the entire CFIDE directory uses ColdFusion's encryption, page is not editable.  A week ago (1/8/14), at Adobe's telephone customer support direction, I submitted a request for help to Adobe's support site (bugbase.adobe.com).  Requests to this site go into the ether ("not externally visible"). No response whatever has been provided.  The basic fix is for Adobe to send or provide an updated web page.  Problem is a site security issue.

Has anyone ever been able to use the CFLDAP tag to connect to a secure LDAP Service without putting the username and password in clear text in the source code?  For example:<cfldap     action = "query"    server = "myserver.com"    attributes = "*"    start = "dc=myserver,dc=com"    name = "results"    secure = "CFSSL_BASIC"    username = "MyUserName"    password = "MyPa$$w0rD">I was wondering if using a Web Service Account (which would be granted access to the LDAP Service) would be able to run the code without putting the username and password in clear text as shown above?  Has anyone tested this out before or have any further information on it?Thanks for any insights you can give.

I used the cftextarea to get the FCK editor, like :<cftextarea name="txt_h_1" message="Insérer le texte d'Accueil !" height="400" width="700" disabled="No" required="Yes" toolbaronfocus="No" bindonload="No" html="No" enabled="Yes" visible="Yes" richtext="Yes" toolbar="Basic" skin="silver">#get_param.txt_home_1#</cftextarea>So the name of the element is : TXT_H_1Ans when I want to save the content via an update query, it says that :Element TXT_H_1 is undefined in FORMAll other FORM elements are well returned.then how to get the value of the cftextarea ?(I used a CFFORM with <input> inside instead of <cfinput>)thanks for answer.Pierre.

Does Adobe support installing Coldfusion 10 on a Virtual Server(VMWare) ???I check the documentation and could not find any statment that mention that they support it.

Alright, serializeJSON isn't creating pretty enough JSON for me to use with jQuery.So I decided to build it myself.Here is my code:<cffunction name="getActions" output="false" access="remote" returnformat="JSON">    <cfquery name="Actions">      SELECT * FROM Actions    </cfquery>    <cfset ActionsList = '{"success" : "true"}, {"Actions" : ['>    <cfloop query="Actions">      <cfset ActionsList = ActionsList & '{ "ID" : "' & ID & '", "Name" : "' & Name & '"},'>    </cfloop>    <cfset ActionsList = ActionsList & ']}'>    <cfreturn ActionsList>  </cffunction>So basically I send an AJAX Asynchronous call with jQuery to the cfc that contains this code.jQuery kept telling me the JSON was bad.So I output what Coldfusion was sending back to the browser.

Has ant one experienced cftextarea not displaying tool bar in ie 10.  Thanks in advance.