473,714 Members | 2,540 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Populating multiple textboxes with multiple records for update page

I have a db table like the following,

UID, int auto-increment
RegNo
Person
Relation
YearsKnown

Now here is some sample data from this table,

1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

I have a table with 25 rows and 3 columns, with a textbox for name,
relationship and years known. I would like to populate the 1st name textbox
with the 1st name from the db, and the 1st relationship txtbox with the
relationship from the db, etc. for each RegNo. This will be used for an
update page.

How can this be done?

TIA,
Drew
Jul 21 '05 #1
7 4093
What part are you stuck on? How to structure your query? How to make a
connection to the database? How to write values from a recordset into HTML
in an ASP page? Something else? What code do you have so far?

Ray at work

"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:ut******** ******@TK2MSFTN GP14.phx.gbl...
I have a db table like the following,

UID, int auto-increment
RegNo
Person
Relation
YearsKnown

Now here is some sample data from this table,

1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

I have a table with 25 rows and 3 columns, with a textbox for name,
relationship and years known. I would like to populate the 1st name
textbox with the 1st name from the db, and the 1st relationship txtbox
with the relationship from the db, etc. for each RegNo. This will be used
for an update page.

How can this be done?

TIA,
Drew

Jul 21 '05 #2
Well, I am currently just trying to think about how this is going to work.
I have the structure built, and I don't think the will be a problem, just
using querystring to pass the RegNo.

The only code that I have is for the page, and most of it is html. This is
the 2nd step of 20 steps, and the page inserts the data from the prior page,
and then if there is data, then it populates the textboxes with the data, if
there isn't any data it displays empty textboxes for inserting.

I haven't figured out how to insert mulitple items, btu that didn't sound
like the problem, I think that populating the textboxes iwll be more of a
problem than inserting the data.

Thanks,
Drew
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ek******** ******@tk2msftn gp13.phx.gbl...
What part are you stuck on? How to structure your query? How to make a
connection to the database? How to write values from a recordset into
HTML in an ASP page? Something else? What code do you have so far?

Ray at work

"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:ut******** ******@TK2MSFTN GP14.phx.gbl...
I have a db table like the following,

UID, int auto-increment
RegNo
Person
Relation
YearsKnown

Now here is some sample data from this table,

1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

I have a table with 25 rows and 3 columns, with a textbox for name,
relationship and years known. I would like to populate the 1st name
textbox with the 1st name from the db, and the 1st relationship txtbox
with the relationship from the db, etc. for each RegNo. This will be
used for an update page.

How can this be done?

TIA,
Drew


Jul 21 '05 #3
Can you show us what you have and what you're stuck on? Let's just take it
one step at a time. Select a step please. :]

Ray at work
"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:ON******** ******@TK2MSFTN GP12.phx.gbl...
Well, I am currently just trying to think about how this is going to work.
I have the structure built, and I don't think the will be a problem, just
using querystring to pass the RegNo.

The only code that I have is for the page, and most of it is html. This
is the 2nd step of 20 steps, and the page inserts the data from the prior
page, and then if there is data, then it populates the textboxes with the
data, if there isn't any data it displays empty textboxes for inserting.

I haven't figured out how to insert mulitple items, btu that didn't sound
like the problem, I think that populating the textboxes iwll be more of a
problem than inserting the data.

Jul 21 '05 #4
Here is my code for the page, cliELP_step02.a sp,

Now I need the results from the recordset, rsPeopleWhoCont ributed to be
broken down and populated in the textboxes below, named name, relationship,
yearsknown. So the data could look like this,

UID RegNo Name Relationship YearsKnown
1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

So if the user selected RegNo 01292 on cliELP_step01.a sp, and then clicked
Goto Step 2, then it would query the db using RegNo 01292 and that recordset
needs to be populated into the textboxes. So textbox name 1 would have John
Doe, and relationship txtbox 1 would have Father and textbox yearsknown 1
would have 39. So on and so on.

TIA,
Drew

Code below,

<%@LANGUAGE="VB SCRIPT" CODEPAGE="1252" %>
<!--#include file="../Connections/CliELP.asp" -->
<%
'Insert data from cliELP_step01.a sp
If Request.Form("a ctions") <> 1 Then

'SQL for inserting into SQL Server
sql="INSERT INTO ELPGeneral (RegNo,DesiredN ame)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("R egNo") & "',"
sql=sql & "'" & Request.Form("D esiredName") & "')"

