Ok here is a cut down version of what I have. The script that opens the database works now but I think I should put it in another file (opendb.asp). Then call that file.
Then The script on the botton will probably also need to be put in another file (writedb.asp). This is the script I don't know how to write. It will need to open the database and write what i have changed in the page.
I'm not sure how to setup the submit button to open the writedb.asp file for writing either.
Sorry for my lack of knowledge with this I have only been workign with this for a couple weeks.
<%@ Language=VBScript %>
<% OPTION EXPLICIT %>
<% '========================================================
'opendb.asp
Dim objRS, strSQL, Connstr, objConn, fullname, phone
Set objConn = Server.CreateObject ("ADODB.Connection")
Connstr = "Driver=Microsoft Visual Foxpro Driver;" + _
"UID=; SourceType=DBC; SourceDB=C:\inetPub\
objConn.Open Connstr
Set objRS=Server.CreateObject ("ADODB.recordset")
strSQL="select * FROM usertable where phone = '5026548888'"
objRS.Open strSQL, objConn
'======================================================== %>
<html>
<title>Test</title>
<body bgcolor="#CCCCCC" text="#000000">
<form action="form7.asp" method="get">
<p align="center"> <br>Lead Sheet</p>
<table width="100%" border="0">
<tr>
<td height="23" colspan="4"><strong><font size="+1">PERMANENT HOME</font></strong>
</td>
</tr>
<tr>
<td width="13%"><div align="right"><strong>Full Name: </strong></div></td>
<td width="34%"><% Response.Write ("<input name='fullname' type='text' id='fullname' size='45' maxlength='30' value='"& objrs("fullname")&"'></td>") %>
<td width="15%"><div align="right"><strong>Phone: </strong></div></td>
<td width="38%"><% Response.Write ("<input name='phone' type='text' id='phone' size='45' maxlength='10' value='"& objrs("phone")&"'></td>") %>
</tr>
<tr>
<td><input name="submit" type="submit" value="Submit"></td>
</tr>
</table>
<p align="left"><br>
</p>
<br>
<p>
</form>
</body>
<% '========================================================
writedb.asp
fullname = Request.QueryString("fullname")
phone = Request.QueryString("phone")
Set objRS=Server.CreateObject ("ADODB.recordset")
strSQL = "update usertable set fullname = '"& fullname &"' where phone='"5026548888"'"
objRS.Open strSQL, objConn
'======================================================== %>
</html>
