What should it be for dollars?... int or what? I changed the queryparam to : CF_SQL_DECIMAL
And currently have the field type as INT but that combination doesn't cut it either -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 2:01 PM To: CF-Talk Subject: Re: numbers with decimal places to the right What's the datatype of your column in the DB? Is it integral? If it's DECIMAL, how many spaces are allocated for fractional amounts? cheers, barneyb On 9/2/05, Tim Laureska <[EMAIL PROTECTED]> wrote: > Embarrassed to ask, but can't figure it out: > > Trying to insert a number such as 2.65 into a MSSql server db using > this: > > Form: <INPUT TYPE="TEXT" NAME="current_price " SIZE="10" value=""> > > Insert attempt: > <cfqueryparam cfsqltype="CF_SQL_numeric" value="#form.current_price#"> > > but no matter what data type I seem to select in SQL server for the > field type the number inserts as a whole number (3) > > must be blatantly obvious to everone but me :-) > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54