Ordering data type varchar I keep forgetting on how to order a column with datatype varchar One of my column for pricing has these values: 5,12,15,18,21,23,31 etc when I cfoutput my query result I got the list showing as: 12,15,18,21,23,31,5 ... 
compare values Hi, I have the query with out put below for one field as an example Status ------ yes yes yes no i want to be able to do the compare for ALL status in one field but don't know how to do it, Can a... 
Using NVL in Query of Query resulting in error I'm still using CF8 and Oracle 11G back-end. When I use NVL in the query of query I got error....Can't I use NVL to check on null value? Please help Here is my codes: <cfquery name="GetC2" datasource="#Tr... Unix Time (mtime)? I have a command line that finds files in a folder and deletes the ones that are a over a day old. I can't seem to find a way/the write code to change the 1 (full) day into a half day (12) hours (f -mtime +1 -exec rm ... 
Please reset activation count for my adobe account vishnu.bovilla@gmail.com Please reset activation count for my adobe account vishnu.bovilla@gmail.com 
Can't verify MySQL DataSource Hi There, I've got problem with setting up a new DataSource on MySQL 4/5 driver. From the beginning: 1. I've installed ColdFusion 9 (Developer Edition), with JRun 4 option. I've done configuration of A... 
dataLabelStyle="value" Repost, really need help. I have 3 cfchartseries within my cfchart. I want to display the values for one of the cfchartseries only, so I use dataLabelStyle="value", which works.However,the other two cfchartseries... 
Serial Number I had the Master Collection 3 installed on an old laptop. I brought the software through my school's program. A few years after, I bought the MC 4 upgrade through my school. Since, I have had to purchase a new compute... 
Coldfusion 10 64 bit developers edition I have a new 64bit laptop that I plan to use for developing. I am working on a project that uses CF 10. I'd really like to get a copy of the 64 bit CF 10 so I can install the developer version on my laptop. Is there a... 
Problem installing CF10 on Ubuntu 12.04 Just been trying to install CF10 with Apache2 and it was all looking reasonably good, but when I try to use the CFIDE adminstrator, I get a Tomcat error: HTTP Status 500 - type Exception report message desc... 
Using Javascript to require 2 drop down menus to have something selected Hi everyone. I'm trying to get 2 drop down menus to each have something selected when the form is submitted. I'm using javascript for this, but I can't get it to work. Basically, if one is blank and the other one isn'... 
Why is there an offset when using DateConvert with DateCompare? I'm developing on my local server and my current timezone is GMT +11 hours. <cfset date1 = DateConvert("Local2UTC", now())> <cfset date2 = '2014-03-06'> <!--- (Tomorrow at time of writin... 
Created a Global UDF but don't know how to call it, please assist I created a cfcomponent and a bunch functions inside it. One of the function needs to call a process that is also needed by other part of the application. Since this "process" is needed in a different parts of t... 
Do cold fusion pages get search engine placement? I'm new to cold fusion. I've been reading a couple of books. Following the layout ideas in one of those books I have developed a small cold fusion site. Nothing much to speak of and very basic. My homepage is a straig... 
Writing to a file hi everyone, I have a file that only contains a number in it (invoice number). Every time someone submits a form, it should increase the value of the number in the file by one. It's my und... 
Adobe Coldfusion Enterprise and Developer Where do I actually develop a web app? Enterprise or Developer? Do I need Developer? 
Installing ColdFusion 11 in Windows 8.1 I can't no longer download the 30 days trial for CF 10, all I can see is CF 11 when I go to http://www.adobe.com/go/trycoldfusion/ It is OK for me to try CF 11, it is not a problem because I have not submitted a purch... Updating shopping cart merchant gateway info I have been recently approached by a client that has an older site that was originally created on the ColdFusion platform, where the shopping cart merchant gateway has changed to a new provider and their merchant acco... 
How to convert minutes to decimal I need to convert my minutes in my HH:MM record to decimal. For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hours and if i have 10 hours and 30 minutes I need to... 
Incorrect string value Hi - we've just upgraded from cf8 to cf9 and are getting a fair few of these errors - "Error Executing Database Query. Incorrect string value: '\xE2\x80\x8BWe ...' for column" as we try to insert a row in the db. &nbs... 
Sign in to follow, share, and participate in this community.