I am having problems putting a decimal into a SQL Server field.
The data type is decimal and I am passing the value in with
DecimalFormat(#var#) with the commas taken out (so that it is just xxxxxx.xx
and no more).
Exactly what SQL do I need to add in?
INSERT INTO...
...
VALUES
(
#decimal1#
, #decimal2#
)
or
INSERT INTO...
...
VALUES
(
'#decimal1#'
, '#decimal2#'
)
or what?
Paul
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.