'execute the insert to SQL Server
Set MM_editCmd = Server.CreateOb ject("ADODB.Com mand")
MM_editCmd.Acti veConnection = MM_CliELP_STRIN G
MM_editCmd.Comm andText = sql
MM_editCmd.Exec ute
MM_editCmd.Acti veConnection.Cl ose

Else

'Must already be in the DB, so query the DB by RegNo
Dim rsPeopleWhoCont ributed
Dim rsPeopleWhoCont ributed_numRows

Set rsPeopleWhoCont ributed = Server.CreateOb ject("ADODB.Rec ordset")
rsPeopleWhoCont ributed.ActiveC onnection = MM_CliELP_STRIN G
rsPeopleWhoCont ributed.Source = "SELECT RegNo, PeopleWhoContri buted FROM
dbo.ELPPeopleWh oContributed WHERE RegNo = " & Request.Form("R egNo")
rsPeopleWhoCont ributed.CursorT ype = 0
rsPeopleWhoCont ributed.CursorL ocation = 2
rsPeopleWhoCont ributed.LockTyp e = 1
rsPeopleWhoCont ributed.Open()

rsPeopleWhoCont ributed_numRows = 0

End If%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>People Who Contributed - Essential Lifestyle Plan - SWVTC
Intranet</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../css/SWVTCintranet.c ss" rel="stylesheet " type="text/css">
<!--[if gte IE 6.000]>
<script type="text/javascript" src="pngfix.js" ></script>
<![endif]-->
<style type="text/css">
<!--
..style1 {font-weight: bold}
..style2 {
font-size: 18px;
font-weight: bold;
}
..style3 {font-size: 14px}
-->
</style>
</head>
<body>
<!--#include file="../include/header.asp" -->
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr bgcolor="#FFFFF F">
<td colspan="3" valign="top"><i mg src="../img/spacer.gif" width="1"
height="10"></td>
</tr>
<tr bgcolor="#FFFFF F">
<td width="19%" valign="top"><!--#include
file="../include/nav_intranet.as p" --></td>
<td width="1%"><img src="../img/spacer.gif" width="10" height="1"></td>
<td width="80%" valign="top"><d iv align="center">
</div> <div align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="0"
bgcolor="CCCCCC ">
<tr>
<td width="4%"><img src="../img/tl_corner_CCCCC C.jpg" width="26"
height="26"></td>
<td width="92%">&nb sp;</td>
<td width="4%"><img src="../img/tr_corner_CCCCC C.jpg" width="25"
height="26" align="right"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><table width="100%" border="0" cellspacing="0"
cellpadding="0" >
<tr>
<td><span class="style3"> Back to Main Page </span></td>
</tr>
<tr>
<td><img src="../img/spacer.gif" width="1" height="10"></td>
</tr>
<tr>
<td><div align="center" class="style2"> Client Essential
Lifestyle Plan</div></td>
</tr>
<tr>
<td><img src="../img/spacer.gif" width="1" height="10"></td>
</tr>
<tr>
<td><div align="center"> <strong>Step 2 - People Who
Contributed </strong></div></td>
</tr>
<tr>
<td><img src="../img/spacer.gif" width="1" height="10"></td>
</tr>
</table>
<form name="form1" method="post" action="cliELP_ step03.asp">
<table width="100%" border="0" cellspacing="0"
cellpadding="0" >
<tr>
<td><p>Please enter the People who Contributed to
<strong><%=Requ est.Form("Desir edName")%>'s</strong> Plan.</p>
</td>
</tr>
<tr>
<td width="28%">&nb sp;</td>
</tr>
<tr>
<td valign="top"><t able width="100%" border="0"
cellspacing="5" cellpadding="0" >
<tr>
<td width="6%">&nbs p;</td>
<td width="44%"><di v
align="center"> <strong>Name</strong></div></td>
<td width="27%"><di v
align="center"> <strong>Relatio nship</strong></div></td>
<td width="23%"><di v align="center"> <strong>Yrs Known
</strong></div></td>
</tr>
<tr>
<td><strong>1 </strong></td>
<td>
<div align="center">
<input name="name" type="text" id="name"
size="25">
</div></td>
<td>
<div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td>
<div align="center">
<input name="yearsknow n" type="text"
id="yearsknown " size="8">
</div></td>
</tr>
<tr>
<td><strong>2 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>3 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>4 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>5 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>6 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>7 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>8 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>9 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 0</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 1</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 2</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 3</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 4</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 5</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 6</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 7</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 8</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>1 9</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>2 0</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>2 1</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>2 2</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>2 3</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>2 4</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
<tr>
<td><strong>2 5</strong></td>
<td><div align="center">
<input name="name" type="text" id="name" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
size="8">
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><img src="../img/spacer.gif" width="150" height="1">
<input type="submit" name="Submit" value="Save Changes
and Go To Step 3 >"></td>
</tr>
<tr>
<td><input name="DesiredNa me" type="hidden"
id="DesiredName " value="<%=Reque st.Form("Desire dName")%>">
<input name="RegNo" type="hidden" id="RegNo"
value="<%=Reque st.Form("RegNo" )%>">
<input name="actions" type="hidden" id="actions"
value="<%=Reque st.Form("action s")%>"></td>
</tr>
</table>
</form></td>
<td>&nbsp;</td>
</tr>
<tr>
<td><img src="../img/bl_corner_CCCCC C.jpg" width="26"
height="25"></td>
<td>&nbsp;</td>
<td><img src="../img/br_corner_CCCCC C.jpg" width="25"
height="25" align="right"></td>
</tr>
</table>
</div>
<div align="center"> </div> <div align="center"> </div> <div
align="center"> </div> <div align="center"> </div></td>
</tr>
</table>
<!--#include file="../include/footer.asp" -->
</body>
</html>
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:OO******** *****@TK2MSFTNG P09.phx.gbl...
Can you show us what you have and what you're stuck on? Let's just take
it one step at a time. Select a step please. :]

