Brad and Kevin Went back and tired not using the HTMLEditFormat--no difference. Also tried bypassing the CFC and argumentcollection, doing a direct update. No difference. Seems to be something only with the cfqueryparam and trim.
Again, without the trim, works as expected. With a trim, get the additional '. Should have said that using MX. Am using Access as database. Kevin: I am able to use the cfqueryparm (or regular sql) with an apostrophe IF I use the HTMLFormat on the initial field value. It's only when I added the trim that noticed the problem. Keith ----- Original Message ----- From: "Kevin Kazmierczak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 11:09 AM Subject: Re: unexpeted result with cfqueryparam > We have run across this problem also. We just didn't use cfqueryparam for > that field. What are you using for your database? We are using SQL server. > > > Kevin Kazmierczak. > - [This E-mail scanned for viruses by declude AntiVirus Software] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
