Converting data type varchar to data type money

[schaudry]

Hi all,

Tearing my hair out trying to figure this out. If anyone can provide any help
i would greatly appreciate it. When I try to do an insert into my MS SQL
Database, keep getting following error....

[Macromedia][SQLServer JDBC Driver][SQLServer]Disallowed implicit conversion
from data type varchar to data type money, table
'05NeoCon.dbo.RegistrationT', column 'AmtPaid'. Use the
CONVERT function to run this query.

The error occurred in D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line
21
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 9
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 7
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 1
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 21
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 9
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 7
Called from D:\mmpi\showreg\neoconseminar\scout\insertdata.cfm : line 1

19 : '<cfloop from="1" to="#arrayLen(session.semcart)#"
index="i">#DollarFormat('#session.semcart.ActCost# ')##chr(13)##chr(10)#</cfloop>
',
20 : '<cfloop from="1" to="#arrayLen(session.semcart)#"
index="i">#rtrim('#session.semcart.ActTime#')##chr (13)##chr(10)#</cfloop>',
21 :
#DollarFormat('#session.totalprice#')#,'#session.S pamPhone#','#session.SpamFax#'
,'#session.SpamEmail#','#session.SpamMail#','#sess ion.Spam3rdParty#');
22 : </cfquery>
23 :


First off, can someone please explain why i'm getting this error? And also,
can you please tell me how I would convert #session.totalprice# from data type
varchar to data type money in order to make SQL happy? Thanks in advance for
your help.

Salman

[Fychan66]

Instead of dollarformat() (which I think inserts the $ symbol before the price)
have you tried LSCurrencyFormat( session.totalprice, "none" ) instead? This
will convert the total price into the 0.00 formatted datatype I guess you're
looking for.

Phil