troubleshooting Question

PostBack without refresh?

Avatar of chrisryhal
chrisryhal asked on
ASP
3 Comments1 Solution1111 ViewsLast Modified:
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
%>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros