Webmaster Forum / ColdFusion / Advanced Techniques / August 2007

We are wanting to load balance our servers for optimized speed.
Any suggestions on the best out there?

Hi there, I'm hoping someone can help me. I've created stored procedure in MS
SQL end a result set I?m getting from #tempTable.
In the beginning of SP I?m creating the tempTable which have only one column.
After some calculation I?m inserting rows to that temporary table.

Gday i have a query which i want to select all where date is 28 days old
but i cant get it working, can someone tell me what is wrong with my code?
<CFQUERY datasource="#application.ds#" Name="Show">
        SELECT *

I'm invoking a CFC remotely. The CFC resides on a Windows 2000 OS with a SQL
Server 2000 back end, using CFMX 7. When using CFLOCK I get the following error:
timeout occurred while attempting to lock [APPLICATION NAME]
When CFTRANSACTION is used (and CFLOCK is removed) the web ...

We have 4 webservers(CFMX 6.1) load balanced talking to another database
server that runs SQL Server 2000.
Over the last one month, one of the webservers seem to be erroring out quite
frequently. It maxes the CPU of the webserver server. Meanwhile the other

I am attempting to loop trough a txt file and loop the entries into a
database. The file is delimited by a pipe '|' but when I attempt it, I get:
Incorrect number of columns in row.
Verify the number of columns specified in the columns attribute and in the

[b]Background:[/b]
Using cfajaxproxy to call a cfc function on the server.
[b]Question:[/b]
Is there any way to encode the javascript communication with the server using

I've written a test Coldfusion 8 .net dll in C# and called it from cf and it
works fine.  However, when I make a change to the C# dll and try to replace it
I can't.  It says the dll is in use.  So I renamed the original dll and copied
the new dll to the same directory.  Did not ...

I am wondering if there is any way to share client variables stored in a
database across domains.
that way if I log into www.yyy.com I'll also be logged into www.zzz.com where
in both cases client variables are already set up to access the same database?  

Over the past several weeks we've been experiencing periodic hangs of the
ColdFusion service. We finally invested in SeeFusion and found the problem, but
aren't sure how to fix it
The code that hangs is a query of queries block. Basically we are getting a

I am running a cfquery on an ms access db and displaying the results in a
cfgrid.
I want to display the grid sorted "descending" and don't want users to have
the ability to change the sort.

i am trying to have a download file area.
i have some files on my server with i need to give user the ability to download
can i just have a onclick to download the file?
i am not sure what syntax to use to download a file from a server location?

Using Dreamweaver 8 and CF MX 7.  All the CFCs I've created were created
manually, not using Dreamweaver.  I then copy the CFC, and modify it, for other
applications in other folders.  But all apps are part of the same SITE.  
However, when I click IN and OUT of a template that ...

How do i write a CF script can do searching for the permutation number:
Example search for 4 digit number like: 1234
Result:
1234

Stuck on how to get this to work.
How would I go about looping and setting these values instead of doing them
individually?
The query this <cfset> references works fine and will work but repeats...