同时更新多个帖子 [英] Update Multiple Posts At same time

问题描述

你好，我想知道如果我想同时更新多个帖子，更新字符串应该是什么样的。


我从这样的表中循环出所有帖子：

Hello there i wonder how the update string should look if i want to update multiple posts at same time.

Iam looping out all post from a table like this:

展开 | 选择 | Wrap | 行号

推荐答案

任何可以帮助我的人。也许是一个简单的芒果，但应该是好的帮助=）

Anyone that can help me whit this. maybe a simple awnser but whould be nice whit help =)

你想做什么？您是否尝试将多个记录插入单个表中 - 或者您是否尝试将1个记录插入到单个表中，但是正在更新该表中的多个列？


根据代码判断下面看起来你试图插入多个记录，只是更新1列..

What are you trying to do? Are you trying to insert multiple records into a single table - or are you trying to insert 1 record into a single table, but are updating numerous columns within that table?

Judging by the code below it looks like you''re trying to insert multiple records and are simply updating 1 column..

dim i

如果request.querystring（" do"）=" spara_traktamente"然后

for i = 0 to request.form（" belopp"）。count

objconn.execute（" update lander_belopp set belopp =''"& request.form（" belopp"）（i）&"''"）

next

end if if

dim i
if request.querystring("do") = "spara_traktamente" then
for i = 0 to request.form("belopp").count
objconn.execute("update lander_belopp set belopp=''" & request.form("belopp")(i) & "''")
next
end if

如果是这种情况，你可以尝试这个..

If that''s the case, you could try this..

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

你提出的代码是我想做的但是不行。我改了一下但得到了这个


Microsoft JET数据库引擎错误''80040e07''


标准表达式中的数据类型不匹配。


这是修改过的：

The code you postet is what i want to do but dont work. i changed it a bit but get this

Microsoft JET Database Engine error ''80040e07''

Data type mismatch in criteria expression.

Here is the modifyed:

展开 | 选择 | Wrap | 行号

这篇关于同时更新多个帖子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！