Ray at work
"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:ON******** ******@TK2MSFTN GP12.phx.gbl...
Well, I am currently just trying to think about how this is going to
work. I have the structure built, and I don't think the will be a
problem, just using querystring to pass the RegNo.

The only code that I have is for the page, and most of it is html. This
is the 2nd step of 20 steps, and the page inserts the data from the prior
page, and then if there is data, then it populates the textboxes with the
data, if there isn't any data it displays empty textboxes for inserting.

I haven't figured out how to insert mulitple items, btu that didn't sound
like the problem, I think that populating the textboxes iwll be more of a
problem than inserting the data.


Jul 21 '05 #5
Okay, what you're trying to do is not an uncommon thing. That does not mean
that it is a trivial task, however. But, you're using Dreamweaver. If you
continue to use Dreamweaver for ASP editing, then it really becomes a
question of how to use Dreamweaver to create this functionality. I'd
imagine that it has the ability to do this, although you won't really find
too many Dreamweaver users around here.

If you choose to do ASP development by hand-coding (at least the ASP part),
then it's a matter of determining what needs to appear on your page, how you
get it to appear on your page, what data needs to be sent to the server, how
to ensure that data is sent to the server, and then what to do with that
data when it is sent to the server.

Do you want the ability to edit all the records at the same time? That's a
little more complex than one at a time, so for the time being, I'll assume
that you only want to do one at a time. If you want to do all at a time,
that's fine; just post back.

For the one at a time method, I'll break it out into multiple pages for
simplicity's sake. The process here is:

showall.asp:
Create a page that lists records and provides a link to an edit page, which
will display the records with the editable fields in text boxes. It will
pass the UID in the querystring to edit.asp.

edit.asp:
Pull the id from the querystring, and get the corresponding record in the
database from it. Then display current values in a form with the values
being displayed in textboxes. The ID will be passed to the next page in a
hidden input.

save.asp:
Get the data posted from the form and execute an UPDATE [non]query with that
information using a WHERE clause containing the UID that was passed in the
hidden form field on edit.asp.


showall.asp:
<%
sSQL = "SELECT UID,RegNo,[Name],Relationship,Y earsKnown FROM ELPGeneral"
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
Set oRS = yourADOObject.E xecute(sSQL)
If oRS.EOF Then
Response.Write "No items.
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
End If
%>

<table>
<%
''.GetRows is for another day!
Do While Not oRS.EOF
%>
<tr>
<td><a
href="edit.asp? id=<%=oRS.Field s.Item(0).Value )%>"><%=oRS.Fie lds.Item(1).Val ue%></a></td>
<td><%=oRS.Fiel ds.Item(2).Valu e%></td>
<td><%=oRS.Fiel ds.Item(3).Valu e%></td>
<td><%=oRS.Fiel ds.Item(4).Valu e%></td>
</tr>
<%
oRS.MoveNext
Loop
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
%>
</table>
edit.asp:
<%
Dim iID
iID = Request.Queryst ring("id") ''validate this
sSQL = "SELECT RegNo,[Name],Relationship,Y earsKnown FROM ELPGeneral WHERE
UID=" & iID
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
Set oRS = yourADOObject.E xecute(sSQL)
If oRS.EOF Then
Response.Write "Not found."
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
End If
%>

