I want to thank everyone for their help on the hyperlink problem. There was no problem with the number of # signs I had, it was a translation problem between the CF and HTML languages reading the Access field. Bob, you gave me the idea when you told me to turn the hyperlink field in Access to a text field. Because I was bringing in a hyperlink to my CF program, the HTML language was thinking that it should create an anchor from the # sign and attached it the URL in the address bar. When I changed the access field to a text field, the HTML language was reading only one hyperlink <a href = "#link1#"> instead of a hyperlink with an anchor code. The " " signs were creating the second hyperlink so when I eliminated the one in Access, it was not creating a new hyperlink within a hyperlink.
Again everyone, thank you so much for your help. 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 er=25915.18792.15 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3725 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
