Top Solutions

Okay, I've programmed ColdFusion for a few years now.  I'm always replacing line breaks by doing:

-----
<cfset MyString = Replace(MyString, "
", "", "ALL")>
-----

Now I know you can do the same using either #chr(10)# and/or #chr(13)#. ...

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

I am using bind to pull data into a select list, which then binds another select list to display drilled down results. I am unable to use the "selected" value in the cfselect. I want to be able to allow the user to return to the form and have the...

Hi there!
I have the problem described here:
  http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18331
When I for example want to insert the string 'This present costs € 12,00', the euro symbol will become a question mark while...

How can I modify the following query to ignore disabled users in Active Directory?

<cfldap action="query"
    name="PhoneList"
    start="#Portal.LDAPOUStart#"
    attributes="cn,sn,givenname,department,telephoneNumber,mobile"
    ...

What are the disadvantages of using Joint Application Development (JAD)?

This little <CFIF> statements works, except when the getRetailQty.Available is NULL.  I added the "desired" code below but it does not work.  

There must be a smile answer to this.

Thanks in advance,

I have Oracle 9.2.0.5 DB and Coldfusion UI.

To be exact I'm using Railo (free coldfusion server alternate).

I have a simple query

Select someColumns,
TO_CHAR(TRACKING_START_TIME,'YYYY-MON-DD HH12:MI:SSSSS AM') as TRACKING_START_TIME...

hi

how can i test if a string contains another string? for example, if i need to return true if a passed string is "jobs.new" or "jobs.old", it would make sense just to check for the existance of "jobs." in the passed string. how would i do...

Hi,

Is there any way to convert a form value to a number?

I've tried <cfoutput>#Val(FORM.numOfFields)#</cfoutput>
             <cfoutput>#Int(FORM.numOfFields)#</cfoutput>
and CF said that naming the input with a  _integer  suffix would...

How do I get the entire current URL from ColdFusion?

For example, if a user is at:

http://sub.mysite.com/somedir/thisfile.cfm?q=search&advanced=1&more=etc

Is there no easy way of getting this out of ColdFusion?  I would think there would...

Hello again folks.  I created an oracle database, specified the passwords for SYS and SYSTEM and specified the username/password for the repository also.  
I then go to CFMX Admin and create a data source.  
I give the data source the same name...

I have a site with a login screen written in Coldfusion 7 MX.  The login screen collects username and password in a form.  Then it looks up the informaiton in the database. If found, the person is logged in.  The username and password cookies are...

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 am trying to configure a Microsoft Access data source on Vista 64-bit with ColdFusion 8.0.1.  Get this error each time: "Unable to update the NT registry. Variable DRIVERPATH is undefined"
Found many people asking this question, but not much...

I am trying to submit some form values to the database

However i am getting an error when i insert something like (E. Jensen) or N/o . or such special characters in text fields like street. The error is

Error Executing Database Query.  ...

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.

I'm trying to modify the code Steve Durette posted at http://tutorial196.easycfm.com/

I got the page working, but only the first dropdown has any data in it.  The other two selects just display the initial values; i.e. "Choose Volume" and...

Please tell me how to exploit this query with a SQL injection attack!

I've been reading about such attacks and I want to lock down my code a bit better.  But, for some reason I can't get my Coldfusion program to bite on the good old

' or...

Hi,

I found a similar question on this site, but the solution is not what I am looking for.
I need to know if there is a way to reload the keystore/truststore while the JVM is running?  
I tried the following after adding the certificate to...

I am supporting a (quite large) Intranet application written in CF8. About 16 users bashing away at any one moment. It's been quite reliable and the application code has not been modified (substantially) for some months. This week users reported:...

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

Hi- I'm just teaching myself a few things in coldfusion, and I'm coming across LTE quite often. can someone tell me what that means? EG:

<cfset ConditionalValue=10>
<cfset TestValue=1>

<cfloop condition="TestValue LTE ConditionalValue">
 ...

I can disable the checkboxes but I can't make them read only.

I am able to do this, so I know it works:

<SCRIPT LANGUAGE="JavaScript">
   function disableform(staff_access_allowed_add_recordcount) {
   for (i = 0; i <=...

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

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

Hello,

I have a variable that is being set in coldfusion.  What I need to do is to somehow check If the variable contains numbers or only letters. So for example if the variable is HHIEU88HDKJS, I need something that know there are numbers in...

If I have to have an easy forum on my homepage like a "shout box" where people would just enter their name and short meesage and it would show up by recent date on a homepage, do I necessarily have to have Server side coding(Coldfusion) or can...

Hi Experts,
 
How to escape the comma's in the CSV file?
For Ex:

abc,adb,ada,"ads,asd",asdd

In this case how can I escape the comma in "ads,asd".
I have the double quotes generated if the data contains a comma.

I am reading the CSV...

I searched the site and I *KNOW* there's an solution for this.  I have 2 cfinput datefields stacked on top of each other in a form. (yes, using a table if that matters - yes bad coding, I know)

When I click the calendar icon, the upper...

I guess I did it the wrong way...  I upgraded the array on two of my web servers (W2003 SE, SP1) and copied the whole web-sites (wwwroot, etc) directory to the new drive.  To do this, I copied everything once (a lot of files on our site that get...

I have a table displaying several records.  I’m trying to display one of the fields, “TemplateID”, in a select box, but I’m unable to force the correct value into the select box for each record.  The first select box displays the correct value...

Hi, just trying this VB script in a test domain, need some help.

Set objUser = GetObject("LDAP://cn=Fred Flinstone,ou=Stone,ou=Users,dc=Testing,dc=com")
Set objLastLogon = objUser.Get("lastLogonTimestamp")

intLastLogonTime =...

I have an XML feed coming in from the outside to post information on my website:

http://secure.pharmacytimes.com/services/Recent_Courses.asp

Now out of nowhere after two months of getting the feed and displaying it properly, I get this...

Okay, i have a table in which i want to display a DISABLED shortlist hyperlink by default for each looped row. The shortlist hyperlink can only be enabled when the user clicks on the viewdetails hyperlink. How can this be achieved ? and is there...

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 tried editing the limits.conf file  to change the ulimit value for the linux box. Since i got the warning in logs "INFO | jvm 1 | 2008/10/02 19:58:49 | java.io.IOException: Too many open files"

vi /etc/security/limits.conf

# End of...

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

I need to know how to unset a session variable and regular variables...

Thanks in advance!

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

I need validation javscript which check user enter dd-mmm-yyyy.

thanks

If you open my Flex app in Japan or Korea or anywhere for that matter it adjust the time of a datagrid field to the local time, often causing even the date to change.  

I want the datagrid to read EXACTLY what is in the database and not...

What is the simpliest way to export the data inside a flex 3 datagrid to an Excel spreadsheet?

I am using the jQuery colorbox plugin, and am attempting to programatically close the colorbo using $.colorbox.remove(), but when I do, I just receive the following error message: "$.colorbox is undefined"

I have the function online at:...

HELP - The date and currency are not displayed correctly in the cfgrid even if I use  type="currency". I'm using format="html"

What is the equivalent of below code but using CFSCRIPT ?

cflocation url = "#url/usersMenuForm#.cfm" addToken = "No";

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.

We are trying to use AES encryption to encrypt some data and send it to a third party system.

Our system is in Classic ASP, and we are using an AES library we found online.  Our results mimic the results we get when we plug in the data at...

I have an application that has been working for the past 5 months now with no problem.  All of the sudden, after I log out and attempt to log back in, I get the following error:

Element CFID is undefined in SESSION.

This is the pertinent...

Hi,

I am migrating a pl/sql web based system onto an Coldfusion server so have to re-write all my stored procedures into .cfm files.

In my current environment I use templates e.g.

PROCEDURE Pr_Main (p_procedure_name varchar2 default 3,...

Any ideas?

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

I have a parent window, spawning a child window with an onChange open() command to open a separate window when a textbox in a cfinput statement changes...

Parent Window:
<cfinput name="myinput" type="text" onchange="open('insurance.cfm',...

Hello Experts! I have tried to convert my Application.cfm to Application.cfc twice over the past few months but so many errors were generated and I was so busy building the rest of the site and teaching myself ColdFusion that I quickly reverted...

Hello,

I am trying out this cfreport tag and I am getting this error....

An unexpected error occurred while using the Crystal Engine. Error number 500 ocurred (Not enough memory for operation.).

Anyone have this problem or know what I...

I am using MySql 5 and Coldfusion 8 to insert some dates into a table.  I want to be able to insert a null value into a date field if that is possible. Basically, if the field is blank, do not insert anything to the date field.  When I try to...

I have a ColdFusion application that was working fine until a few days ago.  For some reason it is no longer picking up the NT authentication.  It is installed on IIS.

I get this error message when going to the first page:

"The second...

I am trying to save a PDF file (which I am being passed from a adobe pdf submit service as I think a binary stream) in a browser, I just want the PDF to saved so I can attach it and email it.   What CFM should I use to retrieve the submitted pdf...

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

Hi all,

I am trying insert a record in to oracle table from cold fusion mx.One of the fields is a date/time field.It gives me an error.Below is the code.Please help.

<cfset submitdate = DateFormat(Now(),"DD-MM-YYYY HH:MM:ss")>
Insert into...

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

I've spent an hour searching and I can't find a definite answer to my problem.  

I have a Coldfusion variable which is a string of SQL that I use to build a recordset.  The string & recordset works fine when I have a plain SQL statement. ...

A client's MLS company offers realty listing information in the form of RETS xml data.

I've done several xml-based sites, usually reading the xml data into a mySQL database, but from what I am seeing, RETS is a bit different than a usual RSS...

Hello Experts,

I have a form with the following type="file" field:

<input name="vupload" type="file">

I need to be able to clear this field using a Javascript function by pressing a button.  I've tried the following with no success:
...

We are running a security audit against our load balanced website. When the telnet tool 80 hits an existing directory without hitting a valid page on our site it the browser shows our html page not found redirection, but the telnet session shows...

Up 'til now our company has used LDAP sever to authenticate users for access into many of our Cold Fusion Applications.

We are dropping our LDAP and will start using MS Exchange.  I need to know the what the syntax would be now to...

I'm trying to figure something out here...

<cfquery name=myquery>
select *
from table
where empid = ...
</cfquery>

<cfif myquery.recordcount GT 0>
Put data here
<cfelse>
There is no data found.
</cfif>

If the query returns the...

If I have a flash form, then I can use onChange="submitForm()" in a CFSELECT command.
But, we've been told not to use flash.
So how can I submit the form as soon as the user chooses an option?
Or, how can I do client side validation if I'm...

Hello --

I'm a novice with CF9.

== Scenario
- Mac OS X v10.6.8
- ColdFusion v9 [updated to latest 9.0.1]
- JRun with integrated WebServer [listen on 8500 port]
- Developer mode
- ColdFusion Builder v2.0.0 Build 277745 [standalone...

I'm trying to get geo-locations (latitudes and longitudes) of photos into a database in a decimal format from EXIF gps data. However, the EXIF fields 'gps latitude' and 'gps longitude' are in a DMS (Degrees, minutes seconds) format. The value of...

I'm migrating from a w2003 server with oracle 9 client/ CF7 to a new box w2008R2 server with Oracle 11g / CF9.
I'm setting up my data sources and in the original box I had to tell CF where to find the JDBC info.  The CF classpath had:...

I have the following two lines of code:

<cfheader name="Content-Disposition" value="attachment;filename=#filePre##fromDate#-#toDate#.csv">

<cfcontent type="application/octet-stream" deleteFile="Yes"...

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

I'm trying to migrate some Coldfusion sites from CFMX7 on Windows 2003 Server to CF9 on Windows 2008, and for some reason I cannot get the CGI variables to work.  I've run wsconfig to configure the site, Windows authentication is turned on (I'm...

I am using the standard COldfusion authentication with ldap and <cfauthenicate> cookies enabled.

How to get unauthenticated again? I have to close the browser to get to my login screen again. The time out seems not to work and I did not find a...

Hi,

How do I clear all of session variables once the user has closed the browser window ???

Many thanks.

i am using the following query

SELECT POSITION_LIST.EMPID, REPORTS_TO, USER_PROFILE.EMPID, USER_PROFILE.USERFNAME, USER_PROFILE.USERLNAME
FROM POSITION_LIST LEFT JOIN HR_TOOLBOX_USER_PROFILE ON EMPID = USER_PROFILE.EMPID
WHERE...

Hello Experts,

Does anyone know the best way to read an excel file using coldfusion?  I need to have the ability to read the FULL DATA contained within the xls file so keep in mind that the amount of records within the xls file is unknown.  I...

I have values that are in Unicode. Is there a straight forward way to convert this to Ascii? TIA.

I am using this calendar (http://www.dynarch.com/demos/jscalendar/) to pass events to a Coldfusion page.

The calendar for my site is located here: http://www.barreport.com/publicsite/viewevents/jscalendar2.cfm

You click on a date and it...

Hi,

I am trying

<cfif #form.sort# EQ "Price">checked</cfif>

within cfoutput but when the form hasnt been submitted it produces errors, in PHP you can use isset to ignore it, how do I do it in coldfusion?

thanks in advance.

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

Hi

I have the following code in Application.cfm:

<CFLOCK SCOPE="Session" TIMEOUT="30" TYPE="Exclusive">

<CFIF NOT IsDefined(Session.ClericalExp)>
     <CFSET Session.ClericalExp="No">
</CFIF>

</CFLOCK>

When I run my application I...

If I pass an empty field into a stored procedure like so:
<cfstoredproc procedure="myProcedure" datasource="#Application.DSN#" debug="yes" returncode="yes">
<cfprocparam type="in" cfsqltype="cf_sql_integer" value="#FORM.CustomerNo#">...

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

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.

Lost am i......

This is what i have:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.somesite.com/Wsdl/services/HitNoHit"...

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

Hey developers;

I'm creating a page that I would like to display a message for 3 seconds, and then redirect to another page. Here is the code I am using right now.
......
<body><div align="center"><strong><font size="4">This order has no...

anyone one why below does not do anything i want whats in sitemap.cfm to be create a new file called sitemap.html code below


<cfhttp method="get"
                  url="sitemap.cfm">
            </cfhttp>
            <cfset productPageContent = #cfhttp.FileContent#>
            
...

In Windows 2000 Server, the IIS server allowed one to map .htm files to the ISCF.DLL coldfusion file via the Add Mappings option in the Configuration Tab.

But this doesn't work in Windows 2003 R2 Standard Server's IIS server. After adding .htm...

How to integrate SQL Reporting Sevices Report into coldfusion Application?  Can we do that?  If we can't, can we integrate SQL Reproting Services Reports into ASP.Net, then include/cfhttp into Coldfusion application? Any one havs examples?

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 am to come up with a number of technical Coldfusion Interview questions.  I need 20 questions broken down into 2 sets of 10 questions.  The 1st set of questions will be used by a non-technical person asking questions via phone to gauge...

I am running Red Hat Enterprise v6.0 and Coldfusion 9 with JRE 1.6.0_14-b08

My system time reports:
Wed Jun 15 10:05:45 EDT 2011

Coldfusion Reports:
Coldfusion Time: Wednesday, June 15, 2011 8:59:55 AM


And both Coldfusion and JRE...

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

Is it possible to sort a query after I have made an SQL query?

If I submit this query:
<cfquery datasoure="database" name="test">
   SELECT data  FROM table
</cfquery>

And I have five items in the database:
a,b,c,d,e

and then I have...