<form method="post" action="save.as p">
Reg No: <input name="txtRegNo" type="text"
value="<%=oRS.F ields.Item(0).V alue%>"><br>
Name: <input name="txtName" type="text"
value="<%=oRS.F ields.Item(1).V alue%>"><br>
Relationship: <input name="txtRelati onship" type="text"
value="<%=oRS.F ields.Item(2).V alue%>"><br>
Years Known: <input name="txtYearsK nown" type="text"
value="<%=oRS.F ields.Item(3).V alue%>"><br>
<input name="hidID" type="hidden" value="<%=iID%> ">
<input type="submit">
</form>

save.asp:
<%
Dim iID, sRegNo, sName, sRelationship, iYearsKnown
Dim sSQL

iID = Request.Form("h idID")
sRegNo = Request.Form("t xtRegNo")
sName = Request.Form("t xtName")
sRelationship = Request.Form("t xtRelationship" )
iYearsKnown = Request.Form("t xtYearsKnown")

sSQL = "UPDATE ELPGeneral SET RegNo=" & TextIn(sRegNo) & ",[Name]=" &
TextIn(sName) & ",Relationship= " & TextIn(sRelatio nship) & ",YearsKnow n=" &
iYearsKnown & " WHERE UID=" & iID
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
yourADOObject.E xecute sSQL,,129
yourADOObject.C lose
Set yourADOObject = Nothing

Response.Write "Saved."

Function TextIn(s)
TextIn = "'" & Replace(s, "'", "''")
End Function
%>

Ray at home
"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:uu******** ******@tk2msftn gp13.phx.gbl...
Here is my code for the page, cliELP_step02.a sp,

Now I need the results from the recordset, rsPeopleWhoCont ributed to be
broken down and populated in the textboxes below, named name,
relationship, yearsknown. So the data could look like this,

UID RegNo Name Relationship YearsKnown
1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

So if the user selected RegNo 01292 on cliELP_step01.a sp, and then clicked
Goto Step 2, then it would query the db using RegNo 01292 and that
recordset needs to be populated into the textboxes. So textbox name 1
would have John Doe, and relationship txtbox 1 would have Father and
textbox yearsknown 1 would have 39. So on and so on.

TIA,
Drew

Code below,

<%@LANGUAGE="VB SCRIPT" CODEPAGE="1252" %>
<!--#include file="../Connections/CliELP.asp" -->
<%
'Insert data from cliELP_step01.a sp
If Request.Form("a ctions") <> 1 Then

'SQL for inserting into SQL Server
sql="INSERT INTO ELPGeneral (RegNo,DesiredN ame)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("R egNo") & "',"
sql=sql & "'" & Request.Form("D esiredName") & "')"

'execute the insert to SQL Server
Set MM_editCmd = Server.CreateOb ject("ADODB.Com mand")
MM_editCmd.Acti veConnection = MM_CliELP_STRIN G
MM_editCmd.Comm andText = sql
MM_editCmd.Exec ute
MM_editCmd.Acti veConnection.Cl ose

Jul 21 '05 #6
I have gotten the saving part down pat, but my problem lies in populating
the multiple fields with records from the recordset. If my data looks like
this,

UID RegNo Name Relationship YearsKnown
1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

Then RegNo 01292 has 4 records, if RegNo 01292 was selected on the first
page I would like for the page to look like this, (this is only a snippet of
the code)

<table width="100%" border="0" cellspacing="5" cellpadding="0" >
<tr>
<td width="6%">&nbs p;</td>
<td width="44%"><di v
align="center"> <strong>Name</strong></div></td>
<td width="27%"><di v
align="center"> <strong>Relatio nship</strong></div></td>
<td width="23%"><di v align="center"> <strong>Yrs Known
</strong></div></td>
</tr>
<tr>
<td><strong>1 </strong></td>
<td>
<div align="center">
<input name="name" type="text" id="name"
value="John Doe" size="25">
</div></td>
<td>
<div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Father" size="15">
</div></td>
<td>
<div align="center">
<input name="yearsknow n" type="text"
id="yearsknown " value="39" size="8">
</div></td>
</tr>
<tr>
<td><strong>2 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" value="Jane
Doe" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Mother" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
value="39" size="8">
</div></td>
</tr>
<tr>
<td><strong>3 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name"
value="Janet Doe" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Sister" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
value="34" size="8">
</div></td>
</tr>
<tr>
<td><strong>4 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name" value="Jane
Thomas" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Aide" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text" id="yearsknown "
value="19" size="8">
</div></td>
</tr>

