You might want to check out fckeditor. It's free and very easy to implement. It will let them enter the link by highlighting text and clicking a link button. Just store the copy as html.
http://www.fckeditor.net/ Mike Chytracek Ignite Solutions Managing Partner -----Original Message----- From: John Barrett [mailto:[email protected]] Sent: Tuesday, December 30, 2008 10:47 PM To: cf-newbie Subject: write html links to db with form Hi, I am having an real issue trying to get my form to write to the database they way that I want. I am not sure if I am missing something here. The page is located at: http://www.gotnutrients.net/admin/insert_tip.cfm There are 2 parts to the link as the text fields go, but they are only being written into the one db field? Is this a good way to do this? Basically I just need to make a way for a teacher at school to be able to fill out a form, and write web links in this way. Below is the code. Thanks so much, John --------DB Table Structure(header really)-------- record_id tiptopic dailytip tipdate consumer_link research_link These are the header in the database. Everything is normal except, I have a form with 2 text fields for dealing with the html link. One for the link, and the other for the text. <!--- insert tip---> <cfform action="tip_results.cfm" method="post"> <table width="578" border="0"> <tr> <td width="111">date</td> <td width="457"><cfinput name="tipdate" type="datefield" value="#dateformat(createodbcdate(now()),'mm/ dd/yyyy')#"/></td> </tr> <tr> <td>tip topic</td> <td><cfinput type="Text" name="tiptopic" id="tiptopic" size="50" maxlength="50"></td> </tr> <tr> <td>daily tip </td> <td><cftextarea name="dailytip" label="dailytip" id="dailytip" rows="5" cols="40"></cftextarea></td> </tr> <tr> <td width="111">Consumer Text </td> <td width="457"> <cfinput type="Text" name="consumer_text" id="consumer_text" size="50"></td> </tr> <tr> <td>Consumer Link</td> <td> <cfinput type="Text" name="consumer_link" id="consumer_link" size="50"></td> </tr> <tr> <td width="111">Research Text </td> <td width="457"> <cfinput type="Text" name="research_text" id="research_text" size="50"></td> </tr> <tr> <td>Research Link</td> <td> <cfinput type="Text" name="research_link" id="research_link" size="50"></td> </tr> </fieldset> <tr> <td> </td> <td><cfinput type = "submit" name="submit" value = "submit"></td> </tr> <tr> <td> </td> </tr> </table> </cfform> <!--- tip results---> <cfquery datasource="#REQUEST.dataSource#"> INSERT INTO daily_tip_copy(tipdate,tiptopic,dailytip,consumer_text,consumer_link,researc h_text,research_link) VALUES(<cfqueryparam cfsqltype="CF_SQL_DATE" value="#CreateODBCDate(FORM.tipdate)#">, '#FORM.tiptopic#', '#FORM.dailytip#', '<a href="#FORM.consumer_link#">#FORM.consumer_text#</a>' '<a href="#FORM.research_link#">#FORM.research_text#</a>') </cfquery> <cfparam name="form.tipdate" default="#dateformat(createodbcdate(now()),' mm/dd/yyyy' )#" /> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4252 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
