Since the database is for a calendar, we are using the hypertext links for agendas, handouts, etc. that will be needed at the workshops. Also, some of our guest speakers have their own websites that they would like to display before their presentations.
For now, I will have to change the field to text until I can figure out a solution. It has to be out there somewhere. Never say die! Connie Works Business Systems Specialist Center for University Teaching, Learning, and Assessment Building 53/Room 207 University of West Florida Pensacola, Florida 32514 Telephone: 1-850-474-3080; FAX: 1-850-857-6331 http://uwf.edu/cutla -----Original Message----- From: Imperial, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 9:03 AM To: CF-Newbie Subject: RE: Access HTML field used in CF 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:3724 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
