Webmaster Forum / ColdFusion / Advanced Techniques / May 2007

Hi i have an csv file which i have a date time column which i need to upload to
mysql database column with is formatted as  datetime
the problem i have is the csv is formatting the date time as 5/17/2007 4:04
which will not upload

Here's the deal, we have a CF web service which generates PDF files.  You pass
it HTML and the path to a file server and it writes a PDF there.  Pretty
simple.  We have a Java app which generates appraisals on the fly and uses the
CF web service to make a PDF.

Example:
<cfquery name="QUERY 1" datasource="MyDatabase">
SELECT Table1ID, A, B, C
FROM Table1

I have a bunch of forms that email the results to the contact person.  Recently
we have received tons of emails that seem to be from a spammer or hacker
possibly.  All of the emails are similar which makes us feel that they may have
somehow automated this.  The first, middle, and ...

My boss asked me if there was any way that a phone number could be dialed from
Cold Fusion. We have a website where at some point we want to just click a
button and dial that phone number. My guess is that the conversation will then
be carried through the computer's microphone ...

I have an html form using a coldfusion post script. I want to create a hidden
field using CSS which only spambots will see. Then I need some coldfusion code
to tell the form not to submit entries with that field filled in. Is there a
good tutorial or site someone knows to ...

What i'm trying to do is this:
On my edit page I have a listbox that needs to be pre-filled with people
already selected.  But here is my problem - I have one table named "people" and
another named "records".  Now the "people" table have their permissions in it,

I am trying to do the same as cindypsych, in the post below. Can some one help
me with my code please. Thanks in advance. I want to sort each column by
clicking on the column head.
..

I am working through  an exmaple in the book "ColdFusion MX with Dreamweaver
MX" in chapter 8.  It doesn't work correctly.  I looked for errata and code
downloads from the publisher's site and didn't find what I needed.
In the example, on page A you choose a state from a ...

Anyone know how to code the statement to call excutable program to run executable program via internet explorer

Hi All,
Would it be possible to extract the keywords from a metadata tag:
<meta name="keywords" content="wheat,uk,farming,agriculture,milling,feed">
I'm using verity to automatically produce a list of relevant links based on a

I am generating a WSF for use on my servers, but the method I'm using comes up
with a strange problem.
I am using CFFile to write and append to a file on my webserver which is
pretty elementary.  The problem is that when I execute the WSF with

I am running into some issues with my application and how it maintains session
variables.
What I do is based on what username/password is entered, I find the record in
the database and set the account_id as a session variable. Therefore when the

I have a replacement string of the form "[\1\2]='\3'," and I'd like to insert a carriage at the end of the string.  I've tried \n, \r\n and it doesn't seem to work.

One of my ColdFusion applications has a calendar and tasks list. The client
wants to be able to sync (or at least download) the data into Palm Desktop or
Outlook. I thought I found a solution in Wyncs (wyncs.com) however after
running into a couple problems they determined I was ...