<div>
<div class="content wysiwyg-content">
I have the code below which should update a table, but it has a syntax error I can't find, any help is appreciated.<br />
<br />
<br />
MM_saveCmd.CommandText =&quot;UPDATE FormsBlb SET Firmid =&quot; &amp;&nbsp;Session(&quot;FirmId&quot;) &amp;&nbsp;&quot;, Caseid =&quot; &amp;&nbsp;Session(&quot;QFcaseid&quot;) &amp;&nbsp;&quot;, Userid =&quot; &amp;&nbsp;Session(&quot;QFUserId&quot;) &amp;&nbsp;&quot;, Activityid =&quot; &amp;&nbsp;Session(&quot;QFActivityid&quot;) &amp;&nbsp;&quot;, Blobdata = '&quot; &amp;&nbsp;strXML &amp;&nbsp;&quot;') WHERE Blobid = '&quot; &amp;&nbsp;Session(&quot;QFBlobid&quot;) &amp;&nbsp;&quot;'&quot;
</div>
</div>


I have the code below which should update a table, but it has a syntax error I can't find, any help is appreciated.


MM_saveCmd.CommandText ="UPDATE FormsBlb SET Firmid =" & Session("FirmId") & ", Caseid =" & Session("QFcaseid") & ", Userid =" & Session("QFUserId") & ", Activityid =" & Session("QFActivityid") & ", Blobdata = '" & strXML & "') WHERE Blobid = '" & Session("QFBlobid") & "'"

Syntax error un update

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.