Hi
Yep - I've seen this - apparently it was supposedly fixed in the SP 4.5.1.
I had exactly the same effect - it was flatlining the CPU and the only way
out was to bounce the CF server. I was running on Win2k/IIS5 - and
apparently it's a known bug. It's definitely a problem with concatenating
strings via Access - use SQL and its okay.
I've not found any solution to it yet though ?
Si.
Sapphire Technologies Ltd.
Secure in the Knowledge
Simon Halcrow Web Developer
E [EMAIL PROTECTED]
T +44 (0)1642 702100
F +44 (0)1642 702119
W www.sapphire.net
> -----Original Message-----
> From: Eron Cohen [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 4:33 PM
> To: CF-Talk
> Subject: RE: access query crashing server...
>
> 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]
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------------------------
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]