So in other words, there are 25 rows of textboxes, with 3 columns of
textboxes. If there are 25 records pertaining to the RegNo, then all the
boxes will be filled with data.

My question is How do you break down the RS so the textboxes can be
populated?

Thanks,
Drew


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:OM******** ******@TK2MSFTN GP09.phx.gbl...
Okay, what you're trying to do is not an uncommon thing. That does not
mean that it is a trivial task, however. But, you're using Dreamweaver.
If you continue to use Dreamweaver for ASP editing, then it really becomes
a question of how to use Dreamweaver to create this functionality. I'd
imagine that it has the ability to do this, although you won't really find
too many Dreamweaver users around here.

If you choose to do ASP development by hand-coding (at least the ASP
part), then it's a matter of determining what needs to appear on your
page, how you get it to appear on your page, what data needs to be sent to
the server, how to ensure that data is sent to the server, and then what
to do with that data when it is sent to the server.

Do you want the ability to edit all the records at the same time? That's
a little more complex than one at a time, so for the time being, I'll
assume that you only want to do one at a time. If you want to do all at a
time, that's fine; just post back.

For the one at a time method, I'll break it out into multiple pages for
simplicity's sake. The process here is:

showall.asp:
Create a page that lists records and provides a link to an edit page,
which will display the records with the editable fields in text boxes. It
will pass the UID in the querystring to edit.asp.

edit.asp:
Pull the id from the querystring, and get the corresponding record in the
database from it. Then display current values in a form with the values
being displayed in textboxes. The ID will be passed to the next page in a
hidden input.

save.asp:
Get the data posted from the form and execute an UPDATE [non]query with
that information using a WHERE clause containing the UID that was passed
in the hidden form field on edit.asp.


showall.asp:
<%
sSQL = "SELECT UID,RegNo,[Name],Relationship,Y earsKnown FROM ELPGeneral"
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
Set oRS = yourADOObject.E xecute(sSQL)
If oRS.EOF Then
Response.Write "No items.
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
End If
%>

<table>
<%
''.GetRows is for another day!
Do While Not oRS.EOF
%>
<tr>
<td><a
href="edit.asp? id=<%=oRS.Field s.Item(0).Value )%>"><%=oRS.Fie lds.Item(1).Val ue%></a></td>
<td><%=oRS.Fiel ds.Item(2).Valu e%></td>
<td><%=oRS.Fiel ds.Item(3).Valu e%></td>
<td><%=oRS.Fiel ds.Item(4).Valu e%></td>
</tr>
<%
oRS.MoveNext
Loop
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
%>
</table>
edit.asp:
<%
Dim iID
iID = Request.Queryst ring("id") ''validate this
sSQL = "SELECT RegNo,[Name],Relationship,Y earsKnown FROM ELPGeneral WHERE
UID=" & iID
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
Set oRS = yourADOObject.E xecute(sSQL)
If oRS.EOF Then
Response.Write "Not found."
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
End If
%>

<form method="post" action="save.as p">
Reg No: <input name="txtRegNo" type="text"
value="<%=oRS.F ields.Item(0).V alue%>"><br>
Name: <input name="txtName" type="text"
value="<%=oRS.F ields.Item(1).V alue%>"><br>
Relationship: <input name="txtRelati onship" type="text"
value="<%=oRS.F ields.Item(2).V alue%>"><br>
Years Known: <input name="txtYearsK nown" type="text"
value="<%=oRS.F ields.Item(3).V alue%>"><br>
<input name="hidID" type="hidden" value="<%=iID%> ">
<input type="submit">
</form>

save.asp:
<%
Dim iID, sRegNo, sName, sRelationship, iYearsKnown
Dim sSQL

iID = Request.Form("h idID")
sRegNo = Request.Form("t xtRegNo")
sName = Request.Form("t xtName")
sRelationship = Request.Form("t xtRelationship" )
iYearsKnown = Request.Form("t xtYearsKnown")

