Previous Article Ajax Tutorial: Dynamic Loading of ComboBox using jQuery and Ajax in ASP Classic |
Scrolling Page with ASP Classic And JQuery |
Next Article Sorting with Ajax and ASP Classic |
Coding Article #: 36 - Published On: July 05, 2012 @ 02:25:04 AM - Last Updated on: October 16, 2012
This article has been Favorited 38 timesJoin today, and add this to your favorites.
Share With Friends (Updated 6-8-2010)
This is a very useful code, especially if you have a lot of images on a page, loaded in from a database. This code will allow you go easily load the images or text information without everything loading at one time, which is not only a great time saver, it is however, a great bandwidth saver as well.
This code was originally called: Load Data while Scrolling The Page«
Srinivas Tamada is a great PHP programmer, and the cool thing about a lot of the PHP scripts that has has, I have already converted over to ASP Classic, and am slowly adding this to the site here on Coding Source.
Example: View Live Example«
This code was originally called: Load Data while Scrolling The Page«
Srinivas Tamada is a great PHP programmer, and the cool thing about a lot of the PHP scripts that has has, I have already converted over to ASP Classic, and am slowly adding this to the site here on Coding Source.
Example: View Live Example«
<%
last_msg_id=request("last_msg_id")
Set sqlImg = CreateObject("ADODB.Command")
sqlImg.ActiveConnection=objConn
sqlImg.Prepared = true
sqlImg.commandtext = "SELECT id, imagepath, imagename, imagedesc from images WHERE id < ? ORDER BY id DESC"
sqlImg.Parameters.Append sqlImg.CreateParameter("@id", 3, 1, , last_msg_id)
set rsImg = sqlImg.execute
last_msg_id=""
while not rsImg.eof and counter < 5
msgid = rsImg("id")
msg = rsImg("imagename")
img = rsImg("imagepath")
%>
<div id="<%=msgid%>" style="text-align:left;" class="message_box" >
<table><tr><td style="width:200px;"><span class="number"><%=msgid%></span><%=msg%></td>
<td><img src="images/<%=img%>" title="<%=msg%>" height="55"/></td></tr></table>
</div>
<%counter = counter + 1
rsImg.movenext
wend
%>
Post to Facebook about: Scrolling Page with ASP Classic And JQuery