Hot Solutions

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...

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...

I have this SQL Table. Please see attached image.

I did a query in Coldfusion in order to retreive the topic name and it's working fine on the following page.

Now i'd like to refer to that query with my URL. It's working but it's not...

I'm populating a select with JSON data called from a CFC.  I've simplified the CFC below, so everything can be clearly seen.

After populating the select options using jQuery, I want to set the selected option value to a specific default. ...

I have a simple CFQUERY in a CFC which gets data from a mySQL table.  I'm using getJSON to load the data into my CFML page.  

My first attempt was wholly successful, but I have now added a new column into the mySQL query and after doing this,...

I want to be able to run a query that focuses on data that is between dates. However the dates I need have an anniversary date of December 1st - November 30th.

How do I set up the date variables that will handle what year it currently is and...

I'm stumped.

We have an enormous site that we converted from to static to dynamic (mysql, coldfusion). There are many existing original static links that are dead. The plan is to write a script to take care of that, but in the meantime we need...

I have a soap call that returns xml data in a single array. I need to figure out how to convert this data to a query format, so I can work with the individual columns and rows of data.  

Here is a link to see the dump of the data: ...

I'm struggling to expose a hierarchical query as a tree view in ColdFusion.  I just can't figure out the mechanics.  
Initially I want to expose it without a bind to a cfc.  Then I want to expose it with a bind to a cfc so I can take advantage...

Hi everyone,

I try to find a solution to optimize a web page, Here is the code :

 

As you can see i loop over time to find an entry in the infos table then output the informations.

It works but when i do that over a week there is too...

Hi Experts,

I am new to jquery. I have a simple stopwatch application and want to post the start and stop times to a database using coldfusion. I am unsure how to make this work.

Below is the jquery that controls the start and stop buttons...

This example shopping cart test page will be open to the public on the web so it has to work in all major browsers.

I want to update a choice in our sql2000 database, similar to what Netfix does when one clicks on the big X to remove a...

hello experts i need help to split a string
My url string is like:
http://www.test1.com/showimage.cfm?imageurl=http://www.test2.com/image?id=1234&group=5678

looking for url.imageurl i will get:http://www.test2.com/image?id=1234
So i think...

I have a complex page that has a lot of ajax going on.  I have a cflayoutarea that cfincludes a template that has a cfgrid and a cfdiv based on the selected cfgriditem.  I have some date fields that I want to use Jquerys' datepicker on and I have...

Hello,

I have a coldfusion application running on IIS7, Windows Server 2008 r2 and I am outputting Russian characters using Unicode (UTF-8) pages.

All of my pages output correctly, with the exception of pages where I have Russian...

I am using jQuery to send an Ajax request to a ColdFusion page. This ColdFusion page runs two queries to retrieve shipping data. The results of the queries are returned to the .js page where they are displayed. Everything works fine, most of the...

Hello experts.
I'm trying to set a schedule task using a form to enter the needed values and a cffunction.
I get errors attributes that are not set (for values that are eq "").
f.e i don't have a value for port or proxyPort or requestTimeOut ....

I am querying a database and getting data back in the following format:

12345/RW1
12345-6/POP32
5487412-001/ER65-1
ECT...

What is the best way to create two variables from the above data?  The first var is all characters to the left of...

I am trying to get a ColdFusion page to display a 'loading...' screen until the page gets redirected to another site.

If I just use this code:

 

The page will sit pretty blank until it eventually reloads. I want to have some sort of...

Hi Experts,

I'm facing a programming challenge that I'm not able to get my head around and am hoping the CF gurus here could help me out.

Scenario:
********
I have a .cfm page that has several controls populated by a query. The data that...

I'm a ColdFusion newbie who's trying to set up CFEclipse and ColdFusion on my machine. I'm going through this tutorial:
http://www.ibm.com/developerworks/opensource/library/os-eclipse-cfeclipse/?ca=dgr-lnxw06CF-Eclipse

and when I get to the...

i prefer to use jquery or jqueryui, but how it can be done,

i tried using document.ready and inside that calling the dialog(), but that did not appeared.

i just wanna open the popup when the page url is cliked and without waiting for the...

I'm working with the Twitter API and am testing for the session variable (which exists) of SESSION.userdetails.accesspoint.  However, the cfinvoke is not being executed upon this condition.  Since I had a similar test not work until I simplified...

hello experts.
i'm using cf8 and mysql
I want to execute a query similar to this:
<cfquery name="qryinactive" datasource="#variables.dsn#">
     UPDATE offers set inactive = 0
     WHERE endoffer < DATE_ADD(now(), INTERVAL -7 DAY)...

I have a customized confirmation message box that pops up when a cfform is submitted.  My code is below.  My problem is the code doesn't wait for the user to confirm the submission.  The message box pops up temporarily and then the form is...

