Webmaster Forum / ColdFusion / Advanced Techniques / October 2004

Has anyone successfully set up an Excel datasource in CFMX and been able to input text into an existing Excel spreadsheet?

OK, I've got this query that runs just fine inside of Access but when I move it
to my cold fusion page it gives me an error of :
"Too few parameters. Expected 1. "
Here's the query:

This problem was also posted on general discussions (by mistake):
I have this nagging problem that only occurs on my hosting site, but not on
the development server. jsessionid keeps changing when I refresh a page with an
iframe, or when I click on a link on the page, but cfid ...

I am having an issue with properly outputting query data. I have this code:
<table width=100%><tr valign=top>
    <td valign=top>
        <b>Billing <cfif compare(qOrder.shiptobilling,0)>and Shipping

I have created several forms on different websites using the cfform tag.
Everything works OK. However, the time stamp is always 4 hours early. I have
checked the server, both the time and zone settings, and they are correct.  I
had them on a Windows NT platform and moved to ...

Hello all. I have got this site set up so that some session variable such as
firstname, username, password, and email. I want the top of my webpage to say
"hello firstname" and replace firstname with the variable session.firstname.
But I only want that to appear if they are ...

I am working on a cf calendar and I have worked out how to generate a calendar
using cf. However, I want to be able to display events on the calendar from a
database, but I am not sure how I would do that because it requires a nested
cfoutput.  I can't nest the cfoutput because ...

Anyone know where I can find out how to convert text from a form text field
into HTML-ready text?  For example, convert literal quotation marks into the
HTML equivalent &quot; Or any special character into its HTML equivalent
(bullet, single return, bold, etc.)

How can I capture the XML data created from a web service?
I'm trying to format results from a web service using XLST, if possible.

OK, can someone give me a good explanation as to why this happens:
I have a form textarea that allows users to store a memo field and sometimes
they type an apostrophe (single quote ' ) in the field as in "the user's
quote".  When I save from that page, the quote is stored just ...

I have run into this many times in the past and for the life of me, I cannot
remember how to remedy it. I have a simple SQL select statement where ID =
#ID#. ID is an incrementing int and when I ask for 10 and I get 1. It is
pulling the first char of the vlaue (1) and matching ...

Events system,  
the data stored for a single event has a  Start Date and End Date..
so a single event can last for one day or mutliple days.
i would like to display data in this format..

I know we can set session variable to never expired.
What is the draw back on making session variable never expired?
Most of our users open our application for hours even days...they may work on
others and came back hoping our application is still active without throwing

We have found information about the way to fix or enable the dynamic loading
Java class files when using CF MX. This appears to work with the MX version but
is there a way to dynamically reload class files in CF 5?? We compile and then
copy the class file to the JVM directory ...

Very strange things are happening with one of our web site,  cfoutput is not
outputing result and cflooping is not looping, all showing blank page! One page
only will show part of the content if i put cfabort at certain place not not
further down in the page, otherwise it will ...