cfmx & cf5

[kelly]

I have a query that works fine on MX but shows this error on 5:
Invalid parser construct found on line 117 at position 55. ColdFusion was
looking at the following text:
-

Here is my query:

<cfquery name="checkserialnumber" datasource="test">
select
count(*) as MyCount
from claimdetails where serialnum >= '#prefix##suffix - 5#' AND serialnum
<= '#prefix##suffix + 5#'
</cfquery>

How do I format for 5 and MX?

Thanks!

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---