Connie, In your table calendar0809, what are the datatypes for your columns "link1" and "linkname"?
(re feeling dumb in CF, don't beat yourself up...just when I think I'm getting the hang of it I run into a new "challenge" LOL). Eugene Dew Information Technology Specialist II - Web Developer Purchasing Department University of Oklahoma 2750 Venture Drive Norman, Oklahoma 73069 Email: [EMAIL PROTECTED] Tel: 405.325.6703 Fax: 405-329-8394 Confidentiality Notice: This email message, including attachments, contains or may contain confidential information intended only for the addressee. If you are not an intended recipient of this message, be advised that any reading, dissemination, forwarding, printing, copying or other use of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by reply message and delete this email message and any attachments from your system. Thank you. -----Original Message----- From: Connie Works [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 1:42 PM To: CF-Newbie Subject: RE: Access HTML field used in CF Bob, It is nested in a cfoutput already. Do I need another one? I tried inserting just that one line in its own cfoutput, but the results were the same. This is what has been written: <CFQUERY NAME = "AUGUST2008" DATASOURCE = "cutla_calendar0809"> SELECT * FROM calendar0809 WHERE queryname = 'August 2008' ORDER BY date2 </CFQUERY> <CFOUTPUT QUERY = "AUGUST2008"> <table width = "50%" border="0" cellpadding="3" cellspacing="0"> <tr><strong>#date#<tr> <tr>#time#</strong></tr> <tr><strong>#place#</strong></tr> <tr><strong><font color = "007939">#title#</font></strong></tr> <tr><strong>#topic#</strong></tr> <tr>#presentor1#</tr> <tr>#presentor2#</tr> <tr>#presentor3#</tr> <tr>#description1#</tr> <tr><a href="#link1#">#html1#</a></tr> </table> </CFOUTPUT> The more I get into ColdFusion, the dumber I feel. 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: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 1:32 PM To: CF-Newbie Subject: RE: Access HTML field used in CF Try wrapping it in a cfouput :) -----Original Message----- From: Connie Works [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 2:27 PM To: CF-Newbie Subject: Access HTML field used in CF I am writing CF code that extracts records from an Access database. Everything works fine until I get to this line. The field "link1" is set up as an html field; all records have the complete URL in that field. The address tries to open but it is appended to the current URL that is being used in the address bar as if it was an anchor tag. For example: http://currentaddress#http://link1address#. <tr><a href="#link1#">#linkname#</a></tr> What code am I missing to make this work correctly? 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 <http://uwf.edu/cutla> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3711 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
