Acess db query fails if w2 has a decimal place. Works if an integer.
<CFQUERY ... maxrows="1">
SELECT #ShipZonesCAUPS.Day3# AS d3, #ShipZonesCAUPS.Standard# AS st, weight
FROM ShipCanUS
WHERE (Weight >= #w2#) <!--- round up to next highest --->
</CFQUERY>
cfqueryparam shows a type mismatch using type float or numeric (not sure which is correct as the docs are so bad). Works with type integer.
Thing is same query works fine on 2 other tables that are the same setup. All have type "number" columns.
Any ideas?
*****
BTW, how to edit your account here? All account links return to the same sign in page, showing you signed in. Using Firefox. Also, can the admin add some css for spacing between the lines on the list of threads? So scrunched together they're hard to read.
******
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
