numbers with decimal places to the right

2005-09-02 Thread Tim Laureska
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

Re: numbers with decimal places to the right

2005-09-02 Thread Barney Boisvert
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

RE: numbers with decimal places to the right

2005-09-02 Thread Tangorre, Michael
From: Tim Laureska [mailto:[EMAIL PROTECTED] Insert attempt: cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price# cfqueryparam cfsqltype=CF_SQL_DECIMAL value=#form.current_price# ~| Logware (www.logware.us): a

RE: numbers with decimal places to the right

2005-09-02 Thread Tangorre, Michael
From: Tim Laureska [mailto:[EMAIL PROTECTED] Insert attempt: cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price# Actually, I spoke too soon. Is the data type MONEY? If so, use MONEY in the queryparam. ~| Find

Re: numbers with decimal places to the right

2005-09-02 Thread Ryan Guill
there is also a float. On 9/2/05, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Tim Laureska [mailto:[EMAIL PROTECTED] Insert attempt: cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price# Actually, I spoke too soon. Is the data type MONEY? If so, use MONEY in the

RE: numbers with decimal places to the right

2005-09-02 Thread Tim Laureska
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

RE: numbers with decimal places to the right

2005-09-02 Thread Tim Laureska
Ah... the money/money combination worked (queryparam/fieldtype) - thanks Ryan ! -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 2:11 PM To: CF-Talk Subject: Re: numbers with decimal places to the right there is also a float. On 9/2/05

Re: numbers with decimal places to the right

2005-09-02 Thread Barney Boisvert
INT says you want integers: whole numbers without decimal parts. You should change the column to be MONEY, which will allow for fractional amounts (cents). cheers, barneyb On 9/2/05, Tim Laureska [EMAIL PROTECTED] wrote: What should it be for dollars?... int or what? I changed the

RE: numbers with decimal places to the right

2005-09-02 Thread Dave.Phillips
[mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 2:23 PM To: CF-Talk Subject: Re: numbers with decimal places to the right INT says you want integers: whole numbers without decimal parts. You should change the column to be MONEY, which will allow for fractional amounts (cents). cheers

RE: numbers with decimal places to the right

2005-09-02 Thread Tim Laureska
OK... good to know -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 3:04 PM To: CF-Talk Subject: RE: numbers with decimal places to the right If you wanted a true decimal field (not money) then you would specify column type like