> can anyone help me with this? i get this error on my checkout page...
> ODBC Error Code = 22005 (Error in assignment)
>
> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
> criteria expression.
>
> The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position (2:1) to (2:61).
>
> this is my query:
> <!---
> <cfquery name="GetTotal" datasource="????????" dbtype="ODBC">
> SELECT Sum(Total) AS OrderTotal
> FROM StoreOrders
> WHERE SessionID = #CFTOKEN#
> AND Processed = 0
> </cfquery>
> -->
OK, what data types are Total, SessionID and Processed?
I'm assuming at they're all Numeric if this is going to work - if any
aren't, then that's your problem
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
