>
> What's the best way to post a numeric cost value, say "12.99"
> from CF into a SQL db? Currently I have the db datatype set
> to "money", and I've tried #DollarFormat(form.var)# without luck.
DO NOT use DollarFormat - it adds the $ and commas - SQL Server will
treat this as a string
If you're using CFQUERYPARAM, then there is a CF_SQL_MONEY type
If you're not using CFQUERYPARAM - WHY NOT?!?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
