Staying on the same page for Everything???

DougP · Jan 23, 2001

Maybe I am asking too much. I have a sample of my code. I want to be able to add a record in the form portion and then have the Table portion update to show the new record.
Maybe someone could see whats up.
It's running the Add and Delete sub's before the buttons are clicked. And if it inserts a record the values are blank.

--------------------
<html>
<%@ Language=VBScript%>
<head>
<title>New Patient</title>
<SCRIPT LANGUAGE="VBScript">
<!--
Sub Add_OnClick
Dim TheForm
Set TheForm = Document.ValidForm
If (TheForm.T1.Value) <> "" Then
<%' open SQL server database %>
<%Set Conn = server.CreateObject("ADODB.Connection&quot

%>
<%Conn.Open "driver={SQL Server};server=myserver.com;uid=ID;pwd=pass;database=Universal1;"%>
<%Conn.Execute("INSERT INTO [syspat] (PFName,PLName) VALUES ('" & T1 & "','" & T2 & "')&quot

%>
MsgBox "Thank you."
End If
End Sub

Sub Delete_OnClick
<%Conn.Execute("DELETE FROM [syspat] WHERE PFName = ''&quot

%>
End sub
-->
</SCRIPT>
</head>

<body>
<table border="1" width="99%" height="80">
<tr>
<td width="35%" height="74">
<form name="ValidForm">
<p align="center">Add New Patients</p>
<p>Fname<input type="text" name="T1" size="20"><br>
Lname <input type="text" name="T2" size="20"><br>
Address <input type="text" name="T3" size="20"><br>
Address2 <input type="text" name="T4" size="20"><br>
City <input type="text" name="T5" size="20"><br>
State <input type="text" name="T6" size="5"><br>
Zip <input type="text" name="T7" size="14"><br>
Country<input type="text" name="T8" size="14"></p>
<p align="center"><input type="submit" value="AddNew" name="Add">
<input type="reset" value="Clear" name="Clear">
<input type="submit" value="Delete Blanks Records" name="Delete">

</form>
------------------------

TIA
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

iqof188 · Jan 23, 2001

The way you do it now is impossible: somehow there has to be some traffic between client and server, and you can't put DB interaction inside clientside VBscript, so that won't work

.
If I have a good understanding of what your problem, you want to add and delete records from your database, and stay on the same page right?
In my humple ;-) opinion, there's two good ways to do this:

1. Use a hidden frame where you do all the processing:
Create a two-frame page, 1 of only 1 pixel height (name it "process&quot

, and that covers the rest of the screen (name it "display&quot

.
Put all the DB interaction code in the "process" frame, and the code for the form in "display".
Change your form tag to the following:

<form name="ValidForm" action="process.asp" method="post" target="process">

Whenever one of the buttons is clicked now, the values from the form will be sent to the hidden frame, where the processing is done. The "display" frame stays on the same page (it shows the form).

2. Use WDDX to convert the recordset object to Javascript so you can do everything on the client. There is an excellent tutorial on this on webmonkey:

http://hotwired.lycos.com/webmonkey/99/15/index3a.html?tw=authoring

I hope you can figure it out, post again if you get stuck!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Staying on the same page for Everything???

DougP

MIS

iqof188

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor