Please Help! UPDATE QUERY WON'T WORK!

ashw · Sep 23, 2002

Hi,
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 EditWeblink.cfm page where I have written the following query to update the table in the database :

<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>

However when I update, it shows the following error,

An error occurred while evaluating the expression:
#Trim(FORM.weblinkname)#
Error near line 12, column 19.

Error resolving parameter FORM.WEBLINKNAME
The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.
The error occurred while processing an element with a general identifier of (#Trim(FORM.weblinkname)#), occupying document position (12:18) to (12:41).

philhege · Sep 23, 2002

ashw, is vieweditweblink.cfm doing an actual form POST to editweblink.cfm? The error suggests that it isn't. You don't have any redirects or CFLOCATIONS hidden somewhere, do you?

ashw · Sep 23, 2002

Yeah, the vieeditweblink.cfm is directed to editweblinksubmit.cfm Let me show u the codes
(ViewEditWeblink.cfm code):

<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="#weblinkdepartment#"
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="button" name="Button" value="Cancel" onClick="MM_goToURL('parent','Weblinks.cfm');return document.MM_returnValue">

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

(EditWeblinksubmit.cfm code)

<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>

philhege · Sep 23, 2002

ashw, the form tag has to be within the BODY tag for the form to parse properly.

ashw · Sep 25, 2002

Can anyone help me on this?

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!

Please Help! UPDATE QUERY WON'T WORK!

ashw

MIS

philhege

Programmer

ashw

MIS

philhege

Programmer

ashw

MIS

Similar threads

Part and Inventory Search

Sponsor