sSQL = "UPDATE ELPGeneral SET RegNo=" & TextIn(sRegNo) & ",[Name]=" &
TextIn(sName) & ",Relationship= " & TextIn(sRelatio nship) & ",YearsKnow n="
& iYearsKnown & " WHERE UID=" & iID
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
yourADOObject.E xecute sSQL,,129
yourADOObject.C lose
Set yourADOObject = Nothing

Response.Write "Saved."

Function TextIn(s)
TextIn = "'" & Replace(s, "'", "''")
End Function
%>

Ray at home
"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:uu******** ******@tk2msftn gp13.phx.gbl...
Here is my code for the page, cliELP_step02.a sp,

Now I need the results from the recordset, rsPeopleWhoCont ributed to be
broken down and populated in the textboxes below, named name,
relationship, yearsknown. So the data could look like this,

UID RegNo Name Relationship YearsKnown
1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

So if the user selected RegNo 01292 on cliELP_step01.a sp, and then
clicked Goto Step 2, then it would query the db using RegNo 01292 and
that recordset needs to be populated into the textboxes. So textbox name
1 would have John Doe, and relationship txtbox 1 would have Father and
textbox yearsknown 1 would have 39. So on and so on.

TIA,
Drew

Code below,

<%@LANGUAGE="VB SCRIPT" CODEPAGE="1252" %>
<!--#include file="../Connections/CliELP.asp" -->
<%
'Insert data from cliELP_step01.a sp
If Request.Form("a ctions") <> 1 Then

'SQL for inserting into SQL Server
sql="INSERT INTO ELPGeneral (RegNo,DesiredN ame)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("R egNo") & "',"
sql=sql & "'" & Request.Form("D esiredName") & "')"

'execute the insert to SQL Server
Set MM_editCmd = Server.CreateOb ject("ADODB.Com mand")
MM_editCmd.Acti veConnection = MM_CliELP_STRIN G
MM_editCmd.Comm andText = sql
MM_editCmd.Exec ute
MM_editCmd.Acti veConnection.Cl ose


Jul 21 '05 #7
Take what I used in showall.asp, but instead of writing the values in
between <td></td> tags, write the values into textboxes.

Ray at work
"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:On******** ********@TK2MSF TNGP10.phx.gbl. ..
I have gotten the saving part down pat, but my problem lies in populating
the multiple fields with records from the recordset. If my data looks like
this,

UID RegNo Name Relationship YearsKnown
1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

Then RegNo 01292 has 4 records, if RegNo 01292 was selected on the first
page I would like for the page to look like this, (this is only a snippet
of the code)

<table width="100%" border="0" cellspacing="5" cellpadding="0" >
<tr>
<td width="6%">&nbs p;</td>
<td width="44%"><di v
align="center"> <strong>Name</strong></div></td>
<td width="27%"><di v
align="center"> <strong>Relatio nship</strong></div></td>
<td width="23%"><di v align="center"> <strong>Yrs Known
</strong></div></td>
</tr>
<tr>
<td><strong>1 </strong></td>
<td>
<div align="center">
<input name="name" type="text" id="name"
value="John Doe" size="25">
</div></td>
<td>
<div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Father" size="15">
</div></td>
<td>
<div align="center">
<input name="yearsknow n" type="text"
id="yearsknown " value="39" size="8">
</div></td>
</tr>
<tr>
<td><strong>2 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name"
value="Jane Doe" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Mother" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text"
id="yearsknown " value="39" size="8">
</div></td>
</tr>
<tr>
<td><strong>3 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name"
value="Janet Doe" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Sister" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text"
id="yearsknown " value="34" size="8">
</div></td>
</tr>
<tr>
<td><strong>4 </strong></td>
<td><div align="center">
<input name="name" type="text" id="name"
value="Jane Thomas" size="25">
</div></td>
<td><div align="center">
<input name="relations hip" type="text"
id="relationshi p" value="Aide" size="15">
</div></td>
<td><div align="center">
<input name="yearsknow n" type="text"
id="yearsknown " value="19" size="8">
</div></td>
</tr>

So in other words, there are 25 rows of textboxes, with 3 columns of
textboxes. If there are 25 records pertaining to the RegNo, then all the
boxes will be filled with data.

My question is How do you break down the RS so the textboxes can be
populated?