Hello,

I am creating an small app to accept an http request (non SOAP) from another company. This request will be a form post, the form fields will be processed and either a 1 or 0 should be returned. I was thinking about doing this as w web...

I have code fusion *.cfc file, when I try to open it with notepad, it's unreadable. We bought the package. But I need to modify something. Do you know the reason? Is it compiled?

I have an account on a coldfusion/MSSQL shared server hosting service and have been targeted by what I believe to be a SQL injection attack.  I have a absolute path to a javascript file in nearly every field of every table.  It seems the script...

If I choose option value 1, from the "First select"
results from both div id="d0" and div id="d1" are sent via a form.

First select:
<SELECT id="ptype" NAME="business_category_main" onchange="toggleSubmit(this)">
<option value="1">Culture,...

Exporting data from our database to Excel using CF8 using <cfsetting showdebugoutput="false">
<cfheader name="content-disposition" value="attachment;filename=#OUTFILE2#.xls">
<cfcontent type="application/msexcel">


And then generating XML....

I am trying to use the jquery toggle function to show/hide multiple div blocks that are generated dynamically using a coldfusion loop. Each div block would have a separate and unique id that is automatically generated. I want to be able to use...

How would I write a regex in Coldfusion that would search for any "." period characters that appear within brackets and then replace those periods with a space.

For example:

Yada yada yada (my data. yoho. ho) yaya yaya.

I want to turn...

Hi. I have what seems like a very basic question, but I can't quite get the solution. I have parent and child PageIDs in a table. I need to list ParentIDs by title. I can't quite get the right list of titles to display.

Query getPages queries...

I am currently using this to color some fields based on the value in the table

<cfswitch expression="#Category_ID#">
<cfcase value="1">
<cfset color = "##0000FF">
</cfcase>
  <td width="191"><FONT...

I have the following hTML code:

<a href="http://www.tayport.631club.co.uk" target="_blank" style="color:#ffffff">Tayport 631 Club</a><br>

but when I click on the link it puts the current web address in front like this:
...

Hi,

I am trying to perform a cflocation tag inside of the application.cfc within the onRequestStart function and keep getting an error.

If I leave out the cflocation tag from within the conditional recordcount tag, the pages will open fine....

<cfsavecontent variable="objxml">
   <VehicleInfo Year="2010" Make="BMW" Model="328I SULEV">        
   <Sub-Model>CONVERTIBLE</Sub-Model> <Sub-Model>COUPE</Sub-Model>  
   <Sub-Model>SEDAN 4 DOOR</Sub-Model> </VehicleInfo>
</cfsavecontent>...

I have been trying to use some .net classes that I have created with my coldfusion application. I am able to use built in .NET classes but if I try to create my own class and point to the .dll assembly I get the following error.

Class cfTest...

We took over the maintenance of ColdFusion running on Windows Server 2008. How do you know what security updates have been applied before and what more are available to be applied for ColdFusion 8.0?

Thanks!

someone has uploaded a shell file to our server, I believe it was done through some kind of sql injection. Attached is the file, can someone give me more details on exactly what the file does. It looks like it could be for de-facing or for...

I have create the following SQL TABLE

user_id    int
id_number  int
firstname varchar50
lastename varchar40
date datetime

This is my insert

<cfif xaction eq "true">
    <cfquery name="logs" datasource="#application.datasource#"...

Coldfusion 8 SQL Server 2005

I have forms that submit multiple combinations of parameters. In the past I have
called a custom tag to keep appending critieria to build the criteria. This works fine but no cfqueryparam protection. Also The form...

Hi,

I'm running ColdFusion 9.  I have a few strings like this:

50;#Rick Smits

20;#John Doe

20;#Jane Doe

20;#Jack Smith

