Webmaster Forum / ColdFusion / Advanced Techniques / September 2005

My situation is that Ineed to get an accurate contested claim count for every
single month, now the problem is that I get inaccurate counts for each month
and my totals are all wrong. here is my code and see if you guys can help.
<cfquery name="paid" datasource="FRG">

How do i have a user upload an excel sheet or csv file then have the
application read the file and update / insert the data into database table. the
first row of the excel sheet with have the field names that match the table,
just need to update or insert the records from the ...

Does anybody have any experience creating speedometer/dial type graphs for
dashboards?  Are there any tools out there for creating them dynamically with
CF?  Just looking for a point in the right direction.
Thanks!!

Exporting to excel works fine, but I need to have it formatted in a certain way
(column headers displayed bold and vertical). Can commands be passed from CF
during the export process to format the column headers, maybe using ascii codes?

I'm fairly new to serious OO in general, and also Mach-ii. I understand the
concept behind the bean, but I am having trouble reconciling it with the
uber-handy CF query object.
At the moment, it seems to me that I could not create a tag for my view page

I have a central data base that is being accessed by multiple clients.  I would
like for a change in the database to be "broadcasted" to each client.  Is this
possible using server componets or some other technology available to a version
6.1 server.

I have a function which is a basic database query, the function returns the
query to the calling page. I have wrapped the query in a CFTRY incase there
is an error, if an error occurs the query is not created and creates an
error. am I able to have more than one CFRETURN? How can ...

I have a page that uses cfdirectory to show images 1 at a time in a
directory.  I have up in the corners of the page simple left & right arrows
to navigate through the various images.  My client would like me to put a
"play" feature in it, so that when clicked the page will act ...

I have a function that generates a random password out of a list of dictionary
words, concatenating them.  The function is called GeneratePassword and takes
an int as an input value and returns a string - the password.  When trying to
use the code below, SQL returns an error ...

I am trying to pass a field from a database query to JavaScript but the alert
shows "0" can you tell me what is wrong
onClick="return select_func('#employee.name#')
<script language="javascript" type="text/javascript">

We have just applied JRun 4 updater 6 to an MX 6.1 Enterprise server. We have 2
instances set up in a cluster serving 1 site in IIS6.
We have made use of cflocation in the site to redirect users to a new page.
After applying Updater 6, this redirect now fails - however apparently ...

Any ideas spring to mind about the following issue?
I'm getting an error trying to run an Update or Insert query. I can run a
Select query in the application, but not Insert or Update.

I am receiving a "token" from a vendors web site based on information that I am
supplying to them thru a <cfhttp> tag with form fields defined using
<cfhttpparam>.  The data being returned is strictly a string with no http
header or body tags.  If I do a "view source" on the page ...

Hey guys, I have to retrieve a name associated with a number between 2
datasources. Please see my code here:
http://www.coldfugitive.com/paste/?post=1719
- Query one gives me all my brokers, I will eventually cache this once I get

I tried the suggestion given to cast data after a cfhttp to retrieve a csv
file. I came up with the error :
"The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.