Hi,
I have a strange problem that I don't understand.
the page is at:
http://www.gotnutrients.net/adminNew/update_DB.cfm
the text filed for the links, why can I not get the data into the fields?
the database record is,
customer_links--<a href="john2">john2</a>
same problem for the research_links
seems like because they are links they are causing an issue. I am trying to put
the links from the database on this form in case I want to update them. The
action page is not written so the form does not work.
Thanks so much,
John
below is the code:
<html>
<head>
<title>Update Database</title>
</head>
<body>
<cfquery name="GetRecordtoUpdate"
datasource="mydatasource">
SELECT * FROM mydatabasetable
</cfquery>
<cfoutput query="GetRecordtoUpdate">
<table width="553">
<form action="update_action.cfm" method="Post">
<tr>
<td>record id</td>
<td><input type="text" name="record_id" value="#record_id#"></td>
</tr>
<tr>
<td>tiptopic</td>
<td><input type="text" name="tiptopic" value="#tiptopic#"></td>
</tr>
<tr>
<td>dailytip</td>
<td><input type="text" name="dailytip" value="#dailytip#"></td>
</tr>
<tr>
<td>tipdate</td>
<td><input type="text" name="tipdate" value="#tipdate#"></td>
</tr>
<tr>
<td>consumer_link</td>
<td><input type="text" name="consumer_link"
value="#consumer_link#"></td>
</tr>
<tr>
<td>research_link</td>
<td><input type="text" name="research_link"
value="#research_link#"></td>
</tr>
<tr>
<td> </td>
<td><input type="Submit" value="Update Information"></td>
</tr>
</form>
</table>
</cfoutput>
Current Database
<cfquery name="db" datasource="mydatasource">
SELECT *
FROM mydatabasetable
</cfquery>
<table width="943" border="1">
<tr>
<td width="96">record_id</td>
<td width="166">tiptopic</td>
<td width="208">dailytip</td>
<td width="112">tipdate</td>
<td width="129">consumer_link</td>
<td width="192">research_link</td>
</tr>
<cfoutput query="db">
<tr>
<td>#db.record_id#</td>
<td>#db.tiptopic#</td>
<td>#db.dailytip#</td>
<td>#db.tipdate#</td>
<td>#db.consumer_link#</td>
<td>#db.research_link#</td>
</tr>
</cfoutput>
</table>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4188
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
