Webmaster Forum / ColdFusion / Advanced Techniques / March 2007

I have a cfmail form that works fine. However, I want to add the ability for
the user to be able to upload ONE document and have this document be sent with
the cfmail form when the submit button is clicked.
Any tutorials and help would be appreciated.

I am using the cfheader and content to export table data  into excel
...everyting looks fine except:
There are 3 tables in my code with the same width However the 2nd table has
higher width when it opens in excel.

Hello,
I need help in with the best method to use to send encrypted username and
password to another website server that is java based. I'm trying to come up
with a single sign on for two web applications on two different servers, one

How can I get the results of a query to be one comma-delimited string? I've
been trying to declare a variable using CFSET, as in:
<CFSET var_name = <CFLOOP query="qname">#field#</CFLOOP>
so that I get: var_name = 'field1,field2,field3' etc?

It seems to me the conversion from HTML to PDF using the built in coldfusion
tools is not very stable.  Does anyone have any suggestions of other
software/components for that type of web based PDF conversion?

I have a com object that I need to access which provides my a list of  
addresses in an Array.  The object give me a property that has a count for the
number of addresses and then I have a loop that calls the property which
contains the address details to get each individual ...

I have a database full of kind of sales numbers. I want to be able to search
for all the say, Fridays, or Tuesdays to see the numbers on those days
specifically. I know how to do date ranges, but not specific days so it could
pull up the last 27 Fridays that data was inputed on.

I am querying for distinct data from one table but I need only the most recent
data.  I am currently using  the query included below, but if there are two
entries for any of the paddocks and the species are different in them I will
get both entries returned.  I need it to return ...

It has come to my attention that the method to stream video to Window Media
Player 11 is completely different than to v10. Our site has a few videos and
we are being notified that there are problems between the 2 versions of WMP.
Is there a way that CF can detect the version of ...

I'm doing (still!) an app for parents to sign up for information from their
child's school, and giving them the option to choose more than one grade using
checkboxes.  I'm passing the grades as a string, then parsing them into
individual searchable grades, and then querying the ...

Hi, I'm trying to create a report that will show call data (# calls, avg
duration, etc.). It will output a section for each rep and within that section
it will break down by market and finally by date. I also want to include
subtotals for each rep and market (this might make more ...

I need an example of the following:
I have cfselect on the form that has display set to CompanyName and value set
to CompanyID.
There is also cfinput for CompanyAddress on the same form.

I'm trying to display in a cfoutput a self-referencing table. I'll start by
showing some of the data in the table.
There are only 3 columns, pl_id (auto increment id pri-key), pl_name and
pl_parent_id (it's 0 if it's a parent, otherwise it's the pl_id value for the

I am trying to create and auto manitaining form based on columlist coming back
from a query.  How can I get the dynamic value of the items.  I played around
trying to do a query of queries.  Somehow, it is just not working.  Can someone
please tell me how to get the value to ...

I'm making a simple Ajax call to my CF server and returning
a result.  It just determines whether the session is still going.
It works fine in Firefox 1.5 and IE 7.  Now as I get ready to demo it,
the demo machine has Firefox 2 and the Ajax is broken!  Seems Firefox