Thanks,
Drew


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:OM******** ******@TK2MSFTN GP09.phx.gbl...
Okay, what you're trying to do is not an uncommon thing. That does not
mean that it is a trivial task, however. But, you're using Dreamweaver.
If you continue to use Dreamweaver for ASP editing, then it really
becomes a question of how to use Dreamweaver to create this
functionality. I'd imagine that it has the ability to do this, although
you won't really find too many Dreamweaver users around here.

If you choose to do ASP development by hand-coding (at least the ASP
part), then it's a matter of determining what needs to appear on your
page, how you get it to appear on your page, what data needs to be sent
to the server, how to ensure that data is sent to the server, and then
what to do with that data when it is sent to the server.

Do you want the ability to edit all the records at the same time? That's
a little more complex than one at a time, so for the time being, I'll
assume that you only want to do one at a time. If you want to do all at
a time, that's fine; just post back.

For the one at a time method, I'll break it out into multiple pages for
simplicity's sake. The process here is:

showall.asp:
Create a page that lists records and provides a link to an edit page,
which will display the records with the editable fields in text boxes.
It will pass the UID in the querystring to edit.asp.

edit.asp:
Pull the id from the querystring, and get the corresponding record in the
database from it. Then display current values in a form with the values
being displayed in textboxes. The ID will be passed to the next page in
a hidden input.

save.asp:
Get the data posted from the form and execute an UPDATE [non]query with
that information using a WHERE clause containing the UID that was passed
in the hidden form field on edit.asp.


showall.asp:
<%
sSQL = "SELECT UID,RegNo,[Name],Relationship,Y earsKnown FROM ELPGeneral"
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
Set oRS = yourADOObject.E xecute(sSQL)
If oRS.EOF Then
Response.Write "No items.
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
End If
%>

<table>
<%
''.GetRows is for another day!
Do While Not oRS.EOF
%>
<tr>
<td><a
href="edit.asp? id=<%=oRS.Field s.Item(0).Value )%>"><%=oRS.Fie lds.Item(1).Val ue%></a></td>
<td><%=oRS.Fiel ds.Item(2).Valu e%></td>
<td><%=oRS.Fiel ds.Item(3).Valu e%></td>
<td><%=oRS.Fiel ds.Item(4).Valu e%></td>
</tr>
<%
oRS.MoveNext
Loop
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
%>
</table>
edit.asp:
<%
Dim iID
iID = Request.Queryst ring("id") ''validate this
sSQL = "SELECT RegNo,[Name],Relationship,Y earsKnown FROM ELPGeneral WHERE
UID=" & iID
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
Set oRS = yourADOObject.E xecute(sSQL)
If oRS.EOF Then
Response.Write "Not found."
oRS.Close : Set oRS = Nothing
yourADOObject.C lose : Set yourADOObject = Nothing
End If
%>

<form method="post" action="save.as p">
Reg No: <input name="txtRegNo" type="text"
value="<%=oRS.F ields.Item(0).V alue%>"><br>
Name: <input name="txtName" type="text"
value="<%=oRS.F ields.Item(1).V alue%>"><br>
Relationship: <input name="txtRelati onship" type="text"
value="<%=oRS.F ields.Item(2).V alue%>"><br>
Years Known: <input name="txtYearsK nown" type="text"
value="<%=oRS.F ields.Item(3).V alue%>"><br>
<input name="hidID" type="hidden" value="<%=iID%> ">
<input type="submit">
</form>

save.asp:
<%
Dim iID, sRegNo, sName, sRelationship, iYearsKnown
Dim sSQL

iID = Request.Form("h idID")
sRegNo = Request.Form("t xtRegNo")
sName = Request.Form("t xtName")
sRelationship = Request.Form("t xtRelationship" )
iYearsKnown = Request.Form("t xtYearsKnown")

sSQL = "UPDATE ELPGeneral SET RegNo=" & TextIn(sRegNo) & ",[Name]=" &
TextIn(sName) & ",Relationship= " & TextIn(sRelatio nship) & ",YearsKnow n="
& iYearsKnown & " WHERE UID=" & iID
Set yourADOObject = CreateObject("A DODB.Connection ")
yourADOObject.O pen "your connection string here"
yourADOObject.E xecute sSQL,,129
yourADOObject.C lose
Set yourADOObject = Nothing

Response.Write "Saved."

Function TextIn(s)
TextIn = "'" & Replace(s, "'", "''")
End Function
%>

