{"id":42,"date":"2007-07-13T23:53:14","date_gmt":"2007-07-13T23:53:14","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?page_id=42"},"modified":"2008-01-18T16:28:54","modified_gmt":"2008-01-18T16:28:54","slug":"function-updaterow","status":"publish","type":"page","link":"https:\/\/www.wapshere.com\/missmiis\/code-snippets\/function-updaterow","title":{"rendered":"NWHomeDir_CSExtension.vb: Function updateRow"},"content":{"rendered":"

This function updates a row in a SQL table. There is probably a way to do it all with one query, but when I wrote it\u00c2\u00a0I was pretty new to SQL, and because it worked I didn’t change it. \u00c2\u00a0<\/p>\n

Private<\/font> <\/font>Function<\/font> updateRow(<\/font>ByVal<\/font> path <\/font>As<\/font> <\/font>String<\/font>, <\/font>ByVal<\/font> stringDN <\/font>As<\/font> <\/font>String<\/font>, <\/font>ByVal<\/font> Server <\/font>As<\/font> <\/font>String<\/font>, <\/font>ByVal<\/font> Volume <\/font>As<\/font> <\/font>String<\/font>, <\/font>ByVal<\/font> Folder <\/font>As<\/font> <\/font>String<\/font>, <\/font>ByVal<\/font> Status <\/font>As<\/font> <\/font>String<\/font>) <\/font>As<\/font> <\/font>Integer<\/font><\/p>\n

\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Dim<\/font> modSQL <\/font>As<\/font> <\/font>String<\/font><\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Dim<\/font> sqlModCommand As<\/font> SqlCommand<\/font><\/p>\n

\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 If<\/font> stringDN = “NULL” Then<\/font> <\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 modSQL = “UPDATE ” & MIISSync_DB_TABLE_NAME & ” SET stringDN = NULL where path='” & path & “‘”<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Else<\/font><\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 modSQL = “UPDATE ” & MIISSync_DB_TABLE_NAME & ” SET stringDN ='” & stringDN & “‘ where path='” & path & “‘”<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 End<\/font> If<\/font><\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand = New<\/font> SqlCommand(modSQL, sqlExportConnection)<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand.ExecuteNonQuery()<\/font><\/p>\n

\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 modSQL = “UPDATE ” & MIISSync_DB_TABLE_NAME & ” SET Server ='” & Server & “‘ where path='” & path & “‘”<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand = New<\/font> SqlCommand(modSQL, sqlExportConnection)<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand.ExecuteNonQuery()<\/font><\/p>\n

\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 modSQL = “UPDATE ” & MIISSync_DB_TABLE_NAME & ” SET Volume ='” & Volume & “‘ where path='” & path & “‘”<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand = New<\/font> SqlCommand(modSQL, sqlExportConnection)<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand.ExecuteNonQuery()<\/font><\/p>\n

\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 modSQL = “UPDATE ” & MIISSync_DB_TABLE_NAME & ” SET Folder ='” & Folder & “‘ where path='” & path & “‘”<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand = New<\/font> SqlCommand(modSQL, sqlExportConnection)<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand.ExecuteNonQuery()<\/font><\/p>\n

\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 modSQL = “UPDATE ” & MIISSync_DB_TABLE_NAME & ” SET Status ='” & Status & “‘ where path='” & path & “‘”<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sqlModCommand = New<\/font> SqlCommand(modSQL, sqlExportConnection)<\/font>
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 Return<\/font> sqlModCommand.ExecuteNonQuery()<\/font><\/p>\n

End<\/font> Function<\/font><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

This function updates a row in a SQL table. There is probably a way to do it all with one query, but when I wrote it\u00c2\u00a0I was pretty new to SQL, and because it worked I didn’t change it. \u00c2\u00a0 Private Function updateRow(ByVal path As String, ByVal stringDN As String, ByVal Server As String, ByVal…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":30,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-42","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/Pkp1o-G","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":0,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/42\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/30"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}