Questions

Change Default Connection Properties for SQL Server / ColdFusion 7 I've started working with indexed views in my Microsoft SQL Server 2005 database. Whenever a SQL statement alters a field ( INSERT, UPDATE, DELETE ) used by the index on an indexed view certain connection settings must be set. SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET CONCAT_NULL_YIELDS_NULL ON SET NUMERIC_ROUNDABORT OFF SET QUOTED_IDENTIFIER ON SET ARITHABORT ON When ColdFusion connects to SQL server the ARIHABORT setting is OFF causing SQL statements to fail. I currently have two workarounds for this: 1. Use a stored procedure created with the required settings. 2. Run a cfquery containing the required settings before the UPDATE, INSERT, or DELETE cfquery statement. Questions: 1. Is it possible to configure ColdFusion's connection to set ARITHABORT ON by default? 2. Does Microsoft's JDBC driver use this setting by default? My environment: Microsoft SQL Server 2005 ColdFusion 7.0.2 W

After trying to use a stand-along version of Adobe ColdFusion Builder 2 (built on Eclipse) that was slow as molasses I am, instead, trying to run CFB as a plug-in to a standard Eclipse installation.  So far so good.  However....I have a Logitech mouse with a ton of buttons I've customized with Logitech's SetPoint to perform common tasks such as Copy, Cut, Paste, Undo, etc....These buttons are not working in Eclipse.  I've tried messing around in the key mapping areas but it doesn't appear as if the key commands are being sent in from the mouse at all.Here's the oddity: When I was using CFB as a stand-along install these buttons were working.  Now, as a plug-in to Eclipse they are not.Is there a setting somewhere in Eclipse to allow key commands from external apps like Logitech SetPoint?

So, you do the research on how to get a CFGRID to update via SQL update because there isn't much control in the CFGRIDUPDATE function.   You follow the online assistance and still get: Complex object types cannot be converted to simple values.Here is the code, can someone help a guy out?  What am I missing?<cfif IsDefined('form.evalgrid.rowstatus.action')><cfloop index="i" from="1" to="#ArrayLen(form.evalgrid.rowstatus.action)#"><cfquery name="updatevaluations" datasource="abcde">UPDATE evaluationsSET pridefslascore = '#form.evalgrid.pridefslascore#'WHERE evaluationid = #form.evalgrid.original.evaluationid#</cfquery></cfloop></cfif>Forever thankful for a solution.B.

http://leaguemanager.playerspace.com/json.cfm?json_type=league_roster&league=73&requesttimeout=99999&return_script=%2Fmanager_pro.cfm%2Fleague%2F73%2Faction%2Fmanageusers%2Fcontent_action%2Fleague_rosterThe page seems to just output half the intended data. Sometimes, if I refresh it, I can get it to output completely, but usually it just reaches a point and stops displaying and the loading circle in the browser disappears.Any ideas why?This is an AWS load balanced CF10 Server running Windows Server 2008

I have a file that queries orders and writes them out in xml to be polled by some software that reads the order into an erp system. It reads fine but I can't parse an xml reponse that will update order status with xmlParse , it throws an error. I get the software response xml with GetHTTPRequestData().content fine. I just can't do anything with it there. As soon as I add xmlParse it errors out. I can write out the response to a seperate file and work on it there , but it get's overriden on the next iteration.I'm looking for an alternate solution. Is there any way to create some code to "catch" the xml in the seperate file I write or post it to ,  but not have the the code that will update my status table overwritten each time the request is sent? This is not a web service , just plain xml with http post 's.Tks.

