插入多条记录 [英] insert multiple records

查看:94
本文介绍了插入多条记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试使用在线示例将ASP

中的多条记录提交到存储过程中。失败!通过以下表格,用户可以一次提交许多记录。我没有插入任何记录。对于

故障排除,我将表格缩减为1个文本框,并在提交时

填充5行相同的数据。所以我知道我已经联系了,但没有得到LOOP和NEXT正确的
?如何设置这么多记录可以插入?b $ b?我没看到什么?

谢谢!


======< FORM> ======

< form action =" test.asp"方法= QUOT;交" name =" frmSortKey">

< table>

< tr>

< td class =" colhead"> ;新#< / td>

< / tr>

<%

while((Repeat1__numRows<> 0) AND(不是rsSongs.EOF))

%>

< tr>

< td class =" resultsright">

< input name =" SK" type =" text"

value ="<%=(rsSongs.Fields.Item(" SortKey")。Value)%> "大小= QUOT; 3英寸maxlength =" 2"

style =" text-align:right">

< input name =" PID" type =" hidden"

value ="<%=(rsSongs.Fields.Item(" ProjectID")。。Value)%>">

< input name =" IDD" type =" hidden"

value ="<%=(rsSongs.Fields.Item(" ID")。Value)%>">

< / td>

< / tr>

<%

Repeat1__index = Repeat1__index + 1

Repeat1__numRows = Repeat1__numRows-1

rsSongs.MoveNext()

Wend

%>

< / table>

< input name =" SubmitNow"类型= QUOT;隐藏" value =" 1">

