473,699 Members | 2,801 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

insert multiple records

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.as p" method="post" name="frmSortKe y">
<table>
<tr>
<td class="colhead" >New#</td>
</tr>
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3, 4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT
MM_STRING.close
set MM_STRING=nothi ng
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNu mbers
@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
Nov 22 '05 #1
12 3007
Couldent spot anything

By try using

**
do untill rsSongs.EOF

rsSongs.MoveNex t
loop
**

Why?

I know that works with a recordset (But so should while wend)
"shank" <sh***@tampabay .rr.com> wrote in message
news:eC******** ******@TK2MSFTN GP09.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.as p" method="post" name="frmSortKe y">
<table>
<tr>
<td class="colhead" >New#</td>
</tr>
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3, 4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT
MM_STRING.close
set MM_STRING=nothi ng
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNu mbers
@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

Nov 22 '05 #2
"shank" <sh***@tampabay .rr.com> wrote in message
news:eC******** ******@TK2MSFTN GP09.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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
....to here.
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3, 4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT

Nov 22 '05 #3
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("M yField")(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******** ******@TK2MSFTN GP09.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.as p" method="post" name="frmSortKe y">
<table>
<tr>
<td class="colhead" >New#</td>
</tr>
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3, 4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT
MM_STRING.close
set MM_STRING=nothi ng
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNu mbers
@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

Nov 22 '05 #4
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******** *****@TK2MSFTNG P15.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("M yField")(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******** ******@TK2MSFTN GP09.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.as p" method="post" name="frmSortKe y">
<table>
<tr>
<td class="colhead" >New#</td>
</tr>
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3"
maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3,
4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT
MM_STRING.close
set MM_STRING=nothi ng
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNu mbers
@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


Nov 22 '05 #5

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
------------------------------------------------------------------------

Nov 22 '05 #6
For now it looks like to me that you have multiple fields with the same
name. Request.Form("P ID") will return the values for *ALL* PID fields.
Request.Form("P ID")(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("M yField") & "<br>"
Response.Write Request.Form("M yField")(1) & "<br>"
Response.Write Request.Form("M yField")(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("M yField") shows a,b while
Request.Form("M yField")(1) shows a and Request.Form("M yField")(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.f orm("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******** *******@TK2MSFT NGP15.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******** *****@TK2MSFTNG P15.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("M yField")(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******** ******@TK2MSFTN GP09.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.as p" method="post" name="frmSortKe y">
<table>
<tr>
<td class="colhead" >New#</td>
</tr>
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3"
maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3,
4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT
MM_STRING.close
set MM_STRING=nothi ng
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNu mbers
@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



Nov 22 '05 #7
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.as p" method="post" name="frmSortKe y">
<table class="tbldispl ay">
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.as p" method="post" name="frmSortKe y">
<table class="tbldispl ay">
<tr>
<td class="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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 ")%>&nbsp;<%=Re quest("SK")%>&n bsp;<%=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
Nov 22 '05 #8
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)%>&nb sp;<%=Request.F orm("SK")(i)%>& nbsp;<%=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******** ********@TK2MSF TNGP12.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.as p" method="post" name="frmSortKe y">
<table class="tbldispl ay">
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3" maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.as p" method="post" name="frmSortKe y">
<table class="tbldispl ay">
<tr>
<td class="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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="resultsr ight">
<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 ")%>&nbsp;<%=Re quest("SK")%>&n bsp;<%=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

Nov 22 '05 #9
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******** *******@TK2MSFT NGP15.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******** *****@TK2MSFTNG P15.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("M yField")(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******** ******@TK2MSFTN GP09.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.as p" method="post" name="frmSortKe y">
<table>
<tr>
<td class="colhead" >New#</td>
</tr>
<%
While ((Repeat1__numR ows <> 0) AND (NOT rsSongs.EOF))
%>
<tr>
<td class="resultsr ight">
<input name="SK" type="text"
value="<%=(rsSo ngs.Fields.Item ("SortKey").Val ue)%>" size="3"
maxlength="2"
style="text-align:right">
<input name="PID" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ProjectID").V alue)%>">
<input name="IDD" type="hidden"
value="<%=(rsSo ngs.Fields.Item ("ID").Value)%> ">
</td>
</tr>
<%
Repeat1__index= Repeat1__index+ 1
Repeat1__numRow s=Repeat1__numR ows-1
rsSongs.MoveNex t()
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.CreateOb ject("ADODB.Com mand")
rsTracks.Active Connection = MM_STRING
rsTracks.Comman dText = "admin.stp_DOD_ TrackNumbers"
rsTracks.Comman dType = 4
rsTracks.Comman dTimeout = 0
rsTracks.Prepar ed = true
rsTracks.Parame ters.Append rsTracks.Create Parameter("@RET URN_VALUE", 3,
4)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@PID ", 3,
1,9,rsTracks__P ID)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@SK" , 3,
1,9,rsTracks__S K)
rsTracks.Parame ters.Append rsTracks.Create Parameter("@IDD ", 3,
1,9,rsTracks__I DD)
rsTracks.Execut e()

NEXT
MM_STRING.close
set MM_STRING=nothi ng
%>

====== STORED PROCEDURE ======
CREATE PROCEDURE stp_DOD_TrackNu mbers
@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



Nov 22 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
3227
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 into another table on a remote server. The below code only inserts 1 record. How do I change the code to get all records inserted? thanks! <% Dim DataConn2 Set DataConn2 = Server.CreateObject("ADODB.Connection")
8
5519
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, UPDATE, DELETE) which are controlled by a web frontend and the table records are manipulated to control the permissions. Example: The Press Release section record would look like this: Username: John Doe Function Name: Press Release
2
2658
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. I've been having some problems with database performance... Several threads are constantly attempting INSERTs of new records into a large table - that is hundreds of thousands of records -large by my account :-) The table has a VARCHAR field...
2
13394
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. I'm inserting simple records into a table. But one insert command is placing 2 or 3 records into the table. The 'extra' records, have the same data as the previous insert incident, (except for the timestamp).
0
3140
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 much data for field' or the query just runs on and on til I have to restart the postmaster. I have found rules to compare mine to but people limit the resulting insert to one record (the WHERE generally limits the result of the SELECT to one...
10
3393
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 AddMinimunWageStipen(string payrollid,double amount) { System.Data.SqlClient.SqlConnection cn = null; System.Data.SqlClient.SqlCommand cm = null;
4
2198
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). The way I have it now is ennumerating through my XML file and for each record, running an INSERT INTO SQL statement to put the values in the database. Is this going to be okay with 50 or so records (hitting the database with 50 or so INSERT...
3
6334
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 older version that I am updating. Thus I get this message. It tells me only how many records have errors, not which errors or which records. Anyone have a nice solution to identifying the specific records involved? Maybe even the specific...
1
4824
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 testArray 'Response.Write gidstuff & "<br />"
0
4451
chumlyumly
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 tables are all linked with the field 'member_id', which is an auto-increment field in the parent table ('members'). I've been able to input multiple records into the other three tables 'specialty_groups', 'committee_interest' and 'committee_member'...
0
8623
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9187
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9053
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8936
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8894
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6540
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4390
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3071
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.