coldfusion

Problem in IE with jQuery JSON append() to select control

The following code works fine in FF and Chrome, but not in IE8. I have 5 related category select boxes. The below code relates to selecting a category from the first select box. In IE8, I get a blank subcategory select box, after selecting a category. In Chrome and FF, I can browse through categories and subcategories normally CODE $...

coldfusion string comparison

I have a form that returns a list like this when submitted: 2009,9 I want to compare it to database pulled values but keep getting an error. <cfif #FORM.month# eq #qGetDates.year#,#qGetDates.month#> I know I probably have to cast it or convert it to a string for the comparison to work, how do I do this? Thanks, R. ...

Problem regarding invalid UTF-8 data

Hi I am facing a issue of invalid UTF-8 data in my application. Actually whenever i opens my application for editing purpose i get the following error: [Macromedia][Oracle JDBC Driver]Transliteration failed, reason: invalid UTF8 data Plz help me out to resolve this issue as soon as possible. ...

Best approach to remove special characters using ColdFusion and Microsoft SQL?

I want to remove all special characters (",/{}etc.) from an input field being saved as a string to the DB. What is the best approach? Should this check be tackled with JS, ColdFusion or Microsoft SQL - Maybe all three? How would I go about coding this using ColdFusion or Microsoft SQL? ...

different between cfstoredproc and cfquery

I've found previous programmers using cfstoredproc in our existing project about insert records into database. Just example he/she used like that: <cfstoredproc procedure="myProc" datasource="myDsn"> <cfprocparam type="In" cfsqltype="CF_SQL_CHAR" value="ppshein" dbvarname="username"> <cfprocparam type="In" cfsqltype="CF_SQL_CHA...

javscript-window and cfform

I have Parent page and a Child page('empW.cfm'),which is nothing but a popup window on one of the form fields on Parent page. I am using <cfform> in the Parent page. I want to populate the data from this Child-page-popup-window, to that related form field in Parent -page. Tried all means but no success till now. Parent page:- <script t...

How to handle Script Attack in application

We are facing issues of javascript getting embedded into message body, following is the code snippet of the javascript, } {*\htmltag241 var DanaShimData="var DSJsFuncs = ,null,,,,[{nm:\"Refresh\",lcnm:\"refresh\",flg:0xb},{nm:\ \"Install\",flg:0xf},{nm:\"writeln\",flg:0x3f},{nm:\ "GotoURL\ \",flg:0xe},{nm:\"AddRoot\",lcnm:\...

Trouble returning a query from a Coldfusion method call

Ok, I have instantiated an object and all is fine. I am able to call various methods of that object easily, such as myobject.getId(), myObject.getName() , etc etc. These examples all return either a string or numeric value. Now I have another method that returns a query. I've cfdumped what is returned by the method and it is indeed a qu...

assign value of form field as URL parameter

I need to take a user-entered value from a form-field and append it as a URL parameter when the user hits {ENTER} or clicks the submit button. I'm new to DreamWeaver CS5, and I have a project that I'm getting pressure to complete. ...

What is the correct sequence in which cflock releases when using multiple locks in different functions?

Given the following scenario, I would like to know if functionOneLock releases itself before functionTwoLock is triggered, or does it wait until functionTwoLock releases first? <!--- functionOne() ---> <cffunction name="functionOne"> <cflock name="functionOneLock" type="exclusive"> <!--- do something ---> <cfset functionTwo()> </c...

Cold Fusion Admin Login and Password recovery

I recently took over the development of a CF site and am having some trouble obtaining the login and password to the Admin for CF. I was hoping another StackOverflower may haave some insight on obtaining access. We have access to the FTP and any other hosting related details. Any helpful insight will be greatly appreciated. Thank you...

Coldfusion object inheritance sanity check needed

Hi folks, I need to know if I am going about something the right way. For a given page, I am instantiating an object for the page itself. Let's call that object myPage. Within the page I have containers (usually div tags). When I go to an admin component to work with a specific div, I instantiate an object for that as well. Let's call ...

MVC - Controller class tutorial

I am looking for a tutorial / book that guides me to understand the Controll functions and the best practices to write my own controller + Model Thanks in advance. ...

coldfusion onrequestend.cfm

Is there a way to make onrequestend.cfm call conditional. i.e if I call a template through ajax, I don't want that onrequestend.cfm should be executed on ajax requests. As in my case this is generating some header info like meta tags etc. ...

Object Oriented approach to retrieve data from two related tables using coldfusion

I have a test results database which has the following three tables along with others: testresults - id, buildid, osid, pass, fail build - id, build os - id, os I generated CFCs using the Adobe CFC generator that comes along with coldfusion builder. Now I have value objects for each table and CRUD methods. I am trying to retrieve all...

What security scripts/code do you add to your application.cfm?

I am working on redoing our company's code, and I want to have a clear, easy to read, and reasonably secure application.cfm. And no, we are not using application.cfc. So let's not discuss that please. Just want to know what scripts you would add for security. I am using coldfusion 8 standard, sql 2008. Here is one of the scripts I am...

Develop Coldfusion Web Service

Hello Everyone, I need to develop/design Coldfusion Web Service which uses few object calls and functions. What is good source of samples to develop in terms of OOP? What is best way to secure the web service? how to authenticate external/internal users, any sample? FYI, This web service is going to be used by multiple department. ...

Coldfusion cfchart stacked order

I have a couple of queries which pull data for use in a graph. <cfquery name='clusterPrivateReferrals' dbtype="query"> SELECT organisationName, count(messageID)*1000/listSize as msgCount FROM clusterReferrals WHERE datecreated>#refRateStartDate# AND refTypeID=3 GROUP BY organisationName, listSize </cfquery> <cfquery name='clusterNHSRe...

How do I replicate a webserver's directory listing functionality?

I am often tasked with making specialty websites for the professors at my university. Recently a professor asked me to create a site with nothing except links to files. I told him that would be easy because as long as the site didn't include an index all the file links would display automagically (yeah I did). To my dismay the univers...

Convert Coldfusion Error.DateTime to a normal format?

At my company we store the information gathered from our site wide error template, into the database, but because of the format of the error.datetime it is making hard for me to do any sql queries for different date ranges. Has anyone used some t-sql or coldfusion code to convert it to a mm/dd/yyyy format? Here is an example of the fo...