Ray at home
"Drew" <dr********@NOs wvtc.dmhmrsas.v irginia.SPMgov> wrote in message
news:uu******** ******@tk2msftn gp13.phx.gbl...
Here is my code for the page, cliELP_step02.a sp,

Now I need the results from the recordset, rsPeopleWhoCont ributed to be
broken down and populated in the textboxes below, named name,
relationship, yearsknown. So the data could look like this,

UID RegNo Name Relationship YearsKnown
1 01292 John Doe Father 39
2 01292 Jane Doe Mother 39
3 01292 Janet Doe Sister 34
4 08982 Dr. Mosely Doctor 15
5 08982 Jack Smith Aide 14
6 01292 Jane Thomas Aide 19

So if the user selected RegNo 01292 on cliELP_step01.a sp, and then
clicked Goto Step 2, then it would query the db using RegNo 01292 and
that recordset needs to be populated into the textboxes. So textbox
name 1 would have John Doe, and relationship txtbox 1 would have Father
and textbox yearsknown 1 would have 39. So on and so on.

TIA,
Drew

Code below,

<%@LANGUAGE="VB SCRIPT" CODEPAGE="1252" %>
<!--#include file="../Connections/CliELP.asp" -->
<%
'Insert data from cliELP_step01.a sp
If Request.Form("a ctions") <> 1 Then

'SQL for inserting into SQL Server
sql="INSERT INTO ELPGeneral (RegNo,DesiredN ame)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("R egNo") & "',"
sql=sql & "'" & Request.Form("D esiredName") & "')"

'execute the insert to SQL Server
Set MM_editCmd = Server.CreateOb ject("ADODB.Com mand")
MM_editCmd.Acti veConnection = MM_CliELP_STRIN G
MM_editCmd.Comm andText = sql
MM_editCmd.Exec ute
MM_editCmd.Acti veConnection.Cl ose



Jul 21 '05 #8

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

Similar topics

3
1576
by: luna | last post by:
theres no errors in my code - but it does nothing at all - its supposed to be populating text boxes!! any ideas ? (im am pretty new to all this) If Not Page.IsPostBack Then Dim search As String Dim strConn As String = "server=Gringotts;uid=sa;pwd=password;database=database"
6
2876
by: Chris Leuty | last post by:
I am populating a multiselect Listbox from a dataset, with the content of the listbox filled by one table, and the selections determined from another table. So far, I have been keeping the dataset a denormalized mirror of the database, but I'm not having much luck getting the selection logic down (I haven't found a 'hook' where I can access the listbox object as an object to set the listitem's selected property before it gets rendered).. ...
4
3924
by: Paul | last post by:
I sometimes get a timeout error when populating my datagrid, the code is WizardConnection.Open() UpdateCommand.CommandText = "EXECUTE sp_assign_user '" & PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'" UpdateCommand.ExecuteNonQuery()
1
1170
by: needin4mation | last post by:
I have a database with values. I retrieve the data from that database. I want to display that data from the database on the webpage. Is it incorrect to take that data and assign it manually like: (assuming I have textboxes named like this) txtLastName.Text = MyDataReader.Item("MyDatabaseColumn");
2
2119
by: johnb41 | last post by:
I have a very simple application where i just want to display records from a database, and be able to edit the records. Here's the code for the "update" button: Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click DA.Update(DataSet, "mytable") End Sub
10
1947
by: Marc R. | last post by:
Hi all, I edit records using a form that have multiple control bind on Dataview, But I don't want to update right always to database, I would like to delay until all Changes (add all new record using a form or edit various existing records) This way I could minimize transaction on server..
13
3543
by: Mary | last post by:
I'll pulling my hair out on this one and would be so appreciative of any help. I am creating a data entry form to enter results of a student survey. There are 40 questions on the survey. The first 7 have to do with respondent information like grade, class and age. I have those in a table with a PK of RespondentId, which is autonumbered. Questions 8-40 all have the same format. For these questions I have a table set up with the...
4
2597
by: Brybot | last post by:
I have a form that i've split up into multiple asp:panels, each panel has a number of validators which work correctly. At on the last panel, i want to commit the data collected to a database. I figured since all the panel data is still being sent through the postbacks, instead of using Sessions, or HttpContext, I could just take the values from the textboxes. This all works fine, except for security. I realized that I could inject...
0
4452
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
8796
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8704
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
9307
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
9170
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
9071
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
9009
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...
0
7946
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
2
2514
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2105
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.