UPDATE QUERY WON'TWORK

ashw · Sep 25, 2002

I have developed a webpage weblinks.cfm which shows the weblinks added by the users fron another page NewWeblink.cfm. On weblinks.cfm page the name of the weblink is a link which when clicked goes to the ViewEditWeblink.cfm. Here we can edit the data and click submit to go to EditWeblinksubmit.cfm page.
I have written the following code

ViewEditWeblink.cfm Code

<CFQUERY NAME="Web" DATASOURCE="weblink">
SELECT *
FROM Tblweblink
WHERE weblinkID = #URL.weblinkID#
</CFQUERY>


<cfinclude template="/Newhome/site.css">
<script language="JavaScript">
<!--
function MM_goToURL() { //v3.0
var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
for (i=0; i<(args.length-1); i+=2) eval(args+".location='"+args[i+1]+"'&quot

;
}
//-->
</script>

<div ID="Center">
<html>
<head>
<title>View Edit Weblinks</title>

<cfquery name="departmentsearch" datasource="staffdirectory">
SELECT deptID, dept
FROM tbldepartment
</cfquery>
</head>


<cfform action="Editweblinksubmit.cfm" name="vieweditweblink"
method="POST" enctype="multipart/form-data" onsubmit="return validate(vieweditweblink)">
<body>
<table>
<th colspan="2">View Edit Web Link</th>
<tr>
<td>Site Name</td>
<td>

<cfoutput query="web">
<input type="hidden" name="weblinkID" value="#weblinkID#">

<cfinput type="text" name="weblinkName" value="#weblinkName#"
MESSAGE="Website Name is required!" REQUIRED="Yes">
</td>
</tr>
<tr>
<td>Site Address</td>
<td>
<cfinput type="text" name="weblinkaddress" value="#weblinkaddress#"
MESSAGE="Website Address is required!" REQUIRED="Yes">i.e.

http://www.uwmsp.org

</td>
</tr>
<tr>
<td>Department</td>
<td>
<cfselect name="weblinkdepartment" value="#weblinkdescription#"
MESSAGE="Department is required!" REQUIRED="yes">

<option value="">#weblinkdepartment#</option>
<cfloop query="departmentsearch">
<option value="#dept#">#dept#</option>
</cfloop>
</cfselect>
</td>
</tr>
<tr>
<td>Description</td>
<td>
<textarea name="weblinkdescription" rows="6" cols="60">"#weblinkdescription#"</textarea>

</td>
</tr>
<tr>
<td>Author</td>
<td>
<cfinput type="text" name="weblinkauthor" value="#weblinkauthor#"
MESSAGE="Author Field is required!" REQUIRED="Yes">
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
<input type="button" name="Button" value="Cancel" onClick="MM_goToURL('parent','Weblinks.cfm');return document.MM_returnValue">

</td>
</tr>
</table>
</body>
</cfoutput>
</cfform>
</div>
</html>

Editweblinksubmit.cfm Code
<html>
<head>
<title>Untitled</title>
</head>

<body>

<cfquery datasource="weblink" dbtype="ODBC">
Update tblweblink
SET weblinkName='#Trim(FORM.weblinkname)#',
weblinkAddress='#Trim(FORM.weblinkaddress)#',
weblinkDescription='#Trim(FORM.weblinkdescription)#',
weblinkDepartment='#Trim(FORM.weblinkdepartment)#',
weblinkAuthor='#Trim(FORM.weblinkauthor)#',
WHERE weblinkID=#FORM.weblinkID#
</cfquery>
<CFLOCATION url="weblink.cfm">
</body>
</html>

r937 · Sep 25, 2002

you didn't say what the problem was, so i'll guess ;-)

in ViewEditWeblink.cfm, you have cfform outside the body, in fact you have quite a number of html tags in the wrong order

in Editweblinksubmit.cfm, you don't actually need any html tags, and you have a comma in front of the WHRE keyword that will cause an sql syntax error

rudy

http://rudy.ca/

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

UPDATE QUERY WON'TWORK

ashw

MIS

r937

Technical User

Similar threads

Part and Inventory Search

Sponsor