ColdFusion

A big problem, I cannot anymore use my new CF datasource.I use to declare CF datasource on a C F9 64bits , Windows serveur 2008 64bits environment.I have around 80 datasources declared (Access mdb files).I use the same procedure to create my datasource.create the ODBC32 datasource.Then create the CF datasource linked to the created ODBC datasource.As I always do.When I verify the datasource in the CF admin, it says OK. all seems goodAnd when I do a query to that datasource,I have this message :Security: The requested template has been denied access to allergan_prof_sante. The following is the internal exception message: access denied (coldfusion.sql.DataSourcePermission allergan_prof_sante) I tried to create an other datasource.Same behaviour. OK in the CF admin.And "access denied" when doing a query.So now, any datasource created cannot be accessed.I did not change anything on the Windows serverThe only change, is my client PC which ftp the mdb file.It was Vista, and is now windows 7.

How to use "#" sign in jQuery For id? When i try to use it like ($('#PropertyAttributeValue').css('color', 'red');)  i got error like following:The CFML compiler was processing:An expression that began on line 64, column 37.The expression might be missing an ending #, for example, #expr instead of #expr#.The body of a cfoutput tag beginning on line 19, column 18.

I need to detect whether a browser has flash installed and active, and if not I will switch to an alternative set of code.Can anybody tell me how I can test for an active flash installation? (on CF8)ThanksMark

Hi,I am running CF9 standard on a production environment. We had a disk crash this week and had to rebuild our server as the backup was corrupted as well.I installed IIS and CF 9, and now have an issue with query stringd being truncated.These are short strings that were working before the crashThis is causing errors as values the cold fusion pages are looking for are not being provided to the pages. Here is an example of a truncated URL from the IIS log: redirectionNom=164666-events.html&the correct url would be  redirectionNom=164666-events.html&id2=23456 Note the ampersand where other data would be added to the url. I have validated that this is the issue by dumping out the values for the url and the CGI variables and comparing this to the url in the address bar. We are definitely losing things off of our URLs.These are not very long query strings, so request filtering should not be stopping them, and we are not getting the expected 404 error we would get if it was a req