How can I remove the pound sign (#) and everything to the left.  The strings aren't always the same except...

I am inserting values from drop-down on my form into a master table. The values are saved in a separate table. I assign each list item in the reference table a numeric value. Below is an example of what I am using (the relevent code) on my INSERT...

Is there a code that I can use that will convert a email from a Database and display it on my website, but when spammers are searching my pages they wont be able to pull the email?

Recently I noticed a mysterious "7" appearing in the top left corner of my homepage: http://heart2heartshanghai.net/index.cfm but I cannot find a "7" in my CFML code.
In trying to track this down (to remove it), I created a totally empty new...

I have a live application running, but I need to take the data and import it into a different site.

Is there a way to change this to have it output to an excel file with the fields:

[articleID] [articleTitle] [articleContent]

Right now...

Hello,

I have Dreamweaver CS 5.5 installed. Then how about the ColdFusion Administrator.
Do I download it?

Thanks

Good Evening All!!! I was hoping to get a little help. I have a query that I'm trying to get records from a table that do not appear in another table, and I'm using the MINUS to do that. And it works to a point...and I'll try to explain what I'm...

I have this button is working fine... but I don't know how to add the coldfusion to it.
<!--- <a class="CommonImageTextButton CommonReplyButton"...

I have two web pages that are exactly the same except one includes the file prototypes.js and the other one does not.  The one that includes prototypes.js never executes the following code:

 

Samples of my problem can be found at:
test.cfm...

I have a soap call that is returning data in the following format:

ID={43054}|Path={C134/e1e4c0cf-6927-4414-835d-aa1e84600a9d.JPG}

I need to extra the directory and file name from the following section:
Path={directory/filename}

The id...

I need your help.

Could you please view attached images and help build this CFQuery.

<CFQUERY NAME="DisplayUsertool" datasource="aies" username="#application.username#" password="#application.password#">
    SELECT CMTEE_PREF
    FROM...

MS SQL Server 2005
CF 9.0.1
Hi. I've been working on this for a while, and need a hint. I am trying to display parent, child, grandchild pages in a navigation menu. Here is my query:
 

And here is the output:
 

The problem is, the...

Hi _agx_ or other Expert,

I just started using the below code from previous post this morning and would now like to add SN in front of each number as follows;

Current display: 001-003,005-010,012-015,017,019,021,026-028

Desired display:...

I just finished setting up CF9 on Server 2008 R2 64bit following the Lockdown guide.  I'm having issues with the CF service log on account.  I've set the NTFS permissions as described in the guide, but something's not right.  I get this when I...

Can someone provide me with code that will redirect end users to a custom 404 page if the page or url does not exist? I'm told from my hosting company that it should be in my application.cfc file. Any ideas?

I have a memberships site Coldfusion 8/ SQL Server 2005

It has been running fine for years but lately we get members saying they cant login and when they login they get our  message "you have been timed please login" and this loops.

When...

I have a web server running Server 2008 R2 x64 Ent with IIS 7 and ColdFusion 9. One of my ColdFusion sites is running perfectly fine. I have another CF dev site that is a duplicate of the first one (in terms of files) that returns "The service is...

I have a form select with class="yesno" which I populate by binding to a cfc.  After binding, the options are set as follows:
 
I want to use jQuery to change the text of the option values with 1 and 0 from true and false to Yes and No.  I've...

How do I pass a url variable using jquery mobile pages like with a button?

<a href="#page2?wid=22" data-role="button" data-icon="arrow-r">Edit</a>

I am using the CFSELECT statement below to populate a drop-down box. I need the first choice to be left blank. Other than creating a blank or NULL option in the database, it is possible? I need to make the first option blank and the drop-down...

Hello experts.
I have in my application file two createobject:
<cfset objcategories = CreateObject("component", "admin.com.categories").init(dsn = "#request.dsn#")>
<cfset objhtaccess = CreateObject("component",...

I have a soap call that gets converted to an array.  I need to check to see if a variable from the array exists and I don't know how to do this because <cfif> does not accept my array value.

I have also uploaded this file to my server with a...

I am using a CFFORM with several different element types. I have a text field called "ITEM" that I would like to validate the user-entered-data against a database query as soon as the user leaves the field. I would like to diplay an image of a...

Hey guys, so I am trying to nest two queries, and finding it difficult. Basically I have one query which selects everything order items table where an order number is equal to a variable passed. This table has a productID column for every item...

I want to try running ColdFusion 9 on some flavor linux for the 1st time. I used linux (briefly) in the past,  but not in a long while.  So I'm hoping to get some recommendations from someone who's used the two together.

a) What...

I am using the method below to export the contents of a cold fusion page to excel. When I try to open the file my browser gives me the following message (below also). Is there a way to avoid having this message displayed? Thanks.

Message
The...

Platform: Windows Server 2008 R2, IIS 7.5
ColdFusion 9

Hi, experts. I've been looking around for a solution to what seems to be a common task, but I can find only hints. I did find a solution that works in PHP, but I use ColdFusion, not PHP....

The "Read more" line needs to be on the same line as the last line of the story_body. As it is now, it's always moved down one line.

I don't want to remove all the line feeds in the story as they're needed. I only want to remove the last...

I have the following snippet of code from the Adobe website to try and bring the JSON data into my site, but I have no idea how to parse or read the data after I retrieve it.  My goal is to simply create a viewable photo album on my site but...

Hello experts.
I need help to add a validation code i had in a validation.cfm file ,in a cffunction now.
My previous validation was:
1) form validation:
<cfset objgetAdd = CreateObject("component", "com.getlanguages").init(dsn =...

Please see attached image before you read my question.

There is a SQL Database has this type of field.
Column Name: CMTEE_PREF and the Data Type varchar 25

I did a Coldfusion query and i'm able to retreive data in that data field. Data...

I am trying to output information from a two dimensional coldfusion array.  

<CFOUTPUT>#session.ExcludeFieldnameArray[1][14]#</CFOUTPUT> - gives me an error:   Complex object types cannot be converted to simple values.

What am I doing...

We are using ColdFusion 9 on Windows and calling data from a separate Windows server running MSSQL 2008 R2.

In the CF administrator we define DSN's the way we have always done, by choosing "Microsoft SQL Server" from the drop-down for driver...

I am using Fusioncharts to create a bar chart, when you click the datapoint, it "links" to a new cf page and displays detail data.

Problem. it goes to next page, but when I go back and select another datapoint to view, it does not refresh the...

Hi,

For some reason the following cfhttp request will not work. As shown it returns Connection Failure instead of the actual data. In the past i stumbled upon a similar problem, then the problem was an end of file character in the middle of...

Hello,

I am an asp.net/c# developer. For some reason, I have to use coldfusion with dreamweaver for a while.
I never use coldfusion before.

How to start it? Such as "Hello world".

Thanks for advice.

I would like to have a code that show the user their password strength as they create it when signing up on my web site. If possible as they are creating it,  the site will display something visual so they know if their password is Week, Good or...

I get a daily txt file with image links (see attached txt file)
And I parse these links into a MySQL 5 database table.
What I want to do is download these images to a folder on my server, and rename them to match the MLS Number, like...

I've successfully executed a Query of Queries on a cfml page where the code for each cfquery was in the header of that page.  Now I'm trying to move the two queries to a cfc to be accessed remotely.

My cfc has the following code (getOffices is...

Please review my complete querry...

Based on my querry could you please help identify the criteria i should add to my url to go directly to my topic number 2 without selection topic.

This is my url for example:...

Dear Experts,

I have a CF form with some simple javascript that hides or shows text, depending on which of 3 radio buttons is selected (actually, text is only displayed when the 3rd radio button is selected). There are 2 functions that fire...

Hello experts.
I need help to replace the following createobject with cfinvoke.
cfm
<cfset objsheduletask = createobject("component","com.scheduletasks").init(request.dsn)/>
<cfset objsheduletask.fsendundelivered(request.homeurl)/>

cfc
  ...

I need help creating a query in coldfusion. I have 2 loops. I will give me an ID. But the second loop must create as many columns as loop recordcount is.Instead i getting an error message

The column name (mydata_1) that you specified already...

When a user selects an option from a multiple select dropdown, I'd like beside it or above it to list what has been selected. Alternatively, I'd like to hide it when it is "unselected". Is this possible?

 

Hi,
I work for a small company  and I need advice on a common technique in ColdFusion 8.  Perhaps you can point me to a tutorial on the web and/or sketch out the approach:

I need to display the results of a query set (say list of companies)...

Hi,
I have a form fields qty_1; qty_2, qty_3 etc based on an indexed loop generating the fields.


After the form is submitted how do I do (in an index loop using "i" from 1 - 5)

<cfoutput>    >>needed?
   <cfloop from="1" to="5"...

Using ColdFusion's CFQUERY update, I want to increment the column SEQUENCE  in an sql2000 database, starting with the number 1,  next number, 2, and so forth in numeric order. SEQUENCE data default is null.

What am I doing wrong?

I already...

Hi,
 
 I am trying to pass a couple of values (Class Title, Class Location) to the next page. I am using URLEncodedFormat to capture blank space.
Actual Code:
<a...

ColdFusion 9
SQL Server 2005

Hi. I am trying to display a list of Parent and Child pages, with children arranged under their respective parents. metropc1 suggested CTE recursion, and so I have been reading up on CTE recursion here:
...

 

News thumbnails are automatically generated from a news feed using cffile. Once in a while an image is created that's corrupted. It's  always less than about 2k in size. I've wasted too much time attempting to discover the reason and now...

I have a query and I want to increment each record similar to the #currentrow# function, how can this be accomplished inside the query when the end of the records is not known. The list will not be over 26 letters.

EXample:

query

A
B
C...

Hey Experts,

I just have a quick question with CFSET and the Onclick() function.  I am trying to setup the text in a TH cell to be able to sort and then refresh the page afterwards..  I have setup a session variable called TaskSort which sets...

I have this loop that loops through a series of attributes.  For some reason they have setup an attribute for each month that has a value of true or false.  I want to skip over these so they are not added to the query I am creating (using...

I am trying to build a drop-down choice that does not query a database - basically creating the choices with html. I want to write the selected value to my database.

When someone visits the page and need to make a change to the value it shows...

I want to create a pdf of certificates of completion for students to print from my Coldfusion website.

I'm looking for some advice on setting up a JDBC ColdFusion 9 databsource DSN for inter base database instance. ColdFusion is running on Apple OSX Server, Apache2 - Interbase is running in a windows with shared directory access via url...