Hi,We have a ColdFusion (9.01) application deployed under WebSphere 7.  There are some application credentials stored in a J2C alias that was configured using the WAS console.  I would like to know if there is any way I can retrieve those credentials programmatically using ColdFusion.I found an example of how to retrieve them using Java which is currently not an option but I was wondering if the underlying objects can be accessed from CF.Here is the Java example:public static javax.resource.spi.security.PasswordCredential getJ2CData(String j2cAlias) throws Exception {         String methodName = "getJ2CData";         javax.resource.spi.security.PasswordCredential result = null;         try {             // ----------WAS 6 change -------------         &nbs

I'll try to make it simple, but ask any questions if I need to explain further.I have a situation where fields in the database are datatype decimal.  Some of these datatype fields are NULL, which is good.When other non-decimal datatype fields in the CFGRID are updated but the datatype decimal fields are not updated it is not passing NULL to the CFGRIDUPDATE.  It appears that it is passing the following:   ,,,,,,  With no single quotes around each individual variable and even though that would appear to be NULL to me and there were no updates, it causes the error:  Invalid data '' for CFSQLTYPE CF_SQL_DECIMAL.  And yes, "Allow NULLS" is checked in the Database.Here is an example of the source code after the CFGRID is submitted to the CFGRIDUPDATEs.  You can see that after 'CI' there are a lot of commas and no values because no values were entered but they are not recognized as NULL.  [4063,'A053965','13-14     ','','','134

I have a form with a calendar at the top, below it is a list of items each with a check box. Here is a wonderful visual of it - CalendarCheckbox | Col | Col | ColCheckbox | Col | Col | ColCheckbox | Col | Col | ColI want it so you select the date and it gets passed into the database in the same row as the one (definitely one, multiple is better) that has been checked by the user.I was trying an INSERT INTO with a WHERE statement but apparently you can't do that. So if I can use a WHERE with INSERT INTO, how can I identify which row to insert the info? Currently it is passing the dates but it creates a new row.I didn't think posting the code is neccisary for this question but if anyone wants to see it let me know and I will post it. THANKS!

If you read an XML file from another site like this:<cfset myDoc=XMLParse("http://72.250.245.94/videoshare")><cfdump var = "#myDoc#">the UTF-8 coding won't be handled correctly, and you will have unexpected characters when you display the XML data.If you read the XML file like this:<cfhttp     url = "http://72.250.245.94/videoshare"    charset = "UTF-8"    result = "rawdoc">    <cfset myDoc=XMLParse(#rawDoc.filecontent#)><cfdump var = "#myDoc#">The data will display as expected.

Hi - I was trying to use CFContent to serve a PDF .  It worked fine in Firefox but not in IE 8.The problem turned out to be this code in our application.cfm (which we include alot)<!---prevents back button from keeping user logged in ---><!--- Do not use when serving files using CFCONTENT --- it breaks IE ---><cfheader name="Pragma" value="no-cache"><cfheader name="Expires" value="0"><cfheader name="cache-control" value="no-cache, no-store, must-revalidate, max-age=0">Simply using this code worked:<cfheader name="Content-Disposition" value="inline;myStatement.pdf"> <cfcontent type="application/pdf" file="#fullFileAndPath#" reset="yes"> I just thought I'd share this in case it helps others.

<cfset mystring ="Jonh, Doe"><cfset TheText = replace(mystring, ',', '<br>' , "ALL")><cfdump var="#TheText#">why the results shows Jonh<br>Doe instead of JohnDoCan anyone pls help?Thanks

On two occasions, someone has managed to insert what appears to be malware code into one of my includes.   I won't post the actual code, but it consists of a CFHTTP tag that references an IP address, and a CFOUTPUT tag that outputs the value of the CFHTTP.   The site is not tied to a database, we only use CFINCLUDEs to simplify global edits (we're relatively new to ColdFusion).  The site is hosted by one of Adobe's recommended CF hosting services.   Any thoughts on how someone could be adding this code and what we can do to stop them?

ColdFusion 10 Security Lockdown Guide is currently written for Windows 2008.  Are there plans to update the document for Windows 2012?Will the new release of ColdFusion Splendor have a Security Lockdown Guide written for Windows 2012?

HelloThere are several methods to do this out there, not one has worked for me. First, configuring SQL Server by enabling TCIP connectionsSetting IP1 & IP2 Address to 127.0.0.1setting all TCP Ports to 1433 (IP1 through IP7) Leave all TCP Dynamic Ports blankenable Named Pipesrestart SQL ServerThen in Studio:Security tab under the DB you want to connect tocreate a new usergive user a user name and login namedefault Schema- dboThen in CF Admin:Server: 127.0.0.1Port: 1433User Name: login name from aboveConnection verification failed for data source: appraiseriLOCAL java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Nu-PC\Nu'. The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Nu-PC\Nu'.Any help with this will prevent more hair-pulling.Thanks

Hi there,I've an <a href="a">A</a> and <a href="b">B</a>.  I want to know which letter user cliked on so that I can run a database query. How can I do this. Any ideas?ThanksJoe Green

I work with PS CS6 and sometimes when I use the dodge tool (o) the program locks up and I have to force the program of and then begin alla over again. It has never happened to me before. (before CS6) Whats the problem?

Cfcompile trashes my templates, using the syntax of in a DOS window:c:/coldfusion9/bin>cfcompile -deploy C:\coldfusion9\wwwroot C:\ColdFusion9\wwwroot\filestocompile C:\ColdFusion9\wwwroot\filescompiledTemplates compiled no problem in cf7, but both my cf8 and cf9 trash them. When I load them to localhost:8500 to view them, the hash is visible all over the page, looks like hacker-work.Running cf9 on xpsp3 with jre 7 and cssNE1 have ne ideas?  Sure would appreciate some help.  Thank you.

I have the following query that looks up customer accounts:SELECT    ACCOUNT_ID, SUBSCRIBER_ID, PKG_CODE    FROM   Accounts    WHERE  ACCOUNT_DESC LIKE '%Eye%'    GROUP BY  ACCOUNT_IDWhich gives me the following result.. 1. ACCOUNT_ID,  SUBSCRIBER_ID, PKG_CODE  2. ---------- -------------- -------    3. 11016869,    10016598,      N  4. 11015922,    10015713,      N  5. 11015062,    10014878,      N  6. 11018312,    10017973,      Y  7. 11018310,    10017973,      N  8. 11018309,    10017973,      N  9. 11018308,    10017973,      NQuestion: How do I display a "1" in a Fla

Getting this message when installing the package."Adobe ColdFusion 10" can't be opened because it is from an unidentified developer.Is there a workaround?

So I have these Service Objects that are instantiated during onApplicationStart().  During the onRequestStart(), I make a pointer in the variables scope to each, so they can just be called by their name (cause 'UserService') is the same as ('variables.UserService') and the latter takes less to type. GO TEAM CODE PRETTY-FICATION!Anyways, during the processing of the Request, I'm finding I have to pass (as a reference) the entire variables scope to all my functions, just in case they have need of a Service.  Heck, I have a Config object that holds the application's configuration settings, so if a method needs to know the path to the controller's folder, it needs to be able to get to the variables scope where I stored my Objects.But with all this object passing, I feel I'm not doing this in the most optimal way.From the application.cfc point of view, the variables scope has those objects in it.  But after code in the application cfc does some includes of files which might i

Ok, so for the past 20 years I have been storing all my code and graphic files in three places:My Working Files & Folders on a local drive - mostly current projects.An Archive of all my code files, imports and projects on a Windows Server in huge drives.A copy of the archive on multiple external USB Drives (for off site keeping)The problem is that of the past two decades I have changed the way I manage file folders and store  projects, these backups have all been (for the most part) manual and as we all know that it doesn't take long for you to forget a project or two and then you have a huge fricken mess on your hands.I need to get things consolidated so that I can get my RAID installed and then get my backup off the USB drives and into the cloud.So what I am trying to do is start with my two archives - but there are tens of thousands of files to deal with and manually going through each could takes months if not longer. While for the most part file names are going to be the

Hi there!  We are running a CF8 Enterpsise on an older root Server (virtuozzo VM) and we need to switch to another provider (vmWare VM).We will probably need more then one month for the migration and I need to come up with a migration plan that doesn't involve rendering the service unavailable.I've tried to contact Adobe hotline, but the people there knew nothing about licensing, the other number I got from them kicks me after 20 minutes on hold... so I was hoping to be able to find answers here.  I understand CF Enterprise is licensed for 2 CPUs, for unlimited number of virtual machines, so the other server wouldn't qualify to run on the same license key because it's different 2 CPUs. If I could migrate everything within a month then I could use the 30 day demo license, but I will need more then 30 days.So what are my options? Even if I wanted to buy CF8 Standard to cover the second server while migrating (am not really willing to pay $$$ just to cover few weeks of migration

So correct me if I'm wrong.  I have a file structure that looks like this:models> framework>> alpha.cfcapplication.cfcI am executing from application.cfc.  In it, I have created a mapping (NOTE THE DIFFERENCE IN SINGULAR/PLURAL):<cfset this.mappings[ '/model' ] = expandPath( '/models/framework' ) />When I dump the this.mappings structure, I expectedly get:c:\path\to\webroot\models\frameworkSo I now dump this code:<cfdump var="#fileExists( expandPath( '/model/alpha.cfc' ) )#" />And sure, enough, I get: YESSo here's my problem.  I had always thought that in dot notation syntax, ColdFusion looked at the first value provided and did a mapping check on it.  However, when I run:<cfset myNewAlpha = new model.alpha() />I get a message saying the CFC cannot be found.  Only by typing the following:<cfset myNewAlpha = new '/model.alpha'() />Does it actually work and find the CFC through dot notation my using the this-scope mapping.So, is t

I've tried setting up RESTful web services in ColdFusion10 and found that it only works uder the CF web root, but not IIS web root. Does anyone have a solution for having this set up under the IIS web root?

how to generate a csv report to determine paper size in a pdf or pdf/a file ?