Link to home
Start Free TrialLog in
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

ASKER CERTIFIED SOLUTION
Avatar of neeraj523
neeraj523
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chrisryhal
chrisryhal

ASKER

The clarification was enough to get me where I need to be.  I appreciate the efforts and comments.