Paging in ASP BEST APPROACH

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Enumerate Local Variable Scope Does anyone know of a way to enumerate the local variable scope? The reason I ask is that I have a function that dumps the contents of response,request,server,etc... for debugging purposes. I'd like to also display the local variables. TIA -Chris Tag: Paging in ASP BEST APPROACH Tag: 265729
  - 2
    - <textarea> bug???? Simple vbscript,html page loading into access. Input pg posting to Confirm pg, then sending to access. when using; <textarea name="name" tabindex="15"> </textarea> as an input renders tab spaces automatically. I took out <Div> tags, and tried nowrap, and tried reformatting data before sending to dbase (CStr, Trim), with no answer to alleviate this problem. Any suggestions???? Tag: Paging in ASP BEST APPROACH Tag: 265718
  - 3
    - What's the tool to use to deploy web-based apps? Hi there, What's a great tool to use to deploy n-tier web-based apps? I'm thinking in terms of an installer that produces a package that a client can run that will set up one or more IIS sites, copy files to an NTFS partition and set permissions, create an application and install COM objects in Component Services, attach (or script the creation and population of) a SQL Server 2000 database, etc. I'm currently using ASP, IIS 5.0, SQL Server 2000 and VS 6.0 but am about to take the plunge into .NET for new development. What are the tools that I should be looking at? Regards, Alan Tag: Paging in ASP BEST APPROACH Tag: 265717
  - 4
    - ASP to MSWord I'm using Response.ContentType="application/msword" to open ASP page in MS Word 2000 from IE6.0. It's works fine on one computer, but on other IE doesn't recognize type of file and refused to open it at all. Does anyone has an idea what causing this problem? Thanks. Tag: Paging in ASP BEST APPROACH Tag: 265715
  - 5
    - Web enabled apps/Thin client apps I'm writing an article and I need your informed opinions, so I ask you this: 1. Doesn't the web-enabled app generally run slower for one reason or another? 2. Isn't the fact that application graphics must be limited, just proof of #1, especially with low bandwidth situations? 3. Aren't the web-enabled apps really less feature rich because the developer has to emulate the controls of a thick/fat client app, and sometimes you just can't reproduce the features you find in a client PC or server based app? 4. Isn't the user's internet connection speed (or lack of) at least a significant bottleneck to app speed? 5. Isn't a very fast internet connection with a good web-enabled app still slower by quite a bit than the app that is resident on the hard drive of a good PC such as desribed below? These are my basic questions and I can't imagine a web app that will run as fast as one installed on my 2.4 Ghz PC with a hair over 1 Ghz of RDRam. Thank you ! Richard Choate Tag: Paging in ASP BEST APPROACH Tag: 265710
  - 6
    - Collections in ASP: Names vs. Numbers I am using the Folder.Files collection to display all the images in a given directory. The following shows the code I use to create and use this collection: Set myfilesys=Server.CreateObject("Scripting.FileSystemObject") Set mydirectory=myfilesys.GetFolder(Server.MapPath("./emoticons")) When I use a specific file name to access a file, my code works fine: <img src=" & Chr(34) & mydirectory.Name & "/" & mydirectory.Files("blinkgirl.gif").Name & Chr(34) & "> However, I want to iterate through all the files in the Folder USING NUMBERS (I already know how to do it using a For Each statement). But whenever I try to do this, I receive an error: <img src=" & Chr(34) & mydirectory.Name & "/" & mydirectory.Files(5).Name & Chr(34) & "> Other collections, such as the Request.Form collection allow you to access the collection using either text or numbers, and all books that I have read have said that this is true for all collections. Is the Folder.Files collection an exception to this? Is there something else I need to do? If anybody can give me any help on this, I would appreciate it. Thank You. -- Nathan Sokalski njsokalski@hotmail.com http://www.students.kutztown.edu/soka0908/HomePage.html Tag: Paging in ASP BEST APPROACH Tag: 265700
  - 7
    - using createElement with VBScript Hi, I am trying to create dynamic list boxes using the onChange event handler. Basically what I have here is a little function called NumberOfDays which returns the number of days in a given month in a given year. I then have an html select box <select> that I am populating with the number of days returned from the function. Essentially, this subroutine works. For instance, if I select January of 2003, then it populate my select box with numbers 1-31 but the problem is if it gets called a second time, it doens't clear the original data. So if I select January of 2003, and then I select January of 2002, the select box will be filled with 1-31,1-31 Here is my subroutine: Sub end_year_OnChange days=NumberOfDays(form1.end_month.Value, form1.end_year.Value) for i=1 to days Set Opt = document.createElement("OPTION") Opt.text = i Opt.value = i Opt.ID = i form1.end_day.Add Opt Set Opt = Nothing Next End Sub Tag: Paging in ASP BEST APPROACH Tag: 265698
  - 8
    - How to associate the value of dropdown with checkbox Hi All, I have the following case. I am trying to update a table based on the value of dropdown box and checkbox. Here is what I have in page1.asp <table> <tr> <td>STATUS</td> <td>Claim Number</td> <td>Select</td> </tr> <form name=form action='Page2.asp' method='post'> <%dim I : I=1 do while not rs.EOF%> <tr> <td> <select name="selStatus"> <option value="A" selected>A</option> <option value='P'>P</option> <option value='D'>D</option> </select> </td> <td><%=rs("Claim_Number")%></td> <td><input type='checkbox' name='chk<%=i%>' value='<%=rs("Claim_Number")%>'></td> </tr> <%rs.MoveNext I = I + 1 Loop %> <tr align='center' bgcolor='white'> <td><input type="submit" value="Submit" name="cmdSubmit"> <input type='hidden' name='No_of_Records' value='<%=I%>'> </td> </tr> </form> </table> Now in page2.asp, I need to update data based on which checkbox was checked and what was selected in the STATUS field which is A, P and D. I have the following code in page2.asp: if Len(Request.Form("cmdSubmit"))>0 then dim JJ dim No_Of_Records, strClaimID, strStatusCD No_Of_Records=Request.Form("No_of_Records") For JJ=0 to No_Of_Records-1 if Request.Form("chk" & JJ)<>"" then strClaimID=Request.Form("chk" & JJ) qry="Update warx065_srs set VENSTATCDE='" & strStatusCD & "' where ClaimNumber='" & strClaimID & "'" Conn.Execute(qry) end if Next end if The code in page2.asp selects the right claim Number but not the right status. For ex. if I check 2 checkboxes and run the query I get the following: Update table1 set VENSTATCDE='A, A, D, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A' where ClaimNumber='K90611' Update table1 set VENSTATCDE='A, A, D, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A, A' where ClaimNumber='K93632' I have 50 records in each page. How can I associate the value of dropdown with checkbox in this case. I would highly appreciate your help. Thanks a lmillion in advance. best regards, mamun Tag: Paging in ASP BEST APPROACH Tag: 265697
  - 9
    - ASP Speed Tricks updated I posted this article I wrote a couple weeks ago, but I've completely updated it, with new sections on the performance of 'bursting' GetRows and GetString. If you're interested: http://www.somacon.com/aspdocs/ Tag: Paging in ASP BEST APPROACH Tag: 265692
  - 10
    - read favorites Hello Ng, is there a way to read out the users favorites with asp? Or do I have to write a little plugin in vb which posts it to the database? Greets, Martin Tag: Paging in ASP BEST APPROACH Tag: 265691
  - 11
    - Cannot browse ASP locally on one particular web Hello, ASP does not work locally on my main web site when I browse the machine locally at the console itself, but to the outside world all is fine, and ASP executes normally. I have 4 other virtual webs on this server and I can browse ASP pages fine, locally. We need this working for a search engine product that is failing when trying to execute URLs against this virtual web site, locally. I ran a filemon and here is some interesting output of FNFs: FILE NOT FOUND Attributes: Error 54 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\shdocvw.dll FILE NOT FOUND Attributes: Error 55 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\system32\inetsrv\shdocvw.dll FILE NOT FOUND Attributes: Error 65 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\BROWSEUI.dll FILE NOT FOUND Attributes: Error 66 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\BROWSEUI.dll FILE NOT FOUND Attributes: Error FILE NOT FOUND Attributes: Error 395 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\System32\mlang.dll SUCCESS Attributes: A 396 1:25:45 PM IEXPLORE.EXE:604 OPEN C:\WINNT\System32\mlang.dll SUCCESS Options: Open Access: Execute 397 1:25:45 PM IEXPLORE.EXE:604 CLOSE C:\WINNT\System32\mlang.dll SUCCESS 398 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\wsock32.dll FILE NOT FOUND Attributes: Error 399 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\wsock32.dll FILE NOT FOUND Attributes: Error 400 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\System32\wsock32.dll SUCCESS Attributes: A 401 1:25:45 PM IEXPLORE.EXE:604 OPEN C:\WINNT\System32\wsock32.dll SUCCESS Options: Open Access: Execute 402 1:25:45 PM IEXPLORE.EXE:604 CLOSE C:\WINNT\System32\wsock32.dll SUCCESS 403 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\WS2_32.DLL FILE NOT FOUND Attributes: Error 404 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\WS2_32.DLL FILE NOT FOUND Attributes: Error 405 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\System32\WS2_32.DLL SUCCESS Attributes: A 406 1:25:45 PM IEXPLORE.EXE:604 OPEN C:\WINNT\System32\WS2_32.DLL SUCCESS Options: Open Access: Execute 407 1:25:45 PM IEXPLORE.EXE:604 CLOSE C:\WINNT\System32\WS2_32.DLL SUCCESS 408 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\WS2HELP.DLL FILE NOT FOUND Attributes: Error 409 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\WS2HELP.DLL FILE NOT FOUND Attributes: Error 497 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\RASAPI32.DLL FILE NOT FOUND Attributes: Error 498 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\RASAPI32.DLL FILE NOT FOUND Attributes: Error 499 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\System32\RASAPI32.DLL SUCCESS Attributes: A 500 1:25:45 PM IEXPLORE.EXE:604 OPEN C:\WINNT\System32\RASAPI32.DLL SUCCESS Options: Open Access: Execute 501 1:25:45 PM IEXPLORE.EXE:604 CLOSE C:\WINNT\System32\RASAPI32.DLL SUCCESS 502 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\RASMAN.DLL FILE NOT FOUND Attributes: Error 503 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\RASMAN.DLL FILE NOT FOUND Attributes: Error 504 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\System32\RASMAN.DLL SUCCESS Attributes: A 505 1:25:45 PM IEXPLORE.EXE:604 OPEN C:\WINNT\System32\RASMAN.DLL SUCCESS Options: Open Access: Execute 506 1:25:45 PM IEXPLORE.EXE:604 CLOSE C:\WINNT\System32\RASMAN.DLL SUCCESS 507 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\TAPI32.DLL FILE NOT FOUND Attributes: Error 508 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\TAPI32.DLL FILE NOT FOUND Attributes: Error 509 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\WINNT\System32\TAPI32.DLL SUCCESS Attributes: A 510 1:25:45 PM IEXPLORE.EXE:604 OPEN C:\WINNT\System32\TAPI32.DLL SUCCESS Options: Open Access: Execute 511 1:25:45 PM IEXPLORE.EXE:604 CLOSE C:\WINNT\System32\TAPI32.DLL SUCCESS 512 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Program Files\Internet Explorer\RTUTILS.DLL FILE NOT FOUND Attributes: Error 513 1:25:45 PM IEXPLORE.EXE:604 QUERY INFORMATION C:\Documents and Settings\joelh\Desktop\RTUTILS.DLL FILE NOT FOUND Attributes: Error Tag: Paging in ASP BEST APPROACH Tag: 265678
  - 12
    - Recordset Paging between frames Does anybody know where can i get a sample on how to do recordset paging between two frames or between page an iframe that is within. ----------------------------- This message is posted by http://Asp.ForumsZone.com Tag: Paging in ASP BEST APPROACH Tag: 265667
  - 13
    - site asp.net with mysql How create site with webmatrix with MySql ? it's possible ? thanks for help and links examples... Vivian vivianelima@ligbr.com.br Tag: Paging in ASP BEST APPROACH Tag: 265663
  - 14
    - Validation only works sometimes I've got a C# ASP.NET web form that fails to validate under certain conditions. I have a radio button that causes an AutoPostback that enables certain other elements on the form. If I click that radio button, the validation will work when I click Submit. However, if I enter the page and never click that radio button then the page submits as if there were no validation at all. I'm not sure how that radio button fits into the picture but was wondering if anyone else had seem something similar to this? Thanks in advance for any helpful ideas anyone may have. Shane Tag: Paging in ASP BEST APPROACH Tag: 265651
  - 15
    - list documents in a html table I currently have a set of documents in a directory that i need to list in a html table. Is there any way to generate the table with the documents listed instead of having to update the table manually everytime a new document is added to the list. Thanks Ken Tag: Paging in ASP BEST APPROACH Tag: 265649
  - 16
    - how to open client phone dialer from ASP page This is a multi-part message in MIME format. ------=_NextPart_000_00B3_01C35043.11C722C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to open client phone dialer from my asp page that contains phone = number and fill phone number automatically when dialing. What should I = need to start about this? Please help! Jen ------=_NextPart_000_00B3_01C35043.11C722C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I need to open client phone dialer = from my asp=20 page that contains phone number and fill phone number automatically when = dialing.  What should I need to start about this? Please = help!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Jen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_00B3_01C35043.11C722C0-- Tag: Paging in ASP BEST APPROACH Tag: 265643
  - 17
    - Not using NT authentication I have an asp page on IIS 5.0 and I''m trying to get a dialog box to pop up and ask for username password and domain to authenticate against NT. I have anonymous logins unchecked in the IIS properties page and access restricted on everything but it won''t ask for a username and password no matter what! Please help! ----------------------------- This message is posted by http://Asp.ForumsZone.com Tag: Paging in ASP BEST APPROACH Tag: 265641
  - 18
    - What am I doing wrong with checkbox update? I have a form with multiple: <input type="checkbox" class="checkbox" name="green" value="true"<% if rs("hardstyle") = true then %> checked<% else %><% end if %>> Green<br> And I have the following if request.form("green") = false then db.execute("Update tblmemberinfo set green = false where mID = " & Request.cookies("isLogged")("mID") & "") else db.execute("Update tblmemberinfo set green= true where mID = " & Request.cookies("isLogged")("mID") & "") end if Each ofcourse with different names It is possible to set it to true but not able to change it back ? Help me please! Willem-Jan Selen Tag: Paging in ASP BEST APPROACH Tag: 265640
  - 19
    - A Free ASP/HTML Editor? I am looking for a free ASP/HTML editor. I have downloaded a few but they haven't really been what I am looking for. I want something pretty simple but that has colors, smart tabbing, etc. Any suggestions would be great! Thanks. Tag: Paging in ASP BEST APPROACH Tag: 265636
  - 20
    - Out of String Space: 'Replace' All of a sudden this morning my ASP files started generating the error: Out of String Space: 'Replace' These script files have been running just fine for several weeks with no problems. I did review the code and yes the script is calling the Replace function at the line specified in the error information. I'm puzzled as to why the code would all of a sudden start generating this error ? Any ideas ? Ed Tag: Paging in ASP BEST APPROACH Tag: 265612
  - 21
    - HTTP/1.1 New Session Failed Hi, getting the HTTP/1.1 New Session Failed message when trying to access an ASP page. It seems intermittent, at some point one machine will keep getting this message while another will access it just fine. The next day it will be the other way around. This page and application, just have regular ASP pages, not doing anything too spectacular. Any ideas? Tag: Paging in ASP BEST APPROACH Tag: 265609
  - 22
    - <TD> Question Hi, I am planning to insert data into column depending on which column.For example i wanted insert data in row 1 column 23, and row1 column 25.. Can i use sth like this: ****************************************** if column=25 then for i=1 to 25 'goto the 25th column and insert data there <td></td> next i write "fruits"... ********************************************* will it work?if not wht wud be better idea in inserting data in such scenario as above? TIA Tag: Paging in ASP BEST APPROACH Tag: 265593
  - 23
    - Windows NT authentication and asp??? Hi, Can someone tell me how I create a login page which authenticates users against the servers user manager. I want the login to be a form in my website not a pop up window! I would be grateful for any advice relating to this subject. I have a script for windows 2000 active directory but was wondering if you could achive the same with windows NT 4 and IIS 4 Thanks for any help! ..:: Active Directory Example :.. <form action=authad.asp method=post> Username: <input type=text name=strUserName><br> Password: <input type=password name=strPassword><br> <input type=submit name=btnSubmit> </form> <% If Request.Form("strUsername") <> "" Then Dim strADsPath strADsPath = "WinNT://copenhagendome1" 'userid = strUserName = "copenhagendome1\" & Request.Form ("strUserName") strPassword = Request.Form("strPassword") if (not strADsPath= "") then 'if and ADS Object path has been provided proceed with authentication ' bind to the ADSI object and authenticate Username and password Dim oADsObject Set oADsObject = GetObject(strADsPath) response.write "Authenticating...<br><br>" Dim strADsNamespace Dim oADsNamespace strADsNamespace = left(strADsPath, instr (strADsPath, ":")) set oADsNamespace = GetObject(strADsNamespace) Set oADsObject = oADsNamespace.OpenDSObject(strADsPath, strUserName, strPassword, 0) ' we're only bound if err.number = 0 if not (Err.number = 0) then Response.Write "<font color='red'><font size = 5><u><b>Authentication has failed...<b></u></font></font>" 'Response.Write "Failed to bind to object <b>" & strADsPath & "</b><br>" 'response.write err.description & "<p>" 'Response.write "Error number is " & err.number & "<br>" Session("Auth") = "NO" else Response.Write "<font color='blue'>USER AUTHENTICATED! </font><br>" 'Response.Write "Currently viewing object at <b>" & oADsObject.ADsPath & "</b><br>" 'Response.Write "Class is " & oADsObject.Class & "<br>" Session("Auth") = "YES" end if 'response.write "<p>" end if End If %> Tag: Paging in ASP BEST APPROACH Tag: 265581
  - 24
    - How to use Crystal Reports 8.5 in ASP v 3 HI, I have created a report in Crystal Reports 8.5 and want to display it on my clients webpage. I will develop this webpage in ASP v3 so plz give me the code with which to show this report of Crystal Reports 8.5 in the webpage developed in ASP v 3. I used Crystal Report Viewer ActiveX control but I do not know what code to write so that the control works properly, regards, Mustafa Haider Tag: Paging in ASP BEST APPROACH Tag: 265580
  - 25
    - How to show Crystal Reports 8.5 in ASP v3 HI, I have created a report in Crystal Reports 8.5 and want to display it on my clients webpage. I will develop this webpage in ASP v3 so plz give me the code with which to show this report of Crystal Reports 8.5 in the webpage developed in ASP v 3 . I used Crystal Report Viewer ActiveX control but I do not know what code to write so that the control works properly, regards, Mustafa Haider Tag: Paging in ASP BEST APPROACH Tag: 265579
