Top Solutions

This coldfusion/MySQL query is driving me crazy. It just won't return the month of september's values from 2007. The column 'trading_data_values.TDVdate' contains several entries for sept with the date in the form '2007-09-20'.

<cfquery...

Hello,

I need to select a number of records using a query. The records have to have an eventDate that is greater than today's date to be selected.

How do I do a query that will do that? I have tried the attached snippet but it doesn't seem...

Hi there,

I try to put one or several photo in a row of a jqgrid  (http://www.trirand.com/blog/).

Here is my source

<BEA-101017> <[weblogic.servlet.internal.WebAppServletContext@1f3f158 - appName:'myApp'
name: myWeb', context-path: '/myWeb'] Root cause of ServletException.
java.lang.InternalError: name is too long to represent
      at...

I need to do a character replace on a string
I need to turn + into _
and I need to turn / into ~
And = into *

Something like
 <cfset TheStringPlus = REReplace(TheString,"+","_","ALL")>

But this doesn't seem to work for special...

AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope

                                    

I have been working on this for hours and can't work it out.  You can find reference to the webserver documentation at http://help.cj.com/en/web_services/web_services.htm "click "Real time commission report" then "real time commission service". ...

I will have a google map with one pin with a lat and long.  I want to draw a circle around that pin depending on a kilometer value (radius) entered by the user/member.  I use cold fusion/ sqle server .and the google map api

The circle would...

I am working with coldfusion and the FCKEditor. How do i grab focus on the text area of the FCKEditor? Please take a look at the simplified cf code attached. When i click the button to grab focus on the text area, i get the following js error:
...

Hi, I'm getting the following error messge. in the coldfusion application.
-----------------------------------------------------------------------------------
Element STATUSCODE is undefined in GET_USER_VENDORS.    
The error occurred in...

I want to use RANDRANGE to generate a four digit number anywhere from 0001 to 9999. The problem is that the resultant number ends up less than four digits because, as an example, 0500 is reduced to 500 when displayed to the user as a variable and...

I have just finished upgrading our entire Intranet application to CF8. The upgrade went well, and all is working as it should. However, I've recently started diving into some of the new Ajax capabilities that have been introduced (updated) into...

How do I strip out all the invalid characters from a textarea input?
I want to allow ASCII characters 32 - 122 except for a few exceptions, such as the apostrophe and the quote.

Hello experts,

I'm trying to create an application in coldfusion that would read a pdf file, break it up into individual files and then move all those files to a separate location. I'm trying to use iText to do the pdf reading part and this is...

I'm building a function to call the Google DistanceMatrix API and return the distance between two zipcodes.  I have the information returning in XML and am able to display it via a cfdump tag. I am trying to grab the distance in miles. However, I...

Hello Experts,

Well, I am at my wit's end, and am so hoping someone will be able to help. I bought a new Dell laptop system about 2 months ago. It is Windows 7 Professional 64-bit with IIS 7.5. I managed to install CF 9 64-bit Developer...

The section I am working on is similar to the structure of the referring question.  The section lists the videos that the employees possibly have seen take a test on.  Currently I have all the videos listed no matter what employee is selected.  I...

Hi. I need a way to encrypt credit card information in a database table. Then decrypt it to display on a password protected "control panel" page that only a privileged client ever sees.

Summary: I need to encrypt CC information (CC number and...

I have used the code below to add a new bar to the bottom of the grid. This gives the user some good information about the records. I want to start to use some of the editable grids that allow records to be inserted and deleted. This works great...

Coldfusion code with MS SQL back end.

My question is how do make my dorp down list dynamic.

My first drop down has a query= "qQuestTypes". Table name "tCLETestType" The primary key is qTypeID and qType as a coulmn name for the product name....

Hello. My SQL Server 2005 database is under a SQL Injection attack.

The attack finds the column that comes after the Primary Key in each table, and erases that column and populates it with:

</title><script...

Hello,

i can't seem to retreive any data from my dataTables using ColdFusion.

This is the JSON datasource:
 

This is the table HTML/jQuery
 

We have this page that we are running nightly.  I can't get the email to fire off if there is an error..

I am atteping to invoke a webservice:
My code i am using to invoke the websrvice is located below.
 I am recieving this error message: Unable to parse WSDL as an XML document.  

This is the instructions:
Access
Web Service
The endpoint...

I am running a script to upload about 50,000 lines into my DB with Coldfusion and after 2 mintues or so I get this error:

 The request has exceeded the allowable time limit Tag: CFQUERY

How can I fix this ?

I am using jquery validate engine the validation seems to be worrking
But when I click on the submit button my page does not get redirected.

Also if when I click on submit the error messages do not validate

  <script>

           

 ...

I'm using CF8 (although I had this problem in CF7 as well). I have the only hotfix installed.

When I use CFDocument, the header and footer are smaller in scale than the body.

Here is example code:

<cfdocument format="pdf">...

I have a table that I am dynamically adding rows to using javascript, in this row I need to add a cell with a checkbox control.  I'm able to create the checkbox fine but I cannot figure out how to make it checked when it's rendered.  Here's the...

Hi.

Can someone help me with a SQL Server 2005 problem?

I am getting this error in my ColdFusion application:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.   The...

in the following code, I am getting an error that form is undefined when I click the links in the bottom table, the checkboxes work just fine, but the <a href="#"> tags wont submit the form. Why?

<cfparam name="form.sort"             default="">...

Hello,

We're creating a dynamic application where the layout and fields are being generated by the database.
The application contains autosuggests and datefields. I've added the  <CFAJAXIMPORT TAGS="cflayout-tab,cfform"> to the main page but...

I'm trying to copy files from one server to another.  I'm using ColdFusion.  I have a CFM page set up that reads (and outputs the info to the screen so I can see it)  the files from a particular directory using CFDIRECTORY and filters the list to...

Hi experts,

I found a related question about converting from string to ascii, and Jones911 said something about how this could be modified to convert to hex, but I played with it and didn't get it.  so this is the code for string to ascii, can...

I'm trying to reload a page in firefox if user hits the back key.  The page contains a form (which includes sensative data).  

I've tried the following (placed in the <head></head> tags) with no joy.  If found several posts, but no clear...

OK - I've stared at this too long.  I've been around CF forever, but just now getting into a new territory with an XML project.
I don't have control over the returned format of a request.  Here is an example of what is being returned as the XML...

CF9
MS SQL Server 2005

Hi. I've been reading up on cfspreadsheet in the Forta CFWACK9 book and on the adobe.com site. I am trying to use cfspreadsheet to write a new MS Excel file.

The code, below, does generate a spreadsheet, and I can...

I would like to know how to import xlsx and if there is a tag that someone has to import this. We currently import xls without any issues, but need to support xlsx to support the additional rows in Excel 2007.
Does anyone have an example or tag...

I have a page that consumes a .NET web service and am trying to replace a couple of characters that are coming down in one of the fields with their HTML equivalents.

Here's the gist of it:

<cfset newdescription =...

We are using CF 9 Enterprise on a Windows 2008 server and we are seeing a lot of "Exception reading response" errors in our mail logs. Can anyone tell me what this means and how to correct it? Below is the complete error:
...

We have a server that is running Microsoft Dynamics, which offers some web services. I am trying to use CF9 on a different server to send a request to a web service on the Dynamics box. I can view the WSDL in my browser using my login...

Hi,

I have a coldfusion 9 file that is accessed via jquery ajax call. It does some db processing and then sends the output to a cfc called json.cfc which serializes and deserializes and returns output as json. I then use $.parseJSON to parse...

We just reinstalled ColdFusion MX7 on a Windows 2000 server. This machine used to have an old version ColdFusion MX 6 on it, but that has been uninstalled. There seem to be remenants from the uninstallation left on the machine, but the MX version...

Does anyone know of a way to convert a pubdate from an RSS feed to a ColdFusion Date and Time?

An example date I have is "2010-10-15T11:58:00+11:00"

Have looked everywhere but can't find anything on this.

Many Thanks.

I'm using the new CFLAYOUT tool with tabs.

i have 2 significant problems.

Every time I modify an item on one of the tabs, I get a javascript error.
    ("Error processing JavaScript in markup for element cf_layoutarea1200957169825: [Enable...

I  am running coldfusion 9 on one server and SQL 2008 on another server.
They are in production environment.

I recently began getting all kinds of connection errors :
I am getting these in 5 or 10 minute bursts. Everything went for A OK  to...

I am posting a form via ColdFusion.navigate which loads a .cfm page with a table and data into a div beneath the form.

I want to apply the jQuery dataTable plugin to this table (http://datatables.net/).

The problem I am running into is...

Why does SiteMinder provides value of SM_USER using GetHttpRequestData() function in CF 5, Not in CF 7 or CF 8?
The same code is used from the asp and the cfm templates on both servers.

What scopes are avaiable inside a cfdiv?  I can dump attributes and url and see that my data is there but I get an error that XXXX is undefined in attributes.  I understand I can't change some scope values from inside a cfdiv, but I thought I...

I have a page where I'm using a JQuery plugin to do a pagination system and also I have fancybox with when the user click on the image.

The problem is that when I click on the 2nd page or 3rd etc... the Fancybox does not work why is that?
...

Hello experts.
I want to use the jquery modal and in the pop up window the google maps .
I downloaded the google maps code with the reverse geocoding tutorial from here:
http://code.google.com/intl/el-GR/apis/maps/documentation/services.html....

Any ideas?

all my solutions are being blocked by IE and FF popup blockers.

Hello, I am using cffeed to create RSS feeds. However, for the description, I want to wrap the text in a CDATA block.  When I try to use this:

<cfset rssStruct.item[currentRow].description.value = '<![CDATA[' & #text # ']]' />

it doesn't...

Hi,
Can someone tell me why this does not work 25% of the time:

<cfheader name="Content-disposition" value="attachment; filename=""#fn#""">
<cfcontent type = "#filetype#" file = "#fn#">
<cfcatch type="any">
<cfLocation...

ColdFusion 9
MS SQL Server 2005

Hi. I've been reading documentation to find a clear answer, but I have not met with success. I want to limit to 255 the number of characters entered in my cftextarea field. But ColdFusion disregards the...

Hello experts.
I'm using cf server language but i need help to set a session values(userid) in php for a plugin (cometchat) that is written in php.
Cometchat can use a cookie value to handle the online users but i think that it will work better...

I'm  using the new CF9 cffileupload tag.  When I test it, the little progress bars turn green and the files that were uploaded appear via the script I copied from another post on this site. I have a resulting page because it says I need one, but...

I need to bind the selection of a query built cfselect to a text box.

Client Name:<cfselect name="toname" query="qindivs" display="Iname2" selected="#QGetSurveyInfo.Iname#" value="Iname3">            </cfselect>
Client Email:
<cfinput...

I use the standard google java script api:
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"> </script>
 to poplulate a map of global housesits  from my database.  See:...

I need help getting this code to work. I want to dynamically populate a the select options for the select list using Coldfusion 8 and JQuery to perform the Ajax call. Below is the code that I have written but it does not return the...

Hi,
I am having an issue here. I've a list which works fine when there's no null value. for example:

 

and the result shows: GetAt: 2. I need to print all the values including NULL values. any help would be deeply appreciated...

Hello,
I recently leased a dedicated server from godaddy.com.
It is a Linux 32-bit running CentOS5, and I am using the Plesk Control Panel.
Apache and MySQL are already running on the machine.

I am developing on a MacBook pro and using the...

Hi there,

I need to decompile a .cfm file (ColdFusion 9) to make changes to it, but i lost my backup files and i have no way of editing my current .cfm file. Is there a way to do this?

I greatly appreciate the help.

I'm seeing a behavior in the coldfusion cfquery that I'd like to find an exmplanation for .  I've got a query that does a subquery in the select portion and if I have multiple where lines, I get an "invalid column name" message for my second...

We need code that changes Latitude/Longitude coordinates into MGRS (Military Grid Reference System) Coordinates. It can be Java, JavaScript, CF Script, or anything ColdFusion can take in and interpret. We are building military solution that when...

I have a CF search function using <cfcollection> which takes a query object as one of the arguments.
Before i run the function, i want to remove all of the duplicates from my query.

but , using  "Select Distinct" in a CF QofQ, I only...

The result of encrypt(myText, key, "BLOWFISH", "HEX") gives you a value that you can decrypt just fine in coldfusion, but not the same value as you would get if you ran the same encryption (blowfish, hex) using PHP.  Basically I need to encrypt...

Hi,

In IE, when I press F5 refresh causes error "To display the webpage again, Internet Explorer needs to resend the information you've previously submitted."

I’m coding in coldfusion 5.  However, I’ve searched the internet and it seems...

<cfajaxproxy cfc="cfc/code" jsclassname="cfcCode" />

The specified CFC cfc/code 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.  

...

We are installing 64bit ColdFusion 8 in MultiServer Mode on a Centos 5.5 64bit machine, with apache 2.2.3 and have run into an issue with apache permissions.

We are currently experiencing permission issues on the CF Apache extension and it is...

I am not able to implement gridpanel, Ext.ux.grid.LockingColumnModel  using coldfusion
I know about coldfusion.grid.getobjectgrid , setrerender but this works with ext.grid not ext.gridpanel.
I do have dynamically generated columns in...

Need help finding a way to submit an anchor LINK or FORM so my JavaScript message will display correctly and at the correct place without having to resort to using css absolute positioning.

 My test code needs to go inside a table which I...

user clicks on browser upload button, the explorer window appears.   is there any way I can only show certain file types in this window, jpg, png etc? , like what you see in Photoshop?
 
PS I know I can check via the cf file upload tag for...

Hi experts!  

Server 2008 R2 Enterprise
ColdFusion 8 Enterprise configured as a multiple server with JRUN4
Helicon ISAPI Rewrite

I have an ISAPI rewrite (helicontech.com) rule that's redirecting requests in this form:
...

After updating to CF 9.0.1 my users keep getting the following error....

Detail: [empty string]
ErrorContext: WDDX packet parse error at line 1, column 1.
Message: WDDX packet parse error at line 1, column 1. Content is not allowed in...

I have a CFGRID that displays an employee phone directory on a company intranet.
I want the user to be able to click on a row showing an employee's name and number, when clicking on the row a window will appear and show  the user the details of...

I need the ability to preserve single and double quotes that are entered in a textarea to be submitted into a SQL 2000 database. Please see my code below. It's not working properly.

<cfparam name="Goal_of_Project"...

How do I force the bottom frame (bottom.cfm) to open in the same frameset with top.cfm?

top.cfm is our navigation page, while bottom.html is a page outside our server. I want to open bottom.html within the same frameset with top.cfm.

As it...

Greetings experts Happy new year :)

I'm looking for a way to take 4 queries and export to an excel sheet  with Coldfusion. The kicker is that query1 is tab#1,  query2 is tab#2 (you get the idea) so export one excel file with 4 tabs....
 
I...

We are trying to use the APNS push notifications for iPhones as described here:  http://www.coldfusionjedi.com/index.cfm/2010/9/13/Guest-Post-Apple-Push-Notifications-From-ColdFusion-in-Ten-Minutes-or-Less

Our Code:

      <cfset APNSService =...

I have a read only datafield input in my form.  Some of my users are getting confused thinking they will be able to enter info into the field when they click, but they actually have to click on the little calendar icon to pull up the calendar.  I...

Ive download a script called Uploadify, which is a nice little jQuery file upload with progress bar script.  it uses a file in the background to upload the file.  What im stuck with, is getting the script to return the filename after upload.
...

when i first go to this page http://www.stewleonards.com/specials/feed/SLSpecialsFeed.cfm in IE, it displays correctly with all items. However, when i subscribe to the feed in IE, it only displays the first item and everything else dissappear....

I am having trouble parsing a dataset into XML.  for some reason I keep getting this error..
This page contains the following errors:

error on line 60 at column 9: Comment not terminated
<!-- "
error on line 94 at column 17: Comment not...

I installed ColdFusion MX 6.1 Server on a fresh build of Windows 7 Professional SP1 (IIS 7.5). When I attempt to view any ColdFusion pages, I get the following IIS error:

HTTP Error 403.1 - Forbidden
You have attempted to run a CGI, ISAPI, or...

I would like to change the port that Coldfusion RDS runs on from 80 to something else.  I currently have Coldfusion 8.

I installed the CFX tag:  cfx_Excel2Query tag on a Coldfusion 9 Ent. server.  I am not sure where to either change the class path to point to the CFX in CF9.  

The error I receive:  ojava.lang.NoClassDefFoundError: com/allaire/cfx/CustomTag.  

I've got CF 9 standard running on a Red Hat box with MySQL 5 & Apache.

When I first load my site, it immediately throws the following error: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before...

I have this deserialized JSON that is in the form of Struct > Array with structures

How can I loop over this for a db insert?

Thanks.

I have a simple JS call, using <cfajaxproxy> to a CFC function. The CFC function fires fine, but it appears the JavaScript chokes on trying to parse the returned struct. I have tried returning a struct and even simple text ("<cfreturn "test">),...

how can i redirect a non www to a www at domain level with cname, the domain is hosted at godaddy. this is due to the ssl certificate on the site and the site is on coldfusion

I have a results page with a search form on it, when I submit the form the first time it shows 0 records returned, when I submit it again it returns all my records. Can someone have a look at my code and tell me where the problem lies?  also the...

We just upgraded to ColdFusion 9 on a Windows Server 2003 box that uses IIS 6 to serve the sites.

 
Now that we've upgraded all of our <cfajaxproxy> tags are broken.  Sample code attached.  The cfcs reside in the same directory as the cfm...

Greetings Again Experts,

Yesterday I posted this question up (thank you all for the responses) I see that my only course of action is to use the POI ultility
http://www.bennadel.com/projects/poi-utility.htm
 
I have downloaded it and...

I setup the datasource for all my MS Access DB and all but one is working fine.   The one that is not working is one that has a form that will write to the DB.   The system is setup on a Window 7 PRo box 32 bit OS with 32 Coldfusion.    I keep...

I have a client that is sending me a TripleDES EDE encrypted string using Java

Encrypted String: OvGS9+D6u5PeJlx1itnhOhBVierX85oyAjTkl3LAeFk=
TripeDes EDE Key: wfQjuvuJN496DUUVSSmGMrVYLP7IB4rN

Does anyone know how to decrypt this string...

I have the following values stored in a comma delimited list... for example

list: 13,14,16,18

there is a url variable #fc# that i need to find in the database field containing this list (named teams_selected).  I tried to write a query to...

Using Google Maps API v3

Basically just trying to display a map with markers from the returned lat/long of my loads query.  The markers are being displayed but the on 'clicl' function is only opening the last marker since the name is not...

I downloaded the 64-bit install of ColdFusion 9 (Developer Edition) for Windows from Adobe and was able to install it on Windows 7 just fine.  But there were problems with the install and I needed to uninstall to make corrections.

The problem...

I manage a ColdFusion-based web app that makes extensive use of HTML web forms (all of which get prepopulated with info from a MySQL database) .

Whenever we display these "reports" on the screen, there can typically be anywhere from 3 to 10...