Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Newbie (CF-Newbie)
ColdFusion query field error
Author: John Barrett
Short Link: http://www.houseoffusion.com/groups/cf-newbie/thread.cfm/threadid:981#4188
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>
|
May 23, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