<cftry><cfset jsontxt="{""A"":""Bob"",""B"":123,""C"":null}"><cfset json=deserializejson(jsontxt)><cfdump var="#json#"><cfoutput>    <li>[#structkeylist(json)#]<br>    <li>[#json.a#]<br>    <li>[#json.b#]<br>    <li>[#json.c#]<br></cfoutput><cfcatch type="Any">    <cfdump var="#cfcatch#"></cfcatch></cftry>The documentation states: The JSON null value becomes the string null.http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-79e4.htmlThe above test on CF9 operates as described in the docs, but CF10 errors on #json.c#I found some old code (compacted a bit), which implies that the old behavior was to convert json's null to "null". <cfloop list="#structkeylist(contact)#" index="lp">  <cfset x=evaluate("contact.#lp#")>  <cfif x eq "null"> &n

I have an older application that I have upgraded and I am only having issues with the Search Engine going form Verity to Solr.I have a simple query tht gets the content for each page and indexes it. The code works awesome in Varity - but when I run it on the Solr system I get the following error:Error_opening_new_searcher_exceeded_limit_of_maxWarmingSearchers4_try_again_laterAlso - when this errors out (only this error) - the prowser shows the HTML Source of the error instead of the typical?Any help, please!There are only 207 records that I am trying to index?between 20-25 actually get indexed.<cfindex action="PURGE" collection="#application.stSiteData.objectCollection#">            <cfquery name="qGetData" datasource="#application.stSiteData.datasource#">                SELECT  objectID          

i want to be able to update a table cse_montly_reportsthis is my code right now<cfquery datasource="Intranet" name="reports">  with Employee_cte as (      Select e.*,             (Select SUM(r.execoffice_status)              From intranet.dbo.CSEReduxResponses r              where e.emp_id = r.employee              and YEAR(r.approveddate) = YEAR(GETDATE())                and    MONTH(r.approveddate) = MONTH(GETDATE())-1                    and execoffice_status <> 2        

Im trying to figure out how to approch a problem. what I want to do is generate a new file/link, maybe using 'cffile' or any other way.Right now i have cse_newsletter.cfm , that looks like this(kind of)<html>.......<cfquery>select ....</cfquery>select ....<cfquery></cfquery>....... <cfoutput>      <h1>Starburst Star Award</h1>     <h3>Winner: Department- #highest_dept_name_average#</h3>     <h3>Average:  #hihest_dept_average# </h3>     <h4>Runner-up: Department- #highest_dept_name_runnerup# </h4>     <h4> Average: #highest_dept_name_average_runnerup# </h4>  </cfoutput></html> the query works and give me the correct output i want.(rigth now i use cfshedule to run it, but everytime i will run it will overwrite the old data with the new) what it does it gives me the dat

hii have embeded tv.adobe training videos on my website http://vidzonline.com and i just want to enable replay button only and stop the suggested videos in player box. it is possible the off this feature in player?

Hello, everyone,Is there a way to change the attributes of a .txt file that already exists?For example:  I use CFFILE to write a .txt file that is blank, and supply the "readOnly" attribute.  Later, I want to dynamically add data to the file.  How do I set the .txt file to NOT readOnly so I can add data?  And, conversely, how do I set the attribute back to readOnly?V/r,^_^

I have settle down with my problem of pagination before.But instead of using**<< Previous Page // Next Page >>** I want it to be**<< {Director ID} // {Director ID} >>**Can anyone help me?This is my full code.I just wanted to change Previous/Next with the current Film Director displayed.    <cfquery datasource="#dsn#" name="list">     SELECT          *    FROM          directorList    </cfquery>    <cfquery name="qIDHM" datasource="#dsn#">    SELECT          directorID     FROM          directorList     WHERE          directorID = '#list.directorID#'      GROUP BY    

I installed the Microsoft Visual Studio Foundation Server plug-in (  Microsoft Visual Studio Team Foundation Server plug-in for Eclipse10.0.0.201003261741com.microsoft.tfs.client.eclipse.feature.feature.groupMicrosoft)I'm running windows 7 Enterprise Service Pack 1 64-bit. The CFBuilder version is shown in the image below.and now want to install a different full version of the plug-in but cannot do that without uninstalling this one first. However, I have been unable to Uninstall the plug-in no matter what I have tried. The "easy" way using the uninstall button is not available to ( see image below). I have tried numerous suggestions for manual uninstall but the plug-in will not go away, and thus prevents me from installing the newer version. Upgrading is not allowed. I have been using "Run As Administrator" etc to make sure I have adequate permissions.At this point I am feeling stumped and may just have to uninstall CFBuilder and start over unless someone can suggest something ne

Hi,I just started ramping on Flex and CF.  I was working through the FlexTestDrive but am getting stuck at the same place on two different machines using WinXP, IE8, CF9 and FB 4.5 on a laptop and WinXP, IE8, CF10 and FB4.5 on a desktop.Up to the point where I am adding data to the db provided by Adobe everything works fine.Module 2 - Add DataI get an error popup that says:Unable to invoke CFC - Error Executing Database Query.Java exception: 'Negative position: java.lang.IllegalArgumentException'.Has anybody reached that position and had this issue.Couldn't find anything similar on the forums or on Google.Thanks.

So I am trying to set up a table to have a set of rows repeated based on a variable set up in a separate location.  So I have table output being generated from a cfoutput of the query, then in the cfoutput tag, I have a cfloop statement with the <td>s for the columns that I need repeated based on my variable.  The problem I am experiencing is that the loop, instead of running from 1 to x (even when I hard coded the to = "2") is running per row the number of records in the cfoutput query in a decremental fashion, if my query has 11 rows, I get 11 loops the first run, then 10, then nine and so on. Has anyone experienced this before?  Here is the code, working with CF 9 on SQL Server 2012:<cfoutput query="getNCDs">     <tr>          <td class="ins_grid_data">#getNCDs.ncdId#</td>          <cfloop from="1" to="2" index="y" > &n

Under windows XP, and Coldfusion 8,I have problem to select all the Access database records, more than 400 000 records.The Access file is of around 200 Mbytes.I get a Java message, out of memoryThe PC has only 1Go of RAM memory,If I upgrade the memory to 2Go, does this should help ?Thanks for help.

When I create a file helloworld.cfm in root folder and browse to http://localhost/helloworld.cfm, it renders cfoutput fine <cfoutput>#now()#</cfoutput> shows the correct date and time.But, when I go to the CF Administrator and enter the password for the initial setup, I keep getting the following error. Anyone have any idea how to fix it? I have checked permission everything seems fine. If there is no solution, then I am thinking of upgrading to CF 10. If I buy and upgrade from CF8 to CF10, can I do a fresh install on a new 2008 server, or do i need to have CF8 installed correctly first? Server Error500 - Internal server error.There is a problem with the resource you are looking for, and it cannot be displayed.500 ROOT CAUSE: java.lang.IllegalArgumentException at coldfusion.filter.FormScope.parseQueryString(FormScope.java:321) at coldfusion.filter.FormScope.parsePostData(FormScope.java:293) at coldfusion.filter.FormScope.fillForm(FormScope.java:243) at coldfusion.filter.Fus

i have written a stackoverflow question , would like some input if you have any , thanks, i would like to stay away from using jquery http://stackoverflow.com/questions/23143436/how-can-i-generate-data-when-the-link-is-click-on/23143813?noredirect=1#23143813

I know that in past versions of CF and IIS, I've been able to redirect an entire folder such that 404 request to www.domain.edu/folder/filename.cfm would simply redirect.  However now it seems like if the request is for a CFM, IIS ignores this, and hands it off to ColdFusion's 404 template, completely bypassing the redirect directive in the web.config for a given directory.  This is creating more 404's than previously because we had actually successfully managed them using folder redirects in the IIS admin tool.I wonder if others have suggestions on how to handle.  I know that another way is simply to "sniff" for the 404 path that is passed to the CF 404 template.  That's proved to be challenging as well, since the latest version of CF doesn't seem to carry through that query string/referer to the 404 page.I'd rather handle it all in IIS and I wonder if anyone has successfully done this with CF 10 and IIS 7.5 or 8.0?Thank you!Chuck Wyatt

Hello, everyone, I have an Oracle 10g database, and in it is a table where the first column is a VARCHAR 36 and contains Oracle generated UIDs. I am trying to run a SELECT query that gets a corresponding (date 19)  where the UID = '{ a 36 character long UID}'.  I am getting the  ORA-01722 invalid number error message. SELECT s.ENTERED_DATEFROM dsp.status sWHERE s.UID = '4a29d12025012995c231f18eb7704009'I've tried using TO_CHAR() and CAST() to no avail.  What am I missing? V/r, ^_^

We are upgrading from coldfusion 8 to 10. Internally we were using java function to to get the data. In java function we have a resultset object, if we assign this resultset value to Querytable variable, we are getting below error. This code was working fine in coldfusion 8.  Detail    This exception is usually caused by service startup failure. Check your server configuration. Message    The Runtime service is not available. StackTrace    coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available. at coldfusion.server.ServiceFactory.getRuntimeService(ServiceFactory.java:117) at coldfusion.runtime.RequestMonitor.<clinit>(RequestMonitor.java:14) at coldfusion.sql.QueryTable.populate(QueryTable.java:358) at coldfusion.sql.QueryTable.populate(QueryTable.java:283) at coldfusion.sql.QueryTable.<init>(QueryTable.java:96) at com.myCompany.myClass.myFunct(myClass.java:627) at   Here is t

According to http://activemq.apache.org/tomcat.html it is possible to "Manually integrating Tomcat and ActiveMQ".Since CF10 uses Tomcat, is it possible to embed ActiveMQ in CF10?  I use standard edition.Thanks you!

I need to be able to use a keyword entered by a user to do a full text search of a collection and then limit the outpout by parameters in a database.

Hi,Does anyone have the code (CFSCRIPT/CFML) to restart a CF10 instance?The code that worked for us in CF 7 and 8 no longer works on v10.Regards,Mark

I'm trying to write a webm dataURL to a file using CFFILE.  Do I use ToBase64 first and pass it to CFFILE output? I tried this but the resulting video file won't play.  It has a file size but won't play. I'm using Ajax to send the dataURL string to my ctc function.  How do I write a video to a file? The dataURL mime type is webm.<cfset vid64=#ToBase64(arguments.dataUrl)#><cffile action="write" output="#vid64#" file="#videopath#\#videoString#"> ThanksDon

I have a CF 10 report with an Excel Output format. One of my columns needs to stretch. When I set the Fromatting "Stretch with Over to True" and the Print Control "Position Type" to Floating and the "Stretch Type to Relative to Band Height" for all the fields on my detail I get an exxtra line in my excel output when there is an overflow condition. I am including an image of the output.What am I missing?Thanks