Hi Deanna,
You may need to install Service Pack 2 (right now a RC2) for CF 4.51. I
found this in the Release notes:
Database
The Microsoft Windows 2000 SP1 release caused ColdFusion to become
unresponsive if a CFM page executed a CFQUERY against an MS Access data
source target with SQL like
"Select col1 + ' ' + col2 from table1. This has been fixed. [18607]
Dharmesh Goel
Programmer Analyst
IT Dept. - Discount Car & Truck Rentals
416-744-0123 x290
-----Original Message-----
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: November 1, 2000 3:26 PM
To: CF-Talk
Subject: access query crashing server...
Hi Folks,
We have multiple developers running multiple applications on our server.
We've been having problems, and yes, we've read all the allaire docs on
performance tuning. One of our problems is that we have a number of
large-ish access applications. (Ugh, I know.)
I may have found a clue today. I found one query that seemed to be crashing
the server consistently. The only thing different about this query is that
it concantenated two columns into one variable - ie -
Select (can_fname & ' ' & can_lname) AS canname
When I took this out, and banged on the app again, I had no problems.
Has anyone else ever seen this happen or is this merely a fluke?
<cf_graspingatstraws todaysstraw="concantenation">
-d
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
