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.
