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,research_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:4250
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
