Webmaster Forum / ColdFusion / Advanced Techniques / March 2006

Hi i am using cf mail to send emails to a list from my table, this works fine
is there a way to get a dilevery report, i just need to verify that the email was recieved
any ideas?

I am using cfdocument with the updates from the latest hotfix to create a pdf.
The pdf is created from html from a number of different sections.  The amount
of data in each section is pulled dynamically from a db, so the length of each
section (and the number of sections) can ...

Hi i am using cfreport to generate a pdf, this works fine on my local machine
but when uploaded to the server i get this error below,
any ideas why this is, or what i need to do to correct this
many thanks

I need to generate a report that lists cases that are in a Pending state for 4
weeks or more. I got most of the sql working but I don't know of to get todays
date minus 28 type statement in the WHERE clause?   Any help is appriciated.
Thanks

In my code i want to do sorting by header. so i am passing hardcoded
sort="lname" sort="fname". But the problem I have
next link. I am dispalying 25 records per page. So i want to pass this fname
or lname param also in my next page link

I have a form collection and a column list collection.  I would like to find
out what items in the form collection are not in the column list collection so
I can add new columns in my table.
I would appreciate any help that can be given.  Here is my code.

I have a cfscript block where I need to do an if statement that says IF
Form.opa_ccrb_date is null then leave it null If is has a valid ODBCDateTime
then set it to createodbcdatetime(FORM.opa_ccrb_date  I know how to do it using
cfset not quite sure how to do it using CFSCRIPT.  ...

I'm trying to query a column (text) and sum the numbers in the column.  Here
are my queries:
<!---This query prepares a recordset with the columns I need to sum.--->
<CFQUERY NAME="RecordSet1" DATASOURCE="CFACCESS">

Hi;
     I had to try attachment a image in a spreadsheet excel and designate the
name of  the excel file, but when I insert de response header to designate the
name of file the image is broken in spreadsheet. Any body know how do I execute

I am trying to find out if anyone knows a way to use Cold Fusion to download
data from an MS SQL database table to an ALREADY EXISTING MS Excel Spreadsheet
and overwrite the data that was in the existing spreadsheet. I have a client
that wants to be able to download data on a ...

Hi i have a action page where i need to add up some from values
something like this
cfset total (form.hh*1)+(form.gg*10)+(cfif form.gg is between 50 and 99 value
= 50)

I have inherited a flaky piece of code from a previous developer which worked
under MX6.1.  We use a remote COM object on our domain controller (windows
network) to create *.p12 security credentials files for our clients.  The code
basically just calls the COM object on the ...

Hoping someone can help.
I have a user database that amongst other things ahs a couple of memo fields
where the user can enter several paragraphs of text.
All works ok except on download some of the charcters entered by the user are

I have a memo field called #LodgeDesc#... I am simply trying to run that field
in two vertical columns alongside each other, like a newspaper article...
I am struggling to get this right, so if anyone can help me, I'd really
appreciate it...

Hi can anyone help me in the right direction to checking contents of a CSV file
before it gets uploaed to the server. For instance I want to check contents
(for validation) of the following headings on an excel csv file before its
uploaded: