Avatar of chrisryhal
chrisryhal asked on

PostBack without refresh?

Working with VB.NET/ASP.NET I have obviously been impressed with the post back features.  I have an Classic ASP question though.  I do know that JavaScript and/or VBScript has AUTO postback features WITHOUT the actual page refreshing.  

My code is attached as a snippet, a simple SELECT query procedure ran from a SPROC to SQL that simply displays data, and nothing more.   My question is HOW can I execute this code WITHOUT the page having to basically be refreshed when a user does something as simple as modify a textbox field?  perhaps I should post this in JavaScript section of EE, but I want to start with Classic ASP.  I am game to use any web lang. technologies available to perform this action.


<% 
dim cr_i
dim cr_cellString
dim cr_dbconn
dim cr_sqlstr
dim cr_results
 
Set cr_dbConn = Server.CreateObject("ADODB.Connection")
cr_dbConn.Open "DSN=TESales"
 
 
cr_sqlstr = "EXEC prScoutOrderTypeAllocation_selAllocations '9252','14'" 
 
Set cr_results = cr_dbConn.Execute(cr_sqlstr)
 
if cr_results.eof then
  response.write("I find no records")
 
else
  %>
  
  <%
  cr_i = 1
  do until cr_results.eof
    cr_cellString = Response.Write("Group Sales Total: ") & cr_results("Allocation") & "<br>"
 
    if not cr_i mod 6 = 0 then
      response.write(cr_cellString)
    else
      response.write(cr_cellString)%>
      
      <%
    end if		
 
    cr_i = cr_i + 1
    cr_results.movenext
  loop
%>
 
<%
end if
%>

Open in new window

ASP

Avatar of undefined
Last Comment
chrisryhal

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
neeraj523

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
greengo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
chrisryhal

The clarification was enough to get me where I need to be.  I appreciate the efforts and comments.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy