ColdFusion

As an CF server administrator ,  how can I give read only access to users for datasources and scheduled tasks?

I want to move data from one column to another. I thought I could just query points2 column then use a cfloop to update the data to points1 column. Finally null out points2 column. Below is my code on the first 2 steps. Unfortunately, I get the following error: Syntax error in UPDATE statement.The error occurred in wwwroot\forms\changepoints.cfm Line 18 <cfquery name="getPoints" datasource="#dsn2#">SELECT leaderID, points2from leaderboard</cfquery><cfloop query="getPoints" startrow=1 >   <CFQUERY NAME="DoUpdate" DATASOURCE="#dsn2#">       UPDATE leaderboard       SET points1=#getPoints.points2#       WHERE leaderID=#getPoints.leaderID#    (line 18)    </CFQUERY></cfloop>What am I doing wrong?

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

Hi,I have a portal webiste with banner and texts advertising . the advertisers want to know the statistics of the clicks to their website. I searched Google Analytics, coudln't find it. it said I should use a Java script code within the links, to make it work. I am not a Java script propgrammer.Does anyone have experience in this area?  any help is greatly appreciated.

Hi,I have a function that takes in a raw xml and covert to query.  The problem is any leading zeroes are gone.  For example, 000123 will become 123.  Is there any way or function in CF that will stop from removing leading zeroes?Thanks,

Environment ... WIndows 2000 server SP 4 (test environment) ... has CF7.0  installed already.  Trying to install CF10 over it. Get error message Microsoft VC++ 2008 Runtime. Redistributable Package is not installed.  Click OK, watch it install.  Over and over, reboot; always get same error message.  Ok, what causes that? Help!  Please.

I installed the devloper edition of CF10 on OSX 10.7.2 and the automatic updates function is not working. I can see the updates, click on Download and Install, then click Continue but nothing happens. Same with the Download button.Also get the following error when logging in to the CF admin:Error invoking CFC /CFIDE/administrator/updates/download.cfc : WDDX packet parse error at line 1, column 1. Content is not allowed in prolog.. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]Any help would be appreciated.

I have a basic count select statment that pulls back the top occurances of a certain pid in a table.  I am trying to join that table with another table to pull back the details about that pid but I can't seem to get it to work.  Would it be better to use union.This is my existing querySELECTpid, COUNT(pid) AS pcountFROM Table1GROUP BY pidORDER BY pcount DESCThe basic structure doesn't work..SELECT Table2.name, Table1.pid, COUNT(pid) AS pcountFROM Table1, Table2WHERE Table1.pid = Table2.pidGROUP BY propertyidORDER BY pcount DESCDoes anyone have advice on how to strutcure this... a certain join or a union.  It could be a LOT of records so I don't want to start this with the wrong structure. Thank you!This is ColdFusion 10 on MS SQL

ColdFusion 10 update 4 is now available for install. Important fixes + resolves issues with update 3. For details, read this post on the ColdFusion blog : http://t.co/IH91v6au

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WS5FFD2854-7F18-43ea-B383-161E007CE0D1.html

I can not find the CF10 metrics logs. Reference:http://www.adobe.com/devnet/coldfusion/articles/coldfusion-tomcat.htmlSays in part:Logging mechanism in ColdFusion 10ColdFusion 10 logs Tomcat metrics to metrics.logI can not find the metrics log on the file system or CFadmin web page. Is there some way of enabling the CF10 metrics logging as there was with older CF7 8 9 versions to enable jrun metrics logging? eg: http://helpx.adobe.com/coldfusion/kb/enable-metrics-logging-coldfusion-mx.html As always thanks, Carl.

I was wondering if someone knew the best way to write a query to pull back rows where a table field is found in a a variable string.  I'm using Cold Fusion 10 on Microsoft SQL Server.The table has a series of fields such as carcode          carnameG                GarageC                CarportA               AttachedD               DetachedAnd another query pulls back a field that stores as text all the abbreviations that apply I want to pull back all the carnames that would match the abbreviations stored in that field.  I thought I could use a contains line but that does not work.  How do I pull back matches against a variable string... I t

In this simple component (test.cfc):component {      VARIABLES.obj = {};     VARIABLES.obj.foo = "bar";     VARIABLES.obj['foo2'] = "bart";    remote function func1() {        return VARIABLES.obj;    } }The response from the URL “/test.cfc?method=func1&returnformat=json” looks like this: { foo2: "bart",FOO: "bar"}Note that if you declare the property of a structure with dot notation, it is returned in uppercase. Using array like declarations returns it as you specified.This is still apparent when dumping a structure in a page, but is more of a problem when accessing the results via JSON in a Javascript appliation, as this is case sensitive.Pete

How can i implement Previous week / Next Week, like previous n / next n records?Can you please send me links for implmentation code or help me implement?. Please help.thank you.Previous / Next n Recordshttp://tutorial20.easycfm.com/index.cfm?fuseaction=tutorial&tutorialID=20http://tutorial20.easycfm.com/

Have spent all day trying to get Cofldfusion (64) running on 64bit Windows Server 2008 R2 to talk to our Oracle 11 DBHave added the latest vesions of the Jar files belowclasses12.jarorai18n.jarojdbc6.jarUsing JDBC URL: jdbc:oracle:thin:@//192.168.1.xx:xxxx/yyyDriver Class: oracle.jdbc.driver.OracleDriverDriver Name: Oracle Thin DriverValidate Connection: Not enabled. But getting the following.Connection verification failed for data source: Maginusjava.lang.AbstractMethodError: nullThe root cause was that: java.lang.AbstractMethodErrorCan anyone help?

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-750b.html

Hi Everyone,I'm having some problems trying to configure CF Builder 2.1 for a local ISS server on Windows 7. When adding a server a receive the following error message:[localhost]:Error(11/02 at 09:28:49) Unable to authenticate on RDS server using current security information.This would seem as though my either my username/password for RDS are incorrent, however I've checked at everything seems to be ok.My settings are as follows:General SettingsServer Name: localhostDescription: N/AApplication Server: CF+Tomcat BundleHost Name: localhost"Is local" radio button is selectedWebServer Port is 80Local Server SettingsServer Home: c:/inetpubDocument Root: C:\inetpub\wwwroot*I am unable to select a version of CF - the field is blanked outShould I be disabling RDS? I am also installing for local dev so there is no need for it anyway.I'm a newbie to CF so I'm pretty sure it's something simple I am doing wrong. Any help is greatly appreciated.Thanks,bigscreentv

I have a routine that I can run straight up and it will return a list (pipe-delimited) of 1278 results.I put it in a function in the same program and I get 1278 results.I put it in a function in its own CFC and I get 279 results.Anyone ever experienced something like this?  I'm sure I'm screwing up somewhere, but this is quite odd. May have to switch to structure or something to test it in another way.ColdFusion 8 on Windows server 2003.RLS

I was trying to run a validation software within our company's website that was developed using coldfusion. The website renders perfectly but it fails verification. This is the following error i get. This link is broken. The SRC or HREF is an empty stringHREF=”” or SRC=”” can cause unexpected effects such as traffic spikes or cookie corruption. The code affected is: <a href="" onClick="window.open('#to_root#debug_mode.cfm?height=400,width=500,scrollbars=yes');return false;" target="_top" class="globalNavButton">Debug</a>I have tried to add a # sign to the href target, but that brought an error to the website and the page would not render. Would anyone be able to assist on how to bypass this issue? Thank you

G’dayI’m sure I’ve asked this before, but I cannot find the thread.  And I’m pretty sure I never got an answer.  Sorry for the repetition.Is there any way of disabling CFB’s "ColdFusion Search" dialogue (the one one gest when pressing CTRL-F), and just use Eclipse’s default Find/Replace one?Cheers.-- Adam

Attempting to use SQL Editor window.The window comes up, but there are no datasources to chose from. Also   when writting a query in <cfquery datasource="MySource">I dont get any intellisense help in writing querys...The querys that I do write work well.I do have a local server , localhost, created.  The web port that I am using is 80,   same as the IIS port..  Dont assume that I installed anything correctly, so any help on how to track down this problem, and start actually using the too would be appreciated..Larry

I am useing       <cfheader name="Content-Disposition" value="attachment; filename=myfilename.xls"><cfcontent type="application/vnd.msexcel" reset="no"  >  to get a file in .XLS fromat.This is working fine in DEV environment.But on PROD which is secure one, uses SSL, and not working. A pop-up window comes and immediately closes and wont generate .xls file.Please help

Hello, I’m very new to coldfusion and I’m trying to modify the existing form. Here is my requirement… I have two dropdown boxes, based on the first drop down box, I like to fill the box two.  Table Emp,EmployeeNbr, EmployeeName1,John2,David3,VicTable Dep,EmployeeNbr, DepNbr,DepName1, 1, Wine1,2,HP1,3,IBM2,1,Phone2,2,Mouse3,1,Cable…I will be using the cfquery to populate the dropdown box1, If user select the employee nbr2 in drop down box1 I like to display depends records in dropdown box 2. Please guide to code this. Thanks

I have many CF apps running under a single version of apache.  I need to pull them out one by one and upgrade apache for each one.  I am running CF8 want to be able to run 2 different versions of apache, (http-2.0.63 and http-2.2.22). First is is possible to run CF with 2 different versions of apache? Second  can I just do something as simple as  edit  files in /data/cf8/servers/cfusion/cfusion-ear/cfusion-war/cfdocs/htmldocs  to add mod_jrun22.so? Sorry but I'm a CF noob admin.

Is it possible to use pass through / integrated authentication using the application users windows account (rather than the service account) when a Coldfusion application connects to an MS SQL DB?For background, we are running:ColdFusion 9,0,1,274733 hosted on a Windows 2008 R2 (64) serverSQL server 2008 R2 hosted on a Windows 2008 R2 (64) serverIE 8 and/or 9 as the client browser I have an intranet application that is used only by users within our AD domain. I have no problem getting ColdFusion to connect to the SQL database using the ColdFusion service account, but ideally we would like the connection to be made under the application user's account.I would appreciate any guidance on how to achieve this if it is possible?(I am not a webmanager/developer and so my ColdFusion knowledge is very limited!)Thanks in advance,Darren