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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
