Will the query run in Access by itself? The string concatenation symbol
used in Access is the &, even though on occasion, the + seems to work.
DC
----- Original Message -----
From: Avi Flax <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 14, 2000 17:52
Subject: Wierd error on Query with a +
> Hi everyone, I have a weird problem. I moved a site from one development
> server to a new one, and now I can't run any query with a plus sign in
> it. Here's an example:
>
> SELECT c.CityID, City + ', ' + State AS CityState
> FROM T_VSCities c, J_Cities_SpecialBonus j
> WHERE c.CityID = j.CityID AND j.BonusID = #BonusID#
> ORDER BY State, City
>
> I tried many different variations on this. No matter what I do, I get an
> error when I use a plus sign anywhere!
>
> Here's the error:
>
> CMemoryException: unknown cause
>
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position
> (12:1) to (12:44).
>
> I thought at first that the problem might be different versions of the
> Access ODBC driver from one machine to the other. So I used Microsoft's
> version checker tool, and both machines seem to have the same driver
> version, 2.5. The only other real difference on the machines is that the
> newer one has SQL Server 7 installed.
>
> This seems like a CF error to me though, not a Driver error.
>
> Can anyone shed some light on this for me?
>
> Thanks,
> Avi
>
>
> -----
> Avi Flax
> Web Applications Developer
> Words In Progress, Inc.
> [EMAIL PROTECTED]
> http://www.wordsinprogress.com
>
> ------------------------------------------------------------------------
> ------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
