ColdFusion

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 ?

I am working on a system that signs customers up for workshops. Some of these workshops have limited capacity. The issue comes in that customers could run the same code simultaneously. Two customers could check capacity and find that room is available and the both sign up for the last avilable spot.One solution would be to put a cflock around the code that checks the capacity and adds the customer if there is room. The problem is that we run on multiple servers updating the same database. It would be possible for customers to similtaneously run the same code from different servers. This led me to thinking about using database locks but the way I understand CF data sources is that there is no way to ensure sequential queries go to the same database session. Since database locks are database session based this would make database locking not work.  Am I correct in that?The only way I can think of is to try to do it in a stored procedure and I would rather not. Does anyone have any o

I'm somewhat new and occasional to Cold Fusion, so I'm not familiar with the support process. The cfgrid tag appears to be broken, and I wonder how one might get Adobe to fix it.

We recently installed and configured a CF10 server on a 08 r2 box. After following the Adobe recommended setup (custom accounts for each of the services - iis, cf) in the lockdown guide and a reboot, cfm pages are no longer properly handled (redirected).The web server trace identifies this as the root problem:144. CALL_ISAPI_EXTENSION DllName[home_dir]\config\wsconfig\1\isapi_redirect.dllWarning145. -MODULE_SET_RESPONSE_ERROR_STATUS  ModuleNameIsapiModuleNotification128HttpStatus403HttpReasonForbiddenHttpSubStatus0ErrorCode0ConfigExceptionInfoNotificationEXECUTE_REQUEST_HANDLERErrorCodeThe operation completed successfully. (0x0)User from tokenNT AUTHORITY\IUSRWe've already made sure that exe rights are provided for the IUSR (as well as cf and iis) to both that .dll as well as the entire folder.We have also tried changing the handler mapping (invoke only if req is mapped to file/folder) as well as it's access config (none, script, exec).The only time we get a different error mesage

Hi, I looking on Best ColdFusion Development Company in India, Hyderabad. Could you please give me suggestion which company is best on it.

CF10/Win7Prox64I have a TemplatingService object.  It has it's processTemplate() function called and is passed 1 argument, a Request object which holds information about the request.The first thing it does is execute the controller in the Request object like so:<cfinclude template="#arguments.Request.getController()#" />This works perfectly, as the controller file is included and executed.  Well, I'd like that controller file to be able to call functions IN the TemplateService in order to modify things about itself, and though this is easily possible by writing:<cfset doSomeFunction( Request = arguments.Request, data=foo ) />Something about having to constantly self-reference the request bugs me.  I understand OOP and know that objects need to be passed, but is there ANY way you can think of where I could make the aforementioned call like:<cfset doSomething( data=foo ) />Which would look for a doSomething() function in the TemplateService object, but au

After a couple months of building a project with no real issues, all of a sudden my pages can no longer find my "ToolInvFunctions.cfc" file. I get this error,"The specified CFC ToolInvFunctions could not be found.The path to the CFC must be specified as a full path, or as a relative path from the current template, without the use of mappings."Like I said, everything has been working just fine until now and I have no idea what I may have done to start receiving this error. Here is the first line of code that fails with a call to the cfc file.<cfselect name="Tools"  bindonload="true" bind="cfc:ToolInvFunctions.findTools({ProcessIn})" display="RequestedTools" value="RequestedTools"></cfselect>All of this projects files reside in the same folder and have had no trouble finding each other until today.Please help, I imagine this is probably some sort of server issue, but I'm not experienced enough to diagnose.Thanks in advance

coldfusion 10 users logs off automatically from the tool after first activity everyday when they log in