Paul
You don't need the quotes around it.......
INSERT INTO <tablename> (<decimalfield1>, <decimalfield2>)
VALUES (#decimal1#, #decimal2#)
I'm not sure this is the problem that you were getting the other day but if
this doesn't work let us know the error message you get.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 06 October 2000 13:22
To: CF-Talk
Subject: SQL Server Decimal
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.
------------------------------------------------------------------------------
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.