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
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
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
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
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
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
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
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
[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
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
10 matches
Mail list logo