- Next
  - 1
    - Out of memory: 'Server.CreateObject' Hi group! I am getting the following error from my ASP application: Microsoft VBScript runtime error '800a0007' Out of memory: 'Server.CreateObject' It always (as far as i have observed) occurs when i try to create a new ADODB.connection object in my cCon helper function (opening a connection and returning it): Function cCon() Dim cnRet set cnRet = server.createobject("ADODB.Connection") 'This is where the error is thrown cnRet.connectionstring = GLB_CONSTR_DB cnRet.open Set cCon = cnRet End Function The page that errors will typically call this function 6- 10times from different functions which handle their connections in this way: Function Foo() dim Con ... Set con = cCon() .... function code con.close set con = nothing End Function All my recordsets are disconnected and also destroyed with .close and Set rst = nothing. I have tested the application on two seperate servers with the same result. Both machines had more than enough memory. I have also checked the application log to see if anything was logged, but there wasnt. Any one got ANY ideas on this one? I'm starting to get desperate! Tag: Paging in ASP BEST APPROACH Tag: 265577
  - 2
    - FSO "getfolder" method problem. Hi, I bought a ASP portal script, aspportal.net, But It gives a problem from a line, Set folderpath = fso.getfolder(thepath) The error is, Error Type: Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method: 'getfolder' /aspportal/themes/themes.asp, line 37 What could be the problem? Please kindly help. Regards, Benny Tag: Paging in ASP BEST APPROACH Tag: 265574
  - 3
    - escape in ASP When chucking data in a cookie you cannot use certain characters (in this example ? : ? ). To get around this you use escape and unescape. Trying to use the escape as such: Response.Cookies("Lines")("URL4") = escape("http://www.ASP101.com") Gives the following result: URL4=http%3A//www.ASP101.com Which I don't think does anything to help. So using it like this: Response.Cookies("Lines")("URL4") = "escape(http://www.ASP101.com)" Gives the following result: URL4=escape(http://www.ASP101.com) Which is the correct result apart from the ?escape' actually appearing. Any ideas how to get around this? Tag: Paging in ASP BEST APPROACH Tag: 265566
  - 4
    - escape in ASP When chucking data in a cookie you cannot use certain characters (in this example ? : ? ). To get around this you use escape and unescape. Trying to use the escape as such: Response.Cookies("Lines")("URL4") = escape("http://www.ASP101.com") Gives the following result: URL4=http%3A//www.ASP101.com Which I don't think does anything to help. So using it like this: Response.Cookies("Lines")("URL4") = "escape(http://www.ASP101.com)" Gives the following result: URL4=escape(http://www.ASP101.com) Which is the correct result apart from the ?escape' actually appearing. Any ideas how to get around this? Tag: Paging in ASP BEST APPROACH Tag: 265565
  - 5
    - ASP/Access DB I have a small company creating a small site. Until it gets big, they switch to an MSSQL database hosted on a full-t1 site, and all that jazz they've got lowly ol' me working it into an Access database. I'm logging all the code with a logging function I created. The log function writes a row to the database each time I call the function with something like, "User logged into the web site". I came to the stark realization that each time a user loads my page they hit the database with an SQL query at least 40 times. That seems like a lot. It seems unecessary given the simplicity of the site. I realized a lot of my data is static. So I thought, "why do i need to hit the database and pull this data constantly if it will rarely change?" What methods are people using to mitigate database hits? Can a simple array be stored into a global ASP variable that all the sessions could access? XML (but I don't really know it well yet)? I'm looking for advice, thanks! Tag: Paging in ASP BEST APPROACH Tag: 265556
  - 6
    - most valuable professional. Where can I find information about "most valuable professional"? How do you get the MVP title?? I've heard that it's a pretty lucerative title ;) Tag: Paging in ASP BEST APPROACH Tag: 265554
  - 7
    - trimming a variable. I need to trim a variable to have everything after 4 chars in a string. IE: var_temp = 200:16:1234567890 i want everything after 200: to be a variable. I cannot use: var_new = right(var_temp,14) because the string is a different length everytime. I just dont know this function. please help :D Mario C *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Paging in ASP BEST APPROACH Tag: 265541
  - 8
    - sort data from a table by count value's? Is it possible so sort data from a table based on the count results? I have the following <% set rs = db.execute("Select * from tbleventinfo order by ename") while not rs.EOF tmp = rs("eid") set rs1 = db.execute("Select count(eid) from tbleventdj where eid = " & tmp) if rs1.EOF = false then total = rs1.fields.item(0) else total = 0 end if set rs1 = Nothing echo rs("ename") & "(" & total & ")" rs.moveNext if rs.EOF = false then Response.write "<br>" wend set rs = Nothing %> which works fine. but as you can see it sorts it all out bases on the ename... Any help apriciated!! Willem-Jan Selen Tag: Paging in ASP BEST APPROACH Tag: 265536
  - 9
    - Session Variables Persist Across Window Close on Mac IE 4.5 and Greater I've noticed that session variables will persist on Mac IE even after all browser windows have been closed. One must quit the program to clear the session variables. This presents a security risk for my session variable based security scheme. Basically, the risk is that a user will login to my site, close the window when done and allow someone else to come up to the machine, go back to my site and be logged into the previous user's account. Anyone know how to make session variables disappear when a window closes? Any other ideas? Am I going to have to redesign my whole security scheme? Any suggestions are appreciated. Dave Tag: Paging in ASP BEST APPROACH Tag: 265525
  - 10
    - Variable in the field name. Hi All, I have one question. Usually, we can get data from table by using rst("userid") because we know the column name userid. Now, I have a variable to hold the column name. I want to get data value like this rst(var1). However, I got an error message. Thanks. my Tag: Paging in ASP BEST APPROACH Tag: 265523
  - 11
    - Change Password Error Hello, Exchange 5.5 SP4 on W2K SP3. When in OWA, go to Options->Change Password, i's returning an error when you submit. I fill in the info for Domain, Account, old, new and confirm passwords and it says "Error number: -2147023569 ". Then there's a link that says 'Back' so that you can try again. Anyone seen this error before? A search on Google and KB's returned nothing... Thanks in advance, Tony Tag: Paging in ASP BEST APPROACH Tag: 265514
  - 12
    - 2 global.asp questions 1. how to determine the 'progid' parameter in the /oject tag for both session and application tags, eg, <object runat="server" scope="application" id="web1" progid="web1"> </object> 2. i want to invoke the meta data for ado in my global.asa, so it will there for all the sessions:  is this then coded within the application 'object' tags, see 1, or is it coded in the application_onstart subroutine?? Tag: Paging in ASP BEST APPROACH Tag: 265508
  - 13
    - How can u connect to 1 of several dbs based on selection user makes when accessing main page We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix). There is 1 user ID to oracle(APT_W3) that is used by all users (50). We have a global.asa file that has one APP Start connection string using OLE DB: Application("dbConnString")="Provider=MSDAORA.1;Password='SDERSD';User ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB services=-1" The first page that a user sees asks that they select the area they want to see (western, northern, etc) from a dropdown menu. Once they select it and hit save they can go to other pages, session varibles indicating what area they selected are then passed to pages. Currently all areas are in one database. What we want to do is have areas in separate dbs, a northern one, a western one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc). We want the users to have the web page presented to them where they select an area. Based on the area they select, the appropriate conneciton string will be used (the one in the global asa). Is there a way to have that in the global asa? Maybe as a session Session_OnStart? Based on the selection they made on the web page, they will be using one of several connection strings so we can have connection pooling Tag: Paging in ASP BEST APPROACH Tag: 265488
  - 14
    - problems width select line This is a multi-part message in MIME format. ------=_NextPart_000_003C_01C34FC1.EE9CC600 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! I am having some problems width a little script i downloaded... I'm not able to figure out what he SELECT line does! What does the @@identity mean? Is this maby a javascript? :) function GetLastIdentity(ADOConnection) { var rstIdentity =3D Server.CreateObject("ADODB.Recordset"); rstIdentity.Open("SELECT @@identity AS IdentityId", ADOConnection); var iIdentity =3D rstIdentity.EOF =3D=3D false ? = rstIdentity("IdentityId").value : -1; rstIdentity.Close(); return iIdentity; } ------=_NextPart_000_003C_01C34FC1.EE9CC600 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am having some problems width a = little script i=20 downloaded...</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm not able to figure out what he = SELECT line=20 does!</FONT></DIV> <DIV><FONT face=3DArial size=3D2>What does the @@identity = mean?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Is this maby a javascript? = :)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>function=20 GetLastIdentity(ADOConnection)<BR>{<BR> var rstIdentity =3D=20 Server.CreateObject("ADODB.Recordset");<BR><STRONG> <FONT=20 color=3D#ff0000>rstIdentity.Open("SELECT @@identity AS IdentityId",=20 ADOConnection);</FONT></STRONG><BR> var iIdentity =3D = rstIdentity.EOF =3D=3D=20 false ? rstIdentity("IdentityId").value :=20 -1;<BR> rstIdentity.Close();<BR> return=20 iIdentity;<BR>}</FONT></DIV></BODY></HTML> ------=_NextPart_000_003C_01C34FC1.EE9CC600-- Tag: Paging in ASP BEST APPROACH Tag: 265486
  - 15
    - Error Too few parameteres expect 1 Works fine. Recid = rs("id") SQLstmt = "SELECT * FROM courses WHERE ID=" & Request.QueryString("Recid") When i combine two tables SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name, Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM tblAuthor INNER JOIN Courses ON tblAuthor.employee_code = Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid") i get Too few parameteres expect 1 is it a syntax error? Tag: Paging in ASP BEST APPROACH Tag: 265485
  - 16
    - Web Bulletin for ASP 1.0 Released. Sunwest Technologies is pleased to announce the availability of Web Bulletin for ASP, a server-side component for easy creation of bulletin board in a web browser. The bulletin board can be used to display news, events and messages. * The messages can be specified by an XML file or through COM interface * Fading and scrolling effects are provided * All major browsers are supported * Can be used FREELY For more information on Web Bulletion, please visit http://www.SunwestTek.com/wb Sincerely, Sunwest Technologies, http://www.SunwestTek.com Tag: Paging in ASP BEST APPROACH Tag: 265480
  - 17
    - POS Cash Drawer with Internet Explorer? Hi, I'm getting tasked with writing an ASP application deployed throughout the company's intranet where all the workstations will be running Internet Explorer 6.0. It's a retail business, and some of the workstations are Point-Of-Sale and will need to have cash drawers and bar-code scanners. The project managers want this as a web-application because of the ease of deployment and updates to the other stores. The problem is, I don't know how to activate the cash drawers from within IE. Is there any kind of ActiveX control which can be plugged into IE to allow control over the cash drawer from within IE? We don't have the cash drawers purchased yet, and are waiting to find out if anyone makes an ActiveX plug-in control and cash drawer which will work from IE. Suggestions and recommendations would be greatly appreciated. Thanks, Scott Tag: Paging in ASP BEST APPROACH Tag: 265478
  - 18
    - ASP.NET on a DomainController I'm developing an ASP.NET app that uses ActiveDirectory. To demo this, I've built a notebook as a Win2000 DomainController with IIS. To my pleasant surprise this actually worked - at least until I patched it the other night. Now I get nothing but security violations (access denied), with no usefull indication as to what security I've violated. I'm using 'impersonate' mode and I'm logged in as the admin of the only Domain. I can get this working with .NET 1.0 and an un-patched DC, but I need to upgrade it to .NET 1.1 which requires patches that will introduce the security problems. I've tried modifying the Machine.Config to use 'SYSTEM' rather than 'machine' as the processed, this didn't do it. Does anybody have a hint on what security settings need to be tweeked to get this to work? Thanks, Randy Tag: Paging in ASP BEST APPROACH Tag: 265457
  - 19
    - is there anyone from microsoft IIS group, please! Hi i am searching for anyone from IIS /ASP team.please contact me or lave me a message here or email me. Regards Bogomil Tag: Paging in ASP BEST APPROACH Tag: 265446
  - 20
    - Help converting short php script to ASP I've got this PHP script working on one of my sites and now need an ASP version for my intranet. I don't know ASP, can anyone help out? Know of anyway to NOT have a blank browser window open when clicking on the link or even a better solution to prevent spam harvesters? <? // email.php // usage: // // <A HREF="email.php?to=me&domain=mydomain.com">E-Mail Me</a>--> // // if (!isset($to)) //if(!isset($_GET['to'])) { // $_GET['to'] = "info"; $to = "info"; } if(!isset($domain)) { //$_GET['domain'] = "mydomain.com"; $domain = "mydomain.com"; } // $to = $_GET['to']; // $domain = $_GET['domain']; $email_address = $to."@".$domain; // send email header to page header ("Location: mailto:$email_address"); ?> Tag: Paging in ASP BEST APPROACH Tag: 265445
  - 21
    - Number format problems with SUM and AVG Hie everybody, I have a problem with the following, I have a table with a row containing numbers with 2 decimal places. I want to count the sum of these numbers but my valuw returned is far to high. I think the SUM string doesn't look at the decimal place. The same is with the AVG string Here are the ones I tried : set rs = db.execute("Select SUM(ePrize) from tbleventinfo") if rs.EOF = false then aveprize = Formatnumber(rs.fields.item(0),2) else aveprize = 0 end if set rs = Nothing and set rs = db.execute("Select AVG(ePrize) from tbleventinfo") if rs.EOF = false then aveprize = Formatnumber(rs.fields.item(0),2) else aveprize = 0 end if set rs = Nothing Can anybody help me allong the way?! Thanks in advance, Willem-Jan Selen Tag: Paging in ASP BEST APPROACH Tag: 265408
  - 22
    - Auto refresh asp Hi All, I want to refresh a page every 5 mins without the users' intervention. I'm not sure that this is possible at all. Do you? Thanks in advance. Abe. Tag: Paging in ASP BEST APPROACH Tag: 265382
  - 23
    - How to display in any lanaguae hi, Guys..... I am Making A website....in asp Now my data is stored in Sql Server.... What i want is to display the Data as per Languaue the user selects.. The data stored in sql server is english if the user selects French in asp site the data from the backend should be displayed in FRench... or based on ip address and location automatically the Data....sholud be Displayed according to The REgional...settings.. ie guy logging on from japan sholud see data in japanense.. can this be done or what? Please help me out... regds, Navin Mahindroo Tag: Paging in ASP BEST APPROACH Tag: 265370
  - 24
    - problem with creating a database in win xp hallo i have to do a code in ASP that including this code: set c=server.createobject("adodb.connection") c.open "dsn=MyDSN;" c.execute "create table first_tables(Name char, Tel char)" and i am geting that error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E09) [Microsoft][ODBC Text Driver] Cannot modify the design of table 'first_tables'. It is in a read-only database. /1.asp, line 4 what can i do? thanks zeev j Tag: Paging in ASP BEST APPROACH Tag: 265366
  - 25
    - ASP class-session variable Hiya - Big puzzler for me. Code Below I create a class. I save it to a session variable. Then, I retrieve the session variable back into a new local variable. I am able to use a method which prints the name "Joey." Works great. But if I retrieve the same session variable into a local variable from a different page, I cannot use the method. It fails. Even though the session variable is an object, and the local variable is an object! Why? How can I get to this class from the second page? thanks <% dim oTest set oTest= new clsEmployee oTest.EmployeeName="Joey" set session("sessionTest")= oTest set oTest= nothing 'This section works fine------------------------------ 'But not from another page! dim oNewTest set oNewTest = session("sessionTest") Response.Write "<br>Is oNewTest an object? " & isObject(oNewTest) Response.Write "<Br>" Onewtest.PrintEmployeeName --------------------------------------- Class clsEmployee Private m_strEmployeeName Public Property Get EmployeeName EmployeeName = m_strEmployeeName End Property Public Property Let EmployeeName (strEmployeeName) m_strEmployeeName = strEmployeeName End Property Sub PrintEmployeeName Response.Write EmployeeName End Sub End Class %> Tag: Paging in ASP BEST APPROACH Tag: 265358

HI,
Guys
There has been a lot of Ways to use paging in asp

1>Recordset approach -where whole records are pulled at client side...
and then only the records which are needed are filtered..
and now that is not the approach good as we are pulling unnesscary all
the 10,000 say for dispalying 100 records...if pagesize is 100

2>i have seen is the Stored procedure approach where data is inserted
in temp table and then only the records needed are pulled out...
now again the approcah is not feasbile as if the data in the table is
huge
then inserting in temp table is going to bring Troubles...

so both the approcaches are bottlenecks...
so brillant guys..... which the best approcah to implement paging in
asp...
i have seen google paging seems to be runing very fast?

so tell me which the best approcah to implement paging in asp

regds,
Navin Mahindroo

Top

Re: Paging in ASP BEST APPROACH by Randy

Randy
Wed Jul 23 07:25:29 CDT 2003

> so tell me which the best approcah to implement paging in asp

Here's a good article on recordset paging...
http://www.aspfaq.com/show.asp?id=2120

RR

Top

Re: Paging in ASP BEST APPROACH by Aaron

Aaron
Wed Jul 23 07:55:08 CDT 2003

Please don't multi-post; I answered this in another group.

Top