< input name =" Submit"类型= [提交" value ="更改曲目编号>

< / form>


====== TEST.ASP代码===== =

<%

Dim rsTracks__PID

rsTracks__PID =" 0"

if(Request(") PID"<>"")然后rsTracks__PID =请求(PID)


Dim rsTracks__SK

rsTracks__SK =" 0"

if(请求(" SK")<>"")然后rsTracks__SK =请求(" SK")

Dim rsTracks__IDD

rsTracks__IDD =" 0"

if(Request(" IDD")<>"")then rsTracks__IDD = Request(" IDD")


%>

<%

FOR i = 1到5

set rsTracks = Server.CreateObject(" ADODB.Command")

rsTracks.ActiveConnection = MM_STRING

rsTracks.CommandText =" admin.stp_DOD_TrackNumbers"

rsTracks.CommandType = 4

rsTracks.CommandT imeout = 0

rsTracks.Prepared = true

rsTracks.Parameters.Append rsTracks.CreateParameter(" @ RETURN_VALUE",3,4)

rsTracks.Parameters.Append rsTracks.CreateParameter(" @ PID",3,

1,9,rsTracks__PID)

rsTracks.Parameters.Append rsTracks.CreateParameter(" ; @ SK&,3,

1,9,rsTracks__SK)

rsTracks.Parameters.Append rsTracks.CreateParameter(" @ @ IDD",3,

1,9,rsTracks__IDD)

rsTracks.Execute()


NEXT

MM_STRING.close

设置MM_STRING =没有

%>


======存储过程======

CREATE PROCEDURE stp_DOD_TrackNumbers

@PID int,@ SK int,@ IDD int

AS


INSERT INTO tmpDODSongs (ProjectID,SortKey,OldIDD)

VALUES(@ PID,@ SK,@ IDD)

GO


=== === TEST.ASP输出======

这...

<%=请求(" PID")%>&l t; br>

<%=请求(" SK")%>< br>

<%=请求(" IDD")% >< br>< br>

产生这个...

24,24,24,24,24,24,24,24,24,24 ,24,24,24,24,24,24,24

1,2,3,4,5,6,7,8,9,10,11,12,13,14, 15,16,17

121,122,123,124,125,126,127,130,131,132,133,134,135,136,137,

138,139

I''m trying to use online samples for submitting multiple records from ASP
into a stored procedure. Failing! Through the below form, a user could be
submitting many records at a time. I''m not getting any records inserted. For
troubleshooting, I cut the form down to 1 textbox and when submitted it
populated 5 rows of the same data. So I know I''m connected, but not getting
the LOOP and NEXT correct? How do I set this up so many records can be
inserted? What am I not seeing?
thanks!

====== <FORM> ======
<form action="test.asp" method="post" name="frmSortKey">
<table>
<tr>
<td class="colhead">New#</td>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsright">
<input name="SK" type="text"
value="<%=(rsSongs.Fields.Item("SortKey").Value)%> " size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSongs.Fields.Item("ProjectID").Value) %>">
<input name="IDD" type="hidden"
value="<%=(rsSongs.Fields.Item("ID").Value)%>">
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsSongs.MoveNext()
Wend
%>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change track numbers">
</form>

====== TEST.ASP code ======
<%
Dim rsTracks__PID
rsTracks__PID = "0"
if(Request("PID") <> "") then rsTracks__PID = Request("PID")

Dim rsTracks__SK
rsTracks__SK = "0"
if(Request("SK") <> "") then rsTracks__SK = Request("SK")

Dim rsTracks__IDD
rsTracks__IDD = "0"
if(Request("IDD") <> "") then rsTracks__IDD = Request("IDD")

%>
<%
FOR i = 1 to 5
set rsTracks = Server.CreateObject("ADODB.Command")
rsTracks.ActiveConnection = MM_STRING
rsTracks.CommandText = "admin.stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true
rsTracks.Parameters.Append rsTracks.CreateParameter("@RETURN_VALUE", 3, 4)
rsTracks.Parameters.Append rsTracks.CreateParameter("@PID", 3,
1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter("@SK", 3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter("@IDD", 3,
1,9,rsTracks__IDD)
rsTracks.Execute()

NEXT
MM_STRING.close
set MM_STRING=nothing
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNumbers
@PID int, @SK int, @IDD int
AS

INSERT INTO tmpDODSongs (ProjectID, SortKey, OldIDD)
VALUES (@PID, @SK, @IDD)
GO

====== TEST.ASP output ======
This...
<%=Request("PID")%><br>
<%=Request("SK")%><br>
<%=Request("IDD")%><br><br>
Produces this...
24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17
121, 122, 123, 124, 125, 126, 127, 130, 131, 132, 133, 134, 135, 136, 137,
138, 139

推荐答案

Couldent现货一切


尝试使用


**

直到rsSongs.EOF


rsSongs.MoveNext

loop

**


为什么?


我知道它可以用于记录集(但是我们应该这样做时)

" shank" < SH *** @ tampabay.rr.com>在消息中写道

新闻:eC ************** @ TK2MSFTNGP09.phx.gbl ...
Couldent spot anything

By try using

**
do untill rsSongs.EOF

rsSongs.MoveNext
loop
**

Why?

I know that works with a recordset (But so should while wend)
"shank" <sh***@tampabay.rr.com> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...
我正在尝试使用在线样本将ASP中的多条记录提交到存储过程中。失败!通过以下表格,用户可以一次提交许多记录。我没有插入任何记录。
为了排除故障,我将表格缩减为1个文本框,当提交时,它填充了5行相同的数据。所以我知道我已经联系了,但没有获得LOOP和NEXT正确吗?如何设置这么多可以插入的记录?我没看到什么?
谢谢!

======< FORM> ======
< form action =" test.asp"方法= QUOT;交" name =" frmSortKey">
< table>
< tr>
< td class =" colhead"> New#< / td>
< / tr>
<%
while((Repeat1__numRows<> 0)AND(NOT rsSongs.EOF))
%>
< tr>
< td class =" resultsright">
< input name =" SK" type =" text"
value ="<%=(rsSongs.Fields.Item(" SortKey")。value)%> "大小= QUOT; 3英寸maxlength =" 2"
style =" text-align:right">
< input name =" PID" type =" hidden"
value ="<%=(rsSongs.Fields.Item(" ProjectID")。。Value)%>">
< input name =" ; IDD" type =" hidden"
value ="<%=(rsSongs.Fields.Item(" ID")。Value)%>">
< / td>
< / tr>
<%
Repeat1__index = Repeat1__index + 1
Repeat1__numRows = Repeat1__numRows-1
rsSongs.MoveNext()
Wend
%>
< / table>
< input name =" SubmitNow"类型= QUOT;隐藏" value =" 1">
< input name ="提交"类型= [提交" value ="更改曲目编号"
< / form>

====== TEST.ASP代码======
<%
Dim rsTracks__PID
rsTracks__PID =" 0"
if(Request(PID)<>"")then rsTracks__PID = Request(PID)

Dim rsTracks__SK
rsTracks__SK =" 0"
if(Request(" SK")<>"")then rsTracks__SK = Request(" SK")

Dim rsTracks__IDD
rsTracks__IDD =" 0"
if(Request(" IDD")<>"")then rsTracks__IDD = Request(" IDD") ;)

%>
<%
FOR i = 1到5
设置rsTracks = Server.CreateObject(" ADODB.Command")
rsTracks.CommandText =" admin.stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true
rsTracks.Parameters.Append rsTracks.CreateParameter(&quo t; @ RETURN_VALUE",3,4)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ PID",3,
1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ SK",3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ @ IDD",3,
1,9 ,rsTracks__IDD)
rsTracks.Execute()

下一个
MM_STRING.close
设置MM_STRING =没有
%>
======存储过程======
创建过程stp_DOD_TrackNumbers
@ PID int,@ SK int,@ IDD int
AS

INSERT INTO tmpDODSongs(ProjectID,SortKey,OldIDD)
VALUES(@ PID,@ SK,@ IDD)
GO

====== TEST.ASP输出== ====
这......
<%=请求(" PID")%>< br>
<%=请求(" SK")% >< br>
<%=请求(" IDD")%>< br>< br>
制作此...
24,24,24 ,24,24,24,24,24,24,24,24,24,24,24,24,24,24
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17
121,122,123,124,125,126,127 ,130,131,132,133,134,135,136,137,
138,139
I''m trying to use online samples for submitting multiple records from ASP
into a stored procedure. Failing! Through the below form, a user could be
submitting many records at a time. I''m not getting any records inserted.
For troubleshooting, I cut the form down to 1 textbox and when submitted
it populated 5 rows of the same data. So I know I''m connected, but not
getting the LOOP and NEXT correct? How do I set this up so many records
can be inserted? What am I not seeing?
thanks!

====== <FORM> ======
<form action="test.asp" method="post" name="frmSortKey">
<table>
<tr>
<td class="colhead">New#</td>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsright">
<input name="SK" type="text"
value="<%=(rsSongs.Fields.Item("SortKey").Value)%> " size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSongs.Fields.Item("ProjectID").Value) %>">
<input name="IDD" type="hidden"
value="<%=(rsSongs.Fields.Item("ID").Value)%>">
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsSongs.MoveNext()
Wend
%>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change track numbers">
</form>

====== TEST.ASP code ======
<%
Dim rsTracks__PID
rsTracks__PID = "0"
if(Request("PID") <> "") then rsTracks__PID = Request("PID")

Dim rsTracks__SK
rsTracks__SK = "0"
if(Request("SK") <> "") then rsTracks__SK = Request("SK")

Dim rsTracks__IDD
rsTracks__IDD = "0"
if(Request("IDD") <> "") then rsTracks__IDD = Request("IDD")

%>
<%
FOR i = 1 to 5
set rsTracks = Server.CreateObject("ADODB.Command")
rsTracks.ActiveConnection = MM_STRING
rsTracks.CommandText = "admin.stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true
rsTracks.Parameters.Append rsTracks.CreateParameter("@RETURN_VALUE", 3, 4)
rsTracks.Parameters.Append rsTracks.CreateParameter("@PID", 3,
1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter("@SK", 3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter("@IDD", 3,
1,9,rsTracks__IDD)
rsTracks.Execute()

NEXT
MM_STRING.close
set MM_STRING=nothing
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNumbers
@PID int, @SK int, @IDD int
AS

INSERT INTO tmpDODSongs (ProjectID, SortKey, OldIDD)
VALUES (@PID, @SK, @IDD)
GO

====== TEST.ASP output ======
This...
<%=Request("PID")%><br>
<%=Request("SK")%><br>
<%=Request("IDD")%><br><br>
Produces this...
24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17
121, 122, 123, 124, 125, 126, 127, 130, 131, 132, 133, 134, 135, 136, 137,
138, 139



" shank" ; < SH *** @ tampabay.rr.com>在消息中写道

新闻:eC ************** @ TK2MSFTNGP09.phx.gbl ...
"shank" <sh***@tampabay.rr.com> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...
我正在尝试使用在线样本将ASP中的多条记录提交到存储过程中。失败!通过以下表格,用户可以一次提交许多记录。我没有插入任何记录。
为了排除故障,我将表格缩减为1个文本框,当提交时,它填充了5行相同的数据。所以我知道我已经联系了,但没有获得LOOP和NEXT正确吗?如何设置这么多可以插入的记录?我没看到什么?


Dunno。我不是专家,但for / next循环似乎包含了我认为应该在循环之外的行。以下建议

有帮助吗?

<%
FOR i = 1到5


我'' d移动上面的行...

set rsTracks = Server.CreateObject(" ADODB.Command")
rsTracks.ActiveConnection = MM_STRING
rsTracks.CommandText =" admin .stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true


....到这里。

rsTracks.Parameters.Append rsTracks.CreateParameter(" @ RETURN_VALUE",3,4)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ PID",3, 1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ SK",3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter (@ IDD,3,
1,9,rsTracks__IDD)
rsTracks.Execute()

NEXT
I''m trying to use online samples for submitting multiple records from ASP
into a stored procedure. Failing! Through the below form, a user could be
submitting many records at a time. I''m not getting any records inserted.
For troubleshooting, I cut the form down to 1 textbox and when submitted
it populated 5 rows of the same data. So I know I''m connected, but not
getting the LOOP and NEXT correct? How do I set this up so many records
can be inserted? What am I not seeing?
Dunno. I''m no expert but the for/next loop seems to enclose lines which I''d
have thought should be outside the loop. Does the following suggestiong
help?
<%
FOR i = 1 to 5
I''d move the above line...
set rsTracks = Server.CreateObject("ADODB.Command")
rsTracks.ActiveConnection = MM_STRING
rsTracks.CommandText = "admin.stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true
....to here.
rsTracks.Parameters.Append rsTracks.CreateParameter("@RETURN_VALUE", 3, 4)
rsTracks.Parameters.Append rsTracks.CreateParameter("@PID", 3,
1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter("@SK", 3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter("@IDD", 3,
1,9,rsTracks__IDD)
rsTracks.Execute()

NEXT



因为您有多个与您读同名的字段回复一个集合。

即。 Resquest.Form(MyField)返回所有5个字段的值。我会使用

Request.Form(MyField)(i)(如果我还记得)提取

特定行的值。


-


" shank" < SH *** @ tampabay.rr.com> écritdansle message de

news:eC ************** @ TK2MSFTNGP09.phx.gbl ...
As you have multiple fields wiht the same name you read back a collection.
Ie. Resquest.Form("MyField") returns the value for all 5 fields. I would use
Request.Form("MyField")(i) (if I remember) to extract the value for a
particular line.

--

"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:eC**************@TK2MSFTNGP09.phx.gbl...
我'我试图使用在线样本将ASP中的多条记录提交到存储过程中。失败!通过以下表格,用户可以一次提交许多记录。我没有插入任何记录。
为了排除故障,我将表格缩减为1个文本框,并在提交时
填充5行相同的数据。所以我知道我已经联系了,但不是
获得LOOP和NEXT正确吗?如何设置这么多可以插入的记录?我没看到什么?
谢谢!

======< FORM> ======
< form action =" test.asp"方法= QUOT;交" name =" frmSortKey">
< table>
< tr>
< td class =" colhead"> New#< / td>
< / tr>
<%
while((Repeat1__numRows<> 0)AND(NOT rsSongs.EOF))
%>
< tr>
< td class =" resultsright">
< input name =" SK" type =" text"
value ="<%=(rsSongs.Fields.Item(" SortKey")。value)%> "大小= QUOT; 3英寸maxlength =" 2"
style =" text-align:right">
< input name =" PID" type =" hidden"
value ="<%=(rsSongs.Fields.Item(" ProjectID")。。Value)%>">
< input name =" ; IDD" type =" hidden"
value ="<%=(rsSongs.Fields.Item(" ID")。Value)%>">
< / td>
< / tr>
<%
Repeat1__index = Repeat1__index + 1
Repeat1__numRows = Repeat1__numRows-1
rsSongs.MoveNext()
Wend
%>
< / table>
< input name =" SubmitNow"类型= QUOT;隐藏" value =" 1">
< input name ="提交"类型= [提交" value ="更改曲目编号"
< / form>

====== TEST.ASP代码======
<%
Dim rsTracks__PID
rsTracks__PID =" 0"
if(Request(PID)<>"")then rsTracks__PID = Request(PID)

Dim rsTracks__SK
rsTracks__SK =" 0"
if(Request(" SK")<>"")then rsTracks__SK = Request(" SK")

Dim rsTracks__IDD
rsTracks__IDD =" 0"
if(Request(" IDD")<>"")then rsTracks__IDD = Request(" IDD") ;)

%>
<%
FOR i = 1到5
设置rsTracks = Server.CreateObject(" ADODB.Command")
rsTracks.CommandText =" admin.stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true
rsTracks.Parameters.Append rsTracks.CreateParameter(&quo t; @ RETURN_VALUE",3,4)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ PID",3,
1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ SK",3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter(" @ @ IDD",3,
1,9 ,rsTracks__IDD)
rsTracks.Execute()

下一个
MM_STRING.close
设置MM_STRING =没有
%>
======存储过程======
创建过程stp_DOD_TrackNumbers
@ PID int,@ SK int,@ IDD int
AS

INSERT INTO tmpDODSongs(ProjectID,SortKey,OldIDD)
VALUES(@ PID,@ SK,@ IDD)
GO

====== TEST.ASP输出== ====
这......
<%=请求(" PID")%>< br>
<%=请求(" SK")% >< br>
<%=请求(" IDD")%>< br>< br>
制作此...
24,24,24 ,24,24,24,24,24,24,24,24,24,24,24,24,24,24 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17
121,122,123,124,125,126, 127,130,131,132,133,134,135,136,137,
138,139
I''m trying to use online samples for submitting multiple records from ASP
into a stored procedure. Failing! Through the below form, a user could be
submitting many records at a time. I''m not getting any records inserted. For troubleshooting, I cut the form down to 1 textbox and when submitted it
populated 5 rows of the same data. So I know I''m connected, but not getting the LOOP and NEXT correct? How do I set this up so many records can be
inserted? What am I not seeing?
thanks!

====== <FORM> ======
<form action="test.asp" method="post" name="frmSortKey">
<table>
<tr>
<td class="colhead">New#</td>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsright">
<input name="SK" type="text"
value="<%=(rsSongs.Fields.Item("SortKey").Value)%> " size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSongs.Fields.Item("ProjectID").Value) %>">
<input name="IDD" type="hidden"
value="<%=(rsSongs.Fields.Item("ID").Value)%>">
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsSongs.MoveNext()
Wend
%>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change track numbers">
</form>

====== TEST.ASP code ======
<%
Dim rsTracks__PID
rsTracks__PID = "0"
if(Request("PID") <> "") then rsTracks__PID = Request("PID")

Dim rsTracks__SK
rsTracks__SK = "0"
if(Request("SK") <> "") then rsTracks__SK = Request("SK")

Dim rsTracks__IDD
rsTracks__IDD = "0"
if(Request("IDD") <> "") then rsTracks__IDD = Request("IDD")

%>
<%
FOR i = 1 to 5
set rsTracks = Server.CreateObject("ADODB.Command")
rsTracks.ActiveConnection = MM_STRING
rsTracks.CommandText = "admin.stp_DOD_TrackNumbers"
rsTracks.CommandType = 4
rsTracks.CommandTimeout = 0
rsTracks.Prepared = true
rsTracks.Parameters.Append rsTracks.CreateParameter("@RETURN_VALUE", 3, 4)
rsTracks.Parameters.Append rsTracks.CreateParameter("@PID", 3,
1,9,rsTracks__PID)
rsTracks.Parameters.Append rsTracks.CreateParameter("@SK", 3,
1,9,rsTracks__SK)
rsTracks.Parameters.Append rsTracks.CreateParameter("@IDD", 3,
1,9,rsTracks__IDD)
rsTracks.Execute()

NEXT
MM_STRING.close
set MM_STRING=nothing
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNumbers
@PID int, @SK int, @IDD int
AS

INSERT INTO tmpDODSongs (ProjectID, SortKey, OldIDD)
VALUES (@PID, @SK, @IDD)
GO

====== TEST.ASP output ======
This...
<%=Request("PID")%><br>
<%=Request("SK")%><br>
<%=Request("IDD")%><br><br>
Produces this...
24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24, 24
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17
121, 122, 123, 124, 125, 126, 127, 130, 131, 132, 133, 134, 135, 136, 137,
138, 139



这篇关于插入多条记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