There was something on Allaire's site about concatenation and crashing, You
might want to do a search there.
-----Original Message-----
From: Russell Jones [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 12:48 PM
To: CF-Talk
Subject: Re: access query crashing server...
You don't need the ()'s in access I don't believe.
--
Russell Jones
Webmaster
ImproveNow.com
Phone: 207.236.0146
e-mail: [EMAIL PROTECTED]
> From: "Deanna L. Schneider" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 1 Nov 2000 14:25:54 -0600
> To: CF-Talk <[EMAIL PROTECTED]>
> 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]
------------------------------------------------------------------------------------------------
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]
