Webmaster Forum / ColdFusion / Advanced Techniques / April 2007

Im trying to find all .cfm templates on our server that reference any of the
following column names in the SQL where clauses. But having trouble pulling
back just the SQL select statements.
Column Names to find:

I'm hung up on figuring out how to populate the checkbox on an update. What I
have is a list of extras that are applied to a workorder with a foreign key
tied to the ID of the extra. What I am trying to figure out is how to check the
box if it's in the foreign key DB column of ...

Does coldfusion 7 support having an email address with a dash in it. ie
me@the-company.com
I am getting this error in the log.
Invalid Addresses; nested exception is: class javax.mail.SendFailedException:

I need to write a small app. that gets the data from the DB then displays
first 10 records, then the page automatically refreshes displaying the next 10
records and so on.
How can i do it. I just need the concept.

I?m brainstorming some ideas how to allow users of my website see their
individual web statistics. How many times their profile has been clicked, what
key words were used to search for them, how many times a URL within their
profile was clicked and other report statistical data.

I am trying to parse a long string and get specific values out. The file is
actually an email and I need to pull out items from the body to populate a
query. The email would look something like
         Name: Value, Test          Home: (800)555-1212

I have to do away with all the CFINVOKEs in a CF application.  So does anybody have an excellent tutorial on how to make a SOAP request with CFHTTP?  I can tell already this is not going to be fun. :\

This is the code I have to navigate through the database by previous and next
links, the issue I'm having is for the previous when i click on the previous
link, it stays on the same page and the issue i have with the next link is, it
works fine up until there is no more ...

I built an application that has 2 scheduled tasks.  One of them sends
e-mails to a list on a daily basis and the other completes an HTTP
request.
The number of records is getting larger and these tasks are failing

On shared server with a less than helpful host...but that's a different grip
entirely...;)
Have been to source forge and have the latest remoteClasspath_geoLocator CFC
with the latest InetAddressLocator.jar which includes some amendment for

I am able to read through the excel file up to 15 rows...after the there is
nothing what could be possible wrong ? Any help...
I believe that I found the mistake on excel file..If any cell data starts with
a number or a string value, the next cell under the same column should be ...

I am working with an XML object with many optional elements. I am trying  to
use StructKeyExists to see if optional elements are indeed populated, but I
can't figure out how to code the statement. Right now, I have given up and used
the <cftry> option as shown below and it is ...

I've been using TimeFormat(Now(), 'h:mm tt') for over 8 years.  Suddenly
TimeFormat is returning GMT time rather than local time.  I know that it is
returning GMT time rather than local time because I have some JavaScript code,
which I have embedded along side the TimeFormat, ...

Hi we recently started using our development server again and we noticed that
cfcharting was not working.  I tried applying the hot patch.  
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb400074
I also made sure that I had a mapping in the administrator pointing to the

Can someone help me with the syntax on how to convert data type varchar to data
type money. I'm receiving the following error message:
[Macromedia][SQLServer JDBC Driver][SQLServer]Disallowed implicit conversion
from data type varchar to data type money, table 'tableName', column ...