Deanna,
I've just been having a similar problem. The funny
thing in my case is that on my local development
machine, the queries work fine. When I transfered the
database and CFML templates up to my webserver, they
would crash CF Server when the queries were run. The
way I wound up resolving it was to change from SELECT
* to SELECT with specific field names.
-----Original Message-----
From: Deanna L. Schneider
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 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]
__________________________________________________
Do You Yahoo!?
>From homework help to love advice, Yahoo! Experts has your answer.
http://experts.yahoo.com/
------------------------------------------------------------------------------------------------
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]
