I'm not sure of the specifics, but to troubleshoot, I'd test it by removing the CFQUERYPARAM and doing the insert.
If it is still stripping the characters, it's not CFQUERYPARAM. It's either the form or the DB. Hope that helps, at least a little bit. Cameron > I have this code... > > insert into tblRaters > (mgrEmail, raterComments) > values > (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments. > mgremail#">, > <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments. > ratingComments#"> > ) > > When someone inputs into the ratingComments variable, extraneous > characters like, (+ sign), the character gets stripped. So a Comment > like, "he's A+++" is written to the db like "he's A". > > Can someone tell me a way around this? > > thanks! Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
