Thank you very much for all of your help. But you know how when you
think you are done with a project, you think of seomthing else that
would be nice to add? Well I thought of one that I cannot figure out.
This web page returns a result into another page called noc,when you
select the bug# from the primary page.The noc page Then displays the
bug# with a description and the noc(number of calls). I would like to be
able to update the noc from the noc page. This is my page as it stands
right now.
<!--#Include Virtual="/bug/adovbs.inc"-->
<title>Number of Calls</title>
<%
Dim conn
Set conn = Server.CreateOb ject("ADODB.Con nection")
conn.Open "Provider=SQLOL EDB; Data Source = (local); Initial Catalog =
techsupportBT; User Id = sa; Password="
Set rsNOC = server.CreateOb ject("ADODB.Rec ordset")
strBugIndex = trim(Request.Qu eryString("bind ex"))
strSql = "Select n.bugindex, t.description, n.noc "
strSql = strSql & "from NOC n, tshighissues t "
strSql = strSql & "where n.BugIndex = " & strBugIndex & " "
strSql = strSql & "And t.BugIndex = n.BugIndex "
set rsNOC=conn.Exec ute(strSql)
%><body bgcolor="#E8E8E A"><div align="left">
<p>
<a href="bug2.asp" >
<img border="0" src="hdr_logo.j pg" width="240" height="37"></a> </p>
<p align="left">
<u><font size="6"
color="#94B2C6" ><b><i> &n bsp;   ; &n bsp; &n
bsp;   ; &n bsp;   ; &n bsp; &n
bsp;   ; &n bsp;   ; &n bsp; &n
bsp;   ; &n bsp;   ; &n bsp; &n
bsp;   ; &n bsp;   ; &n bsp; &n
bsp;   ; &n bsp;   ; &n bsp;
Bug Status
Board &nbs p; & nbsp; &nbs p; & nbsp; &
nbsp; &nbs p; & nbsp; &nbs p; & nbsp; &
nbsp; &nbs p; & nbsp; &nbs p; & nbsp; &
nbsp; &nbs p; & nbsp; &nbs p; & nbsp; &
nbsp; &nbs p; & nbsp; &nbs p; & nbsp;
</i></b></font></u></p>
<Table bordercolorligh t="#94B2C6" bordercolordark ="#000080"
border="2" bordercolor="#F 3F3F3" align="left" width="100%">
<tr>
<th height="28">Bug #</th>
<th height="28">Des cription</th>
<th height="28">NOC </th>
</tr>
<%
While not rsNOC.EOF
%>
<tr>
<td><%=rsNOC.fi elds(0)%></td>
<td><%=rsNOC.fi elds(1)%></td>
<td><%=rsNOC.fi elds(2)%></td>
</tr>
</div>
What do you think would be the best way to add an update script into
this page to be able to update the noc column?
<%
rsNOC.MoveNext( )
Wend
%><Close recrordsets and connection></body></html>
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!