Access query fails after upgrade to MX 7.1

[VJIN]

After upgrading to ColdFusion MX 7.1, the following query (against an Access
2000 database) errors out on the *** field when running the ColdFusion
application displaying error: ?Too few parameters. Expected 1? message.
We first thought it was the length of the field name, but we have other field
names that are longer (I?ve removed them for this sample). When we remove this
field name from the query the query works.

I have another similar query using the same field name and it fails there as
well.

This code has been running on MX 6.1 for several years. Any suggestions?

<CFQUERY NAME="AuditLog" DATASOURCE="Contracts">

SELECT AUTONUMBER,
TRACKING_DATE,
AuditLog.EntityID,
[ENTITY ADDRESS INFO].[ENTITY NAME] As EntityName,
[CONTRACT AMOUNT] AS AMOUNT,
[CONTRACT PERIOD] AS STARTING,
ENDING,
*** [CONTRACT FROM FIELD WITH SIGNATURE] AS FRFIELD,
COMMENTS,
JUSTIFICATION_MONEY AS SERVICE
FROM [ENTITY ADDRESS INFO] INNER JOIN AuditLog ON ([ENTITY ADDRESS
INFO].EntityId = AuditLog.EntityID) AND ([ENTITY ADDRESS INFO].EntityId =
AuditLog.EntityID)
WHERE autonumber = #url.autonumber#
</CFQUERY>

Thanks
VJ

[paross1]

This is just a guess, but it is probably finding the FROM after CONTRACT and
stopping there. If you could change this column name, or at least join the
words with an underscore, you will probably fix the problem.

By the way, who was the database genius that came up with the column names?
There should a place in hell reserved for him/her. :evil;

Phil