Sound like the data type for that field is not integer or currency as the
output would suggest. That's probably why you are getting the mixed results.
If it is possible I would convert the data and type in that field to
currency and you may get better results.
Bryan
----- Original Message -----
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 6:04 PM
Subject: RE: Query Help!!
> When I get rid of the tick marks I get:
> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
> expression.
>
> Rich
>
> -----Original Message-----
> From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 4:48 PM
> To: CF-Talk
> Subject: Re: Query Help!!
>
>
> did you really mean to put the tick marks around the '#session.total#' or
> did you mean to pass that as an integer without the tick marks?
>
> Bryan
>
> ----- Original Message -----
> From: "ibtoad" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 11, 2001 3:01 PM
> Subject: Query Help!!
>
>
> > Does anyone see any problems with the following query:
> >
> > <cfquery name="get_shipratedollars" datasource="#config.datasource#">
> > Select shiprate from shipratesdollars
> > WHERE '#session.total#' >= shipfrom
> > and '#session.total#' <= shipto
> > </cfquery>
> >
> >
> > I can not figure out why I am getting incorrect results. Sometimes it
> will
> > pull more than one record and sometimes it will pull the max record
only.
> > Here is a copy of the table I am using named shipratedollars.
> >
> > ID shiprate shipfrom shipto
> > 1 4.00 0.00 50.00
> > 2 6.00 50.01 100.00
> > 3 8.00 100.01 200.00
> > 4 12.00 200.01 300.00
> > 5 18.00 300.01 500.00
> > 6 25.00 500.01 750.00
> > 7 40.00 750.01 1000.00
> > 8 50.00 1000.01 1500.00
> > 9 70.00 1500.01 2000.00
> > 10 100.00 2000.00 99999.00
> >
> >
> > Thansk,
> > Rich
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
