How to update db & ASP page from buttons 3

scc · Oct 16, 2002

I have a huge form with disabled input boxes for viewing purposes only, except for one area. What I need to do is to allow the user to type a number in a text box, and choose either a + or - button that will call a stored procedure (sprocUpdateVisits) to update the db, and leave the user on this same ASP page but clear the text box. The page needs to be ready for the use to increment/decrement again if needed.

I'm at a loss how to begin.

I have to use VBScript server-side, and JavaScript client-side.

Here's the html tags:

<td align="right">
+/- Visits:
</td>
<td>
<input type="text" name="AdjustVisits" size="5"
value="" >
<input type="button" name="btnAdd" value="+" >
<input type="button" name="btnSubtrace" value="-" >
</td>

Thanks for your help!

Stoemp · Oct 16, 2002

What you can do is call with the script to a new window, load an asp page in the new window and let this page do the job for updating the database. Then you make the popup window close itself.

Tarwn · Oct 16, 2002

A similar, but less noticeable, trick is to load the asp page in a hidden iframe by changing the address of the iframe to reflect the target page with your variables passed as a querystring.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
With enough resources, time, and coffee, anything is possible.

scc · Oct 16, 2002

Stoemp or someone else, can you post some sample code for the pop-up window to close itself?

Tarwn, I'm sorry, but your response went right over my head. I'd be interested in knowing more, or seeing some sample code.

Thanks!

Stoemp · Oct 17, 2002

just use as code inside the window:

self.close()

This will close the window. But you have to be sure the code is only executed when the database is updated, so you'd do best if you place it in the document's body tag:

<body onLoad="self.close();">

This will execute if the page is completely loaded, so in most cases this is when the asp code is executed.

I hope I can help you with this.

Tarwn · Oct 17, 2002

Ok, pretend you need to pull a users top x color preferences out of a table based on someone selecting that user from a drop down box:

Code:

<html>
<head>
<script language=&quot;JavaScript&quot;>
<!--
function dataReceiver(resultStr){
	var arrayResults = resultStr.split(&quot;,&quot;);	// the string is passed as value,value,value,
			//so the last elemt in our new result array will be a null value

	//do whatever you want with the results here
}
//-->
</script>
</head>
<body>
<!-- Normally this would be filled from a db table, but you get the idea -->
How Many Color Preferences? <input type=&quot;text&quot; value=&quot;3&quot; name=&quot;txtNumPref&quot;><br>
Pick a User:<select name=&quot;selUser&quot;>
   <option value=&quot;bob&quot;> bob </option>
   <option value=&quot;joe&quot;> joe </option>
   <option value=&quot;jill&quot;> jill </option>
</select><a href=&quot;#&quot; onClick=&quot;document.getElementById(&quot;ifrm&quot;).src='getPref.asp?user='+selUser.options[selUser.SelectedIndex]+'&numPref='+txtNumPref.value&quot;>Get his they're top preferences!</a>
<iframe id=&quot;ifrm&quot; style=&quot;display:none;&quot;></iframe>
</body>
</html>

The in our asp page called getPref we would make the SQL statement, execute it, then write the results into a javascript function to execute onLoad:

Code:

<%
Option Explicit
Dim sqlStr, objRS
sqlStr = &quot;SELECT TOP &quot; & Request.QueryString(&quot;numPref&quot;) & &quot;* FROM Preferences WHERE user = '&quot; & Request.QueryString(&quot;user&quot;) & &quot;'&quot;

'execute the sql query into our recordset objRS

%>
<html>
<head>
<script language=&quot;JavaScript&quot;>
<!--
function sendBack(){
   parent.dataReceivier(&quot;
   <%
   objRS.MoveFirst
   Do Until objRS.EOF
		Response.Write objRS(&quot;color&quot;) & &quot;,&quot;
		objRS.MoveNext
   Loop
   %>
   &quot;);
}
//-->
</script>
</head>
<body onLoad=&quot;sendBack();&quot;>
</body>
</html>

I have also used this method to write out a table of results in the iframe (change the object.style.display = 'inline'; for it to be seen) and only passed back a result that they choose from the magical appearing results.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
With enough resources, time, and coffee, anything is possible.

adam0101 · Oct 17, 2002

I'd make your first page look like:
<iframe name="hiddenIframe" src="about:blank" style="display:none"></iframe>
<form action="secondPage.asp" target="hiddenIframe" onsubmit="this.reset()">
<table>
<tr>
<td align="right">+/- Visits:</td>
<td>
<input type="text" name="AdjustVisits" size="5" value="">
<input type="submit" name="btnAction" value="+">
<input type="submit" name="btnAction" value="-" >
</td>
</tr>
</table>
And make your second page look like this:
<%
If Request("btnAction&quot

="+" Then
objConn.Execute "sprocUpdateVisits '+'," & Request("AdjustVisits&quot

ElseIf Request("btnAction&quot

="-" Then
objConn.Execute "sprocUpdateVisits '-'," & Request("AdjustVisits&quot

End If
%>

This of course assumes your stored procedure is setup to accept 2 parameters, the first being the plus or minus string, the second being the numeric value the user entered.

Adam

http://www.adventex.com

scc · Oct 25, 2002

Sorry... just getting back to this code.

I'm going to try using the hiddenIframe and just have a few questions.

Does the connection code (or include file...) need to go into the secondPage.asp, or does it honor the variables, and connection code in the first page?

Where can I read about iframes?

Thanks

scc · Oct 25, 2002

OK! I've been working on this all day (&%$^#%%&^!!), and need some help.

The following is sample code. Note when you type in a value on the first page (SamplePage1.asp) it should process the info in SamplePage2.asp, SamplePage2.asp should then close automatically and change the values on the form SamplePage1.

Here's the code for SamplePage1.asp:

<% @ Language ="VBScript" %>
<% Option Explicit %>
<%
Response.Expires = 0
Response.Buffer=True

'Filename: ReferralView.asp
%>

<html>

<body>

<iframe name=hiddenIframe" src="about:blank"
style="display:none">
</iframe>
<table width="640" align="center" cellpadding="1" border="1">
<form name='ClaimsView' action=SamplePage2.asp
target="hiddenIframe">

<tr>
<td align="right">
Visits Approved:
</td>

<td align="center" width="100">
10
<input type="hidden" name="Visits" value="10" >
</td>
<td align="right">
Remaining:
</td>
<td align="center" class="tdbold">
<input type="text" name="Remaining" value="3" size="5" >
</td>
<td align="right" class="emphasize">
+/- Visits:
</td>
<td>
<input type="text" name="AdjustVisits" size="5" value="" >
<input type="submit" name="Submit" value="+" >
<input type="submit" name="Submit" value="-" >
</td>
</tr>
</form>
</table>

</body>
</html>

and here's the code for SamplePage2.asp

<% @ Language ="VBScript" %>
<% Option Explicit %>
<%

'Filename: AdjustReferralVisits.asp

Dim iReferralNum
Dim iVisits
Dim iAdjustVisits
Dim iAdjustment
Dim iVisitsRemaining

iReferralNum = mid(Request("ReferralNum&quot

,2)
iVisits = Request("Visits&quot

iAdjustVisits = Request("AdjustVisits&quot

If Request("Submit&quot

= "+" then
iAdjustment = iAdjustVisits

ElseIf Request("Submit&quot

= "-" then
iAdjustment = - iAdjustVisits
End If

iVisitsRemaining = iVisits + iAdjustment

%>

<html>
<head>
<script language="javaScript">
<!--

function sendBack()
{
parent.document.ClaimView.Remaining = ("<%= iVisitsRemaining %> & &quot

;
parent.document.ClaimView.AdjustVisits = "";
}
//-->
</script>

</head>

<body onLoad="sendBack();">

</body>
</html>

adam0101 · Oct 28, 2002

Your form name is ClaimsView, but you refer to it as ClaimView in your code on the second page. Adam

http://www.adventex.com

adam0101 · Oct 28, 2002

Also,
parent.document.ClaimView.Remaining = ("<%= iVisitsRemaining %> & &quot

;
parent.document.ClaimView.AdjustVisits = "";

should be

parent.document.ClaimsView.Remaining.value = ("<%= iVisitsRemaining %> & &quot

;
parent.document.ClaimsView.AdjustVisits.value = ""; Adam

http://www.adventex.com

scc · Oct 30, 2002

I have just one question about the <iframe> tag to process a page. When you do this, does it reload the parent page?

I guess what I'm wondering is if there is a difference in processing when you do this via and <iframe> tag versus a self-referencing page, which I know reloads the page.

Tarwn · Oct 30, 2002

It shouldn't, basically it loads and process a new page in the iframe then the new page passes data back to your existing page as if the data in the iframe had been there the whole time.
-Tarwn

--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)

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!

How to update db & ASP page from buttons 3

scc

Programmer

Stoemp

Programmer

Tarwn

Programmer

scc

Programmer

Stoemp

Programmer

Tarwn

Programmer

adam0101

Programmer

scc

Programmer

scc

Programmer

adam0101

Programmer

adam0101

Programmer

scc

Programmer

Tarwn

Programmer

Similar threads

Part and Inventory Search

Sponsor

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!

How to update db &amp; ASP page from buttons 3

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor

How to update db & ASP page from buttons 3