ColdFusion SQL更新与形式 [英] ColdFusion SQL update with form

问题描述

<cfelseif ARGUMENTS.myForm.Submit EQ "Update_what">
    <cfquery name="LOCAL.myURL" datasource="#SERVER.cfc.core.getDSN()#">
        SELECT What_name 
        FROM logboek.tbl_What 
        WHERE What_name = <cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.myForm.What_name#" />
    </cfquery>
    <cfif LOCAL.myURL.RecordCount eq 0>
        <cfreturn VARIABLES.Error.myReturn />   
    <cfelse>
        <cfquery name="LOCAL.myURL" datasource="#SERVER.cfc.core.getDSN()#">
        UPDATE logboek.tbl_What
        SET What_name=<cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.myForm.What_name#" />;
        WHERE What_name=<cfqueryparam value="#ARGUMENTS.myForm.What_name#" cfsqltype="cf_sql_varchar">
        </cfquery>
    </cfif> 

我重写了我的代码，但现在我得到以下错误：

I rewrote my code but now I get the following error:

queryError string UPDATE logboek.tbl_What SET What_name ='HTML'; WHERE What_name ='HTML'。

queryError string UPDATE logboek.tbl_What SET What_name='HTML'; WHERE What_name='HTML'.

这是我的表单代码：

<form action="blog.Logboek" method="post" name="Update_what">
    <input type="Text" name="What_name" placeholder="Type what you want to update:">
    <input name="requiredFields"type="hidden" value="What_name" /> 
    <input type="Submit" name="Submit" value="Update_what">
</form>

那么为什么我不能根据需要更新表单？

So why can't I update with a form as I want? Can someone give an example of an update with a form?

推荐答案

尝试更改

UPDATE logboek.tbl_What SET What_name=<cfqueryparam
cfsqltype="cf_sql_varchar" value="#ARGUMENTS.myForm.What_name#" />;
WHERE What_name=<cfqueryparam value="#ARGUMENTS.myForm.What_name#"
cfsqltype="cf_sql_varchar">

到

UPDATE logboek.tbl_What SET What_name=<cfqueryparam
cfsqltype="cf_sql_varchar" value="#ARGUMENTS.myForm.What_name#" />
WHERE What_name=<cfqueryparam value="#ARGUMENTS.myForm.What_name#"
cfsqltype="cf_sql_varchar">

在设置的What_name行的末尾。

I removed the ; at the end of the set What_name row.

这篇关于ColdFusion SQL更新与形式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！