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.
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
%>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER