OK I have resolved the problems I was having.
I have one more question about MS Access. I set a field to number and have
decimal places set to auto and it rounds the numbers to whole numbers. I
then tried setting the decimal places to 2 and it still rounded the numbers.
Whats the deal with this?
Rich
-----Original Message-----
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 7:45 PM
To: CF-Talk
Subject: Re: Query Help!!
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
