you'd need to do a <cfset thisSuffix = suffix - 5> or #evaluate(suffix -5)#
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 27, 2004 11:45 AM
Subject: cfmx & cf5
> 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]
