i changed the field "Total" to "Price" i noticed that was wrong but i still
get the same error. the data type is Currency (its an Access DB)
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Russel Madere" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 12:30 PM
Subject: RE: Data type mismatch....
> Jay,
>
> What datatype is the field Total?
>
> Make sure it is an integer or float.
>
> Russel
>
> ============================================================
> Russel Madere, Jr. Senior Web Developer
> ICQ: 5446158 http://www.TurboSquid.com
>
> Some days you eat the bear; some days the bear eats you.
> ============================================================
>
>
> > -----Original Message-----
> > From: Jay Patton [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, January 26, 2001 12:00
> > To: CF-Talk
> > Subject: Data type mismatch....
> >
> >
> > 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>
> > -->
> >
> > Thanks,
> >
> > Jay Patton
> > Web Pro USA
> > 406.549.3337 ext. 203
> > 1.888.5WEBPRO
> > www.webpro-usa.com
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
