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 12  2969 
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... 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> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl... 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
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... 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
Not sure what you mean. I edited this line and it did nothing
if(Request("PID") <> "") then rsTracks__PID = Request("PID")(i)
What needs editing in your approach?
thanks!
"Patrice" <no****@nowhere.com> wrote in message
news:ex*************@TK2MSFTNGP15.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... 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
I am doing my browse page in Clarion/ASP. I include custom links that
hyperlink to another page. My browse page contain fields like
Client_Code, ClientName, and ClientAddress. My question is: How can I
store the Client_Code value of selected row into the variable? I need
to store the value of the selected row because I will use it to display
information on the next page. Please give me some insights about this.
Thank you.
Jherson
--
jherson
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------
For now it looks like to me that you have multiple fields with the same
name. Request.Form("PID") will return the values for *ALL* PID fields.
Request.Form("PID")(i) allows to return the value for the ith field.
Try for example :
<html>
<body>
<form method="post">
<%
If Not IsEmpty(Request.Form("MyField")) Then'
Response.Write Request.Form("MyField") & "<br>"
Response.Write Request.Form("MyField")(1) & "<br>"
Response.Write Request.Form("MyField")(2) & "<br>"
End If
For i=1 to 2
Response.Write "<input type=text name=MyField>"
Next
%>
<input type=submit>
</form>
</body>
</form>
If you enter a and b Request.Form("MyField") shows a,b while
Request.Form("MyField")(1) shows a and Request.Form("MyField")(2) shows b...
Here you take all those values once and you pass them all as parameters. You
should take the appropriate values for fields and execute the command. For
the code above it would be:
For i=1 to 2
cmd.Parameters.Value=Request.form("MyField")(i)
cmd.Execute
Next
So that you execute the command twice with the values for the ith input
field named MyField...
--
Patrice
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:%2***************@TK2MSFTNGP15.phx.gbl... Not sure what you mean. I edited this line and it did nothing
if(Request("PID") <> "") then rsTracks__PID = Request("PID")(i)
What needs editing in your approach?
thanks!
"Patrice" <no****@nowhere.com> wrote in message
news:ex*************@TK2MSFTNGP15.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... 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
I really appreciate your efforts, but I'm still getting the same basic
results when I try to implement your code. Backing up to what I had last
night... I'm starting from scratch and taking each step, one at a time. In
the end, I want to insert multiple rows into a table. But first I'm sure I
have to groom the data properly before submitting to the table. Below is my
starting form with no data, the form with data, landing page code, results
and expected results. Hopefully this enough to explan what I'm trying to do.
I don't know if my landing page code is at fault or the submitting form with
data. How does a form submit? Is it always one big stream of data? Can a
form be forced to loop through the rows? Code samples would be appreciated!
thanks!
= = = = = = = = STATIC FORM NO DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<%
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>
= = = = = = = = FORM WITH DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<tr>
<td class="resultsright">
<input name="SK" type="text" value="1" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="121">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="2" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="122">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="3" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="123">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="4" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="124">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="5" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="125">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="6" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="126">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="7" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="127">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="8" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="130">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="9" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="131">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="10" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="132">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="11" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="133">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="12" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="134">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="13" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="135">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="14" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="136">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="15" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="137">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="16" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="138">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="17" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="139">
</td>
</tr>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change">
</form>
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request("PID")%> <%=Request("SK")%> < %=Request("IDD")%><br>
<% Next %>
= = = = = = = = ACTUAL RESULTS = = = = = = = =
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
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
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
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
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
= = = = = = = = EXPECTED RESULTS = = = = = = = =
(In the end I will be inserting these records into a database. For the time
being, I'd at least like to get the data groomed correctly)
24 1 121
24 2 122
24 3 123
24 4 124
24 5 125
24 6 126
24 7 127
24 8 130
24 9 131
24 10 132
24 11 133
24 12 134
24 13 135
24 14 136
24 15 137
24 16 138
24 17 139
I changed just Request to Request.Form and added (i) after to extract the
proper value.
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request.
Form("IDD")(i)%><br>
<% Next %>
You should see now 5 lines with the values for the 5 first records...
--
Patrice
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:%2****************@TK2MSFTNGP12.phx.gbl... I really appreciate your efforts, but I'm still getting the same basic
results when I try to implement your code. Backing up to what I had last
night... I'm starting from scratch and taking each step, one at a time. In
the end, I want to insert multiple rows into a table. But first I'm sure I
have to groom the data properly before submitting to the table. Below is
my starting form with no data, the form with data, landing page code, results
and expected results. Hopefully this enough to explan what I'm trying to
do.
I don't know if my landing page code is at fault or the submitting form
with data. How does a form submit? Is it always one big stream of data? Can a
form be forced to loop through the rows? Code samples would be
appreciated!
thanks!
= = = = = = = = STATIC FORM NO DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<%
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>
= = = = = = = = FORM WITH DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<tr>
<td class="resultsright">
<input name="SK" type="text" value="1" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="121">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="2" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="122">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="3" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="123">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="4" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="124">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="5" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="125">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="6" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="126">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="7" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="127">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="8" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="130">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="9" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="131">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="10" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="132">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="11" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="133">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="12" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="134">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="13" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="135">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="14" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="136">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="15" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="137">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="16" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="138">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="17" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="139">
</td>
</tr>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change">
</form>
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request("PID")%> <%=Request("SK")%> < %=Request("IDD")%><br>
<% Next %>
= = = = = = = = ACTUAL RESULTS = = = = = = = =
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
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
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
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
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
= = = = = = = = EXPECTED RESULTS = = = = = = = =
(In the end I will be inserting these records into a database. For the
time being, I'd at least like to get the data groomed correctly)
24 1 121
24 2 122
24 3 123
24 4 124
24 5 125
24 6 126
24 7 127
24 8 130
24 9 131
24 10 132
24 11 133
24 12 134
24 13 135
24 14 136
24 15 137
24 16 138
24 17 139
But this is outside of your loop and in your loop you' ll use always the
same value. It should be inside your loop so that you can use the
approprivate value for each iteration.
Anyway doesn't really matter. Your other post seems to show you are on the
trigt track...
--
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:%2***************@TK2MSFTNGP15.phx.gbl... Not sure what you mean. I edited this line and it did nothing
if(Request("PID") <> "") then rsTracks__PID = Request("PID")(i)
What needs editing in your approach?
thanks!
"Patrice" <no****@nowhere.com> wrote in message
news:ex*************@TK2MSFTNGP15.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... 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
I'm really getting closer now! By chance, there's 17 records. In reality,
there could be any number of records.
<% For i = 1 to 5 %> <-- as you mentioned this gave me the first 5 records
<% For i = 1 to 100 %> <-- this gave me an out of range error
<% For i = 1 to IsEmpty(Request.Form("PID")) %> <-- this gave me no results
What do I need to get this to result in whatever records are being
submitted?
<% For i = 1 to IsEmpty(Request.Form("PID")) %>
<%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request.Form("IDD")(i)%><br>
<% Next %>
Thanks!
"Patrice" <no****@nowhere.com> wrote in message
news:ul**************@TK2MSFTNGP09.phx.gbl... I changed just Request to Request.Form and added (i) after to extract the
proper value.
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request.
Form("IDD")(i)%><br>
<% Next %>
You should see now 5 lines with the values for the 5 first records...
--
Patrice
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:%2****************@TK2MSFTNGP12.phx.gbl... I really appreciate your efforts, but I'm still getting the same basic
results when I try to implement your code. Backing up to what I had last
night... I'm starting from scratch and taking each step, one at a time.
In
the end, I want to insert multiple rows into a table. But first I'm sure
I
have to groom the data properly before submitting to the table. Below is
my starting form with no data, the form with data, landing page code,
results
and expected results. Hopefully this enough to explan what I'm trying to
do.
I don't know if my landing page code is at fault or the submitting form
with data. How does a form submit? Is it always one big stream of data? Can a
form be forced to loop through the rows? Code samples would be
appreciated!
thanks!
= = = = = = = = STATIC FORM NO DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<%
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>
= = = = = = = = FORM WITH DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<tr>
<td class="resultsright">
<input name="SK" type="text" value="1" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="121">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="2" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="122">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="3" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="123">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="4" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="124">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="5" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="125">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="6" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="126">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="7" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="127">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="8" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="130">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="9" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="131">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="10" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="132">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="11" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="133">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="12" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="134">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="13" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="135">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="14" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="136">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="15" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="137">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="16" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="138">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="17" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="139">
</td>
</tr>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change">
</form>
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request("PID")%> <%=Request("SK")%> < %=Request("IDD")%><br>
<% Next %>
= = = = = = = = ACTUAL RESULTS = = = = = = = =
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
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
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
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
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
= = = = = = = = EXPECTED RESULTS = = = = = = = =
(In the end I will be inserting these records into a database. For the
time being, I'd at least like to get the data groomed correctly)
24 1 121
24 2 122
24 3 123
24 4 124
24 5 125
24 6 126
24 7 127
24 8 130
24 9 131
24 10 132
24 11 133
24 12 134
24 13 135
24 14 136
24 15 137
24 16 138
24 17 139
For example Request.Form("MyField").Count.
The key point is that if you have several names, Request.Form("MyField") is
actually a connection...
--
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:eH****************@TK2MSFTNGP10.phx.gbl... I'm really getting closer now! By chance, there's 17 records. In reality,
there could be any number of records.
<% For i = 1 to 5 %> <-- as you mentioned this gave me the first 5 records
<% For i = 1 to 100 %> <-- this gave me an out of range error
<% For i = 1 to IsEmpty(Request.Form("PID")) %> <-- this gave me no
results
What do I need to get this to result in whatever records are being
submitted?
<% For i = 1 to IsEmpty(Request.Form("PID")) %>
<%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request.
Form("IDD")(i)%><br> <% Next %>
Thanks!
"Patrice" <no****@nowhere.com> wrote in message
news:ul**************@TK2MSFTNGP09.phx.gbl...I changed just Request to Request.Form and added (i) after to extract the
proper value.
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request. Form("IDD")(i)%><br>
<% Next %>
You should see now 5 lines with the values for the 5 first records...
--
Patrice
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:%2****************@TK2MSFTNGP12.phx.gbl... I really appreciate your efforts, but I'm still getting the same basic
results when I try to implement your code. Backing up to what I had
last night... I'm starting from scratch and taking each step, one at a time.
In
the end, I want to insert multiple rows into a table. But first I'm
sure I
have to groom the data properly before submitting to the table. Below
is my starting form with no data, the form with data, landing page code,
results
and expected results. Hopefully this enough to explan what I'm trying
to do.
I don't know if my landing page code is at fault or the submitting form
with data. How does a form submit? Is it always one big stream of data? Can
a form be forced to loop through the rows? Code samples would be
appreciated!
thanks!
= = = = = = = = STATIC FORM NO DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<%
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>
= = = = = = = = FORM WITH DATA = = = = = = = =
<form action="test.asp" method="post" name="frmSortKey">
<table class="tbldisplay">
<tr>
<td class="resultsright">
<input name="SK" type="text" value="1" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="121">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="2" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="122">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="3" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="123">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="4" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="124">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="5" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="125">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="6" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="126">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="7" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="127">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="8" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="130">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="9" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="131">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="10" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="132">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="11" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="133">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="12" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="134">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="13" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="135">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="14" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="136">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="15" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="137">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="16" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="138">
</td>
</tr>
<tr>
<td class="resultsright">
<input name="SK" type="text" value="17" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden" value="24">
<input name="IDD" type="hidden" value="139">
</td>
</tr>
</table>
<input name="SubmitNow" type="hidden" value="1">
<input name="Submit" type="submit" value="Change">
</form>
= = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
<% For i = 1 to 5 %>
<%=Request("PID")%> <%=Request("SK")%> < %=Request("IDD")%><br> <% Next %>
= = = = = = = = ACTUAL RESULTS = = = = = = = =
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
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
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
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
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
= = = = = = = = EXPECTED RESULTS = = = = = = = =
(In the end I will be inserting these records into a database. For the
time being, I'd at least like to get the data groomed correctly)
24 1 121
24 2 122
24 3 123
24 4 124
24 5 125
24 6 126
24 7 127
24 8 130
24 9 131
24 10 132
24 11 133
24 12 134
24 13 135
24 14 136
24 15 137
24 16 138
24 17 139
Now we're cookin' with real butter!
Thanks! :-))
"Patrice" <no****@nowhere.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... For example Request.Form("MyField").Count.
The key point is that if you have several names, Request.Form("MyField")
is
actually a connection...
--
"shank" <sh***@tampabay.rr.com> a écrit dans le message de
news:eH****************@TK2MSFTNGP10.phx.gbl... I'm really getting closer now! By chance, there's 17 records. In reality,
there could be any number of records.
<% For i = 1 to 5 %> <-- as you mentioned this gave me the first 5
records
<% For i = 1 to 100 %> <-- this gave me an out of range error
<% For i = 1 to IsEmpty(Request.Form("PID")) %> <-- this gave me no
results
What do I need to get this to result in whatever records are being
submitted?
<% For i = 1 to IsEmpty(Request.Form("PID")) %>
<%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request.
Form("IDD")(i)%><br> <% Next %>
Thanks!
"Patrice" <no****@nowhere.com> wrote in message
news:ul**************@TK2MSFTNGP09.phx.gbl... >I changed just Request to Request.Form and added (i) after to extract
>the
> proper value.
>
> = = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
> <% For i = 1 to 5 %>
> <%=Request.Form("PID")(i)%> <%=Request.Form(" SK")(i)%> <%=Request. > Form("IDD")(i)%><br>
> <% Next %>
>
> You should see now 5 lines with the values for the 5 first records...
> --
> Patrice
>
> "shank" <sh***@tampabay.rr.com> a écrit dans le message de
> news:%2****************@TK2MSFTNGP12.phx.gbl...
>> I really appreciate your efforts, but I'm still getting the same basic
>> results when I try to implement your code. Backing up to what I had last >> night... I'm starting from scratch and taking each step, one at a
>> time.
>> In
>> the end, I want to insert multiple rows into a table. But first I'm sure >> I
>> have to groom the data properly before submitting to the table. Below is > my
>> starting form with no data, the form with data, landing page code,
>> results
>> and expected results. Hopefully this enough to explan what I'm trying to > do.
>>
>> I don't know if my landing page code is at fault or the submitting
>> form
> with
>> data. How does a form submit? Is it always one big stream of data? Can a >> form be forced to loop through the rows? Code samples would be
> appreciated!
>>
>> thanks!
>>
>> = = = = = = = = STATIC FORM NO DATA = = = = = = = =
>> <form action="test.asp" method="post" name="frmSortKey">
>> <table class="tbldisplay">
>> <%
>> 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>
>>
>> = = = = = = = = FORM WITH DATA = = = = = = = =
>> <form action="test.asp" method="post" name="frmSortKey">
>> <table class="tbldisplay">
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="1" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="121">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="2" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="122">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="3" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="123">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="4" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="124">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="5" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="125">
>> </td>
>> </tr>
>>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="6" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="126">
>> </td>
>> </tr>
>>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="7" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="127">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="8" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="130">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="9" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="131">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="10" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="132">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="11" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="133">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="12" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="134">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="13" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="135">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="14" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="136">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="15" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="137">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="16" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="138">
>> </td>
>> </tr>
>> <tr>
>> <td class="resultsright">
>> <input name="SK" type="text" value="17" size="3" maxlength="2"
>> style="text-align:right">
>> <input name="PID" type="hidden" value="24">
>> <input name="IDD" type="hidden" value="139">
>> </td>
>> </tr>
>> </table>
>> <input name="SubmitNow" type="hidden" value="1">
>> <input name="Submit" type="submit" value="Change">
>> </form>
>>
>> = = = = = = = = LANDING PAGE CODE TEST.ASP = = = = = = = =
>> <% For i = 1 to 5 %>
>> <%=Request("PID")%> <%=Request("SK")%> < %=Request("IDD")%><br> >> <% Next %>
>>
>> = = = = = = = = ACTUAL RESULTS = = = = = = = =
>> 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
>> 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
>> 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
>> 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
>> 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
>>
>> = = = = = = = = EXPECTED RESULTS = = = = = = = =
>> (In the end I will be inserting these records into a database. For the
> time
>> being, I'd at least like to get the data groomed correctly)
>> 24 1 121
>> 24 2 122
>> 24 3 123
>> 24 4 124
>> 24 5 125
>> 24 6 126
>> 24 7 127
>> 24 8 130
>> 24 9 131
>> 24 10 132
>> 24 11 133
>> 24 12 134
>> 24 13 135
>> 24 14 136
>> 24 15 137
>> 24 16 138
>> 24 17 139
>>
>>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: shank |
last post by:
I have a recordset that contains multiple records of product a user is
purchasing. For clarity, I converted the recordset fields to variables. I
need to take that entire recordset and insert it...
|
by: Sans Spam |
last post by:
Greetings! I have a table that contains all of the function
permissions within a given application. These functions are different
sections of a site and each has its own permissions (READ, WRITE,...
|
by: Joe |
last post by:
Hey,
I'm going to give some background on my situation in case anyone can
point out a way around my problem altogether... for the problem
itself, please skip to the bottom of the post. thanks....
|
by: george |
last post by:
This is like the bug from hell. It is kind of hard to explain, so
please bear with me.
Background Info: SQL Server 7.0, on an NT box, Active Server pages
with Javascript, using ADO objects.
...
|
by: jtocci |
last post by:
I'm having a big problem with CREATE RULE...ON INSERT...INSERT
INTO...SELECT...FROM...WHERE when I want to INSERT several (20~50)
records based on a single INSERT to a view. Either I get a 'too...
|
by: Mike |
last post by:
I know this sounds strange but I am at a loss. I am calling a simple
funtion that opens a connection to a SQL Server 2000 database and executes
an Insert Statement.
private void...
|
by: Mike Hnatt |
last post by:
My goal is to get data from an XML file into a couple of tables in an Access
database. The XML file is a little complex so I need control over what I do
(I can't just read it into a dataset).
...
|
by: Bob Alston |
last post by:
I have a routine to copy data to new versions of my app via insert into
sql statements. Unfortunately, due to evolution of my app, sometimes
the new version has more restrictive editing than an...
|
by: clayalphonso |
last post by:
Here is the code:
<%
dim testArray, testArray2
dim Conn, rs
dim sSQL, sConnString
'response.write request.form("sel1")
'testArray = split(request.form("sel1"),",")
'for each gidstuff In...
|
by: chumlyumly |
last post by:
Hello scripters -
OS: Mac OSX
Language: PHP w/ MySQL database
I've created an insert page where a user inputs his info, which then goes to four different tables in a MySQL database. The...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
