Much simpler to just change the datatype on that field to text in the db I think. Why would you ever use an html type anyway when simple text will work? Asking as I'm not someone that uses Access for anything other than visual modeling.
Bob -----Original Message----- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 9:58 AM To: CF-Newbie Subject: RE: Access HTML field used in CF I've just tried a test here - creating a new field in an access db datatype hyperlink, which I assume is what you are using. If I enter http://www.foo.com directly into the database, then run a query and cfdump the result, the query is returning #http://www.foo.com# So the datatype is prefixing the ## around the content. This is what is causing your problem. What you need to do is remove the # signs from the returned value before you display it. Something like <CFSET cleanLink = Replace(qry_getText.link1,"##",'','ALL')> and then use that as the link. BTW, CFDUMP is a really useful debugging tool. If you don't use it a lot, you should. Will Swain Hot Horse Ltd - Web Design and Development -----Original Message----- From: Adam Parker [mailto:[EMAIL PROTECTED] Sent: 05 June 2008 14:42 To: CF-Newbie Subject: Re: Access HTML field used in CF I agree with Bob. When looking at the source of the page, the links have additional pound signs. So, either in your field for the link in the database or coded into the html, there are additional beginning and ending pound signs. To reiterate, I would keep the link record in your database as a typical link such as http://www.foo.com. Then when you code the page, use <a href="#link#">Website</a>. As for anchors, with CF, you will need to use double pound signs so the CF admin interprets them properly and does not throw an error attempting to translate between CF and html. Also, I apologize for repeating what other have said and rambling, but I've notice the page renders decently in IE 7, but in FF, the text runs together. You may consider at least using or <br /> to separate the text. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3722 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
