> I have a CF application that was originally written for use with MS
> Access.
> Everytime I run a query, it throws an error "Cannot insert the value
> NULL". The errors are occurring because the variables are written in
> Access boolean values when it requires SQL statements. Does anyone know
> the correct coversions for the application code at the end of the page?
>Correct Access Example:
><!--- Default the AllDay variable to false if it is not clicked --->
><cfif NOT parameterExists(uploadDoc)>
> <cfset uploadDoc = False>
><cfelse>
><cfset uploadDoc = attributes.uploadDoc>
></cfif>
IIRC, if you use TRUE and FALSE in cfqueryparam it works correctly.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
