#16
  1. Senior Water Wizard
    ASP Mastermind (5000+ posts)

    Join Date
    Aug 2004
    Location
    Cape Town, RSA
    Posts
    10,233
    Rep Power
    863
    Yup, thanx Bslintx and to Phoenix who started the debate
    Look! Its a ShemZilla


  2. #17
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Apr 2004
    Location
    United States
    Posts
    1,814
    Rep Power
    17
    Originally Posted by Shadow Wizard
    well done - I've added link to the previous part so the chain won't be broken.

    thanks shadow, i checked i saw the link...i must have re-linked while you caught it...hence the renaming...thanks for the points and trying to fix the link...btw..by all means please go ahead and delete this post - to keep clean THANKS
    Please give respect to those that helped solve an issue by clicking on the icon
  4. #18
  5. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
  6. #19
  7. Beyond The Impossible
    ASP Adventurer (500 - 999 posts)

    Join Date
    Sep 2003
    Location
    Shawnee Mission, KS, USA
    Posts
    921
    Rep Power
    17

    Pure ASP Upload Classes


    Things You Should Know, Part #5

    A common question that gets asked on these forums is how to upload without installing a COM object, well it can be done and there are several solutions out there. In my opinion
    Upload Files Without COM v3.11 by Lewis Moten is the best one.

    This class not only supports Image uploads, but you specify file types. It also has progress bar support.

    My next favorite is Free ASP Upload, this class would be next in line, as its a quick and dirty solution.

    Next Part
    Last edited by freeasphelp; November 26th, 2005 at 05:33 PM.
    John Shepard
    Beyond The Impossible
    -----------------------------
    Has a post helped you? Please show your apprecitation by clicking the
    image in the right upper corner.
    Posting code? Put your code between [code] and [/code] tags.
    X-Login and X-Send
  8. #20
  9. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Originally Posted by freeasphelp
    A common question that gets asked on these forums is how to upload without installing a COM object, well it can be done and there are several solutions out there. In my opinion
    Upload Files Without COM v3.0 by Lewis Moten is the best one.

    This class not only supports Image uploads, but you specify file types. It also has progress bar support.

    My next favorite is Free ASP Upload, this class would be next in line, as its a quick and dirty solution.
    very nice John, I've added this to the chain as well. gave you points in the original thread where you posted it.
  10. #21
  11. Beyond The Impossible
    ASP Adventurer (500 - 999 posts)

    Join Date
    Sep 2003
    Location
    Shawnee Mission, KS, USA
    Posts
    921
    Rep Power
    17

    Use OLE DB!!!


    Things You Should Know, Part #6

    Another common question on these forums is why ODBC is generating errors, usally the reason is that ODBC has become unstable or its a permission issue.

    Microsoft and most ASP experts recommend using OLE DB, instead of ODBC. Microsoft claims that it is unstable running on IIS. OLE DB is the better choice anyway and you can do everything you can with ODBC, and even more:

    Microsoft Access OLE DB connection string:
    Code:
    strCnn = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Server.MapPath("/db/database.mdb") & ";"
    Next Part
    Last edited by Shadow Wizard; July 15th, 2005 at 06:38 AM. Reason: added next part
  12. #22
  13. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Apr 2004
    Location
    United States
    Posts
    1,814
    Rep Power
    17

    Alternatives to asp recordcount method


    Things You Should Know Part 7

    http://www.adopenstatic.com/faq/reco...ternatives.asp



    The use of .RecordCount involves the creation of Recordsets using relatively expensive cursors (click here for details). There are a number of alternative methods that can be used. Listed in the link are three preferred methods, and two methods that aren't.

    Next Part

    Comments on this post

    • Shadow Wizard agrees : nice link. :)
    Last edited by Shadow Wizard; July 23rd, 2005 at 04:16 PM. Reason: added next part. :)
  14. #23
  15. Beyond The Impossible
    ASP Adventurer (500 - 999 posts)

    Join Date
    Sep 2003
    Location
    Shawnee Mission, KS, USA
    Posts
    921
    Rep Power
    17

    ASP Classic and CAPTCHA


    Things You Should Know, Part #8

    Ever want to add CAPTCHA to your logins or forms. Well you can with this cool ASP Classic function. It uses HTML, CSS and some JavaScript to produce a pretty good CAPTCHA. It does have some areas for improvement, for example it uses Sessions now. Also some of the questions it ask wouldn't work for someone who suffers colorblindness, but its free code and can be modified as long as the modified version is shared.

    A CAPTCHA Solution Built With Classic ASP, CSS And Javascript.

    Next Part

    Comments on this post

    • elijathegold agrees : Nice Link
    Last edited by freeasphelp; July 20th, 2005 at 06:43 AM.
  16. #24
  17. Beyond The Impossible
    ASP Adventurer (500 - 999 posts)

    Join Date
    Sep 2003
    Location
    Shawnee Mission, KS, USA
    Posts
    921
    Rep Power
    17

    Recordset Paging the fast scalable way.


    Things You Should Know, Part #9

    Another common question that gets asked on this forum is how to Page a Recordset. Paging a recordset is really not that difficult, and doing it the fast and scalable way will improve your site's performance.

    The best way to page a recordset is the GetRows or GetString method of the ADODB.Recordset. GetString is the better of the two, but much harder to work with.

    Paging Records with GetRows

    Next Part
    Last edited by Shadow Wizard; July 23rd, 2005 at 04:26 PM. Reason: added next part. :)
  18. #25
  19. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    Things You Should Know, Part #10

    Using Access Database, the mdb file and its folder must have Read/Write/Execute permission set for the IUSR account in order that you will be able to Insert/Update/Delete data in the database. without such permissions, you're likely to get such error:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
    How to do that? simple.
    1. double click My Computer in the web server and browse the the folder containing the mdb file.
    2. right click the folder, choose properties.
    3. go to the Security tab. if no such tab exist, go to Tools --> Folder Options and make sure to disable the "simple sharing" option.
    4. in the Security tab, click Add
    5. choose the account used by IIS - by default it would be IUSR_<machine name> but it may also be different. you can check this via the MMC panel.
    6. Add the account and grant it full permissions. confirm.
    7. repeat it for the mdb file itself.

    The above was tested only under Win2K platform, it may be different for XP machine, I would like to get feedback whether it's working or not for such platform and fix this post if needed.
  20. #26
  21. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Apr 2004
    Location
    United States
    Posts
    1,814
    Rep Power
    17

    Using Response.Clear()


    Things You Should Know, Part #11

    Before executing a Response.Redirect() you should use a Response.Clear() to remove the possibility of errors on the client's end


    courtesy of ::shamrog12::

    http://forums.aspfree.com/t71719/s.html
    Last edited by bslintx; August 1st, 2005 at 10:27 AM.
  22. #27
  23. Beyond The Impossible
    ASP Adventurer (500 - 999 posts)

    Join Date
    Sep 2003
    Location
    Shawnee Mission, KS, USA
    Posts
    921
    Rep Power
    17

    Disable Mozilla (Gecko) from caching pages


    Things You Should Know, Part #12

    There is a common question among developers, that usally involves the browser's back button and cache. A common mistake among developers is to use the following:
    Code:
    <%
    	Response.Expires = 60
    	Response.Expiresabsolute = Now() - 1
    	Response.AddHeader "pragma","no-cache"
    	Response.AddHeader "cache-control","private"
    	Response.CacheControl = "no-cache"
    %>
    The main reason for this is cause there is some confusion as to what no-cache means. IE interperates this as to not cache, however Mozilla (Gecko) browsers interperates this header as they should. Instead developers should use only two or three of these headers.
    Code:
    	Response.AddHeader "Pragma","no-store"
    	Response.CacheControl = "no-store"
    	Response.Expires = -1
    This will prevent Mozilla (Geko) based browser from caching pages, thus disabling the back button.

    Next Part
    Last edited by freeasphelp; August 30th, 2005 at 01:23 AM.
  24. #28
  25. Bug Catching Moderator
    ASP High Scholar (3500 - 3999 posts)

    Join Date
    Sep 2004
    Location
    Australia
    Posts
    3,572
    Rep Power
    121
    Things You Should Know, Part #13

    There's often debate about which words are reserved when writing database query statements. The following link provides a concise summary of reserved words across the different database drivers.
    http://www.aspfaq.com/show.asp?id=2080

    Next Part
    Last edited by Shadow Wizard; October 10th, 2005 at 04:28 AM. Reason: added next part...
    Have I made your day? If so, please show your appreciation either by sending money or the cheaper, preferred option of clicking on the scales icon at the top right of this posting. My reputation needs all the help it can get.
  26. #29
  27. Beyond The Impossible
    ASP Adventurer (500 - 999 posts)

    Join Date
    Sep 2003
    Location
    Shawnee Mission, KS, USA
    Posts
    921
    Rep Power
    17

    ASP Classic: Hashes


    Things You Should Know, Part #14

    There are two common methods of hashing strings, the most common is MD5, while the more secure method is SHA1. Hashing is commonly used to store passwords in a database "securely". While VBScript and JavaScript do not inclue these functions, there are many examples out on the net. I have taken my favorite one for both SHA1 and MD5 and created a simple example in the Code Bank section:

    MD5 Example
    SHA1 Example

    Next Part
    Last edited by freeasphelp; October 10th, 2005 at 02:09 AM.
  28. #30
  29. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Mar 2006
    Posts
    31
    Rep Power
    13
    It should be noted that enabling Parent Paths creates a potentially damaging security problem. Unless you are the only one writing ASP code on your server, or you know you can trust everyone who writes ASP code on your server, they should be disabled.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;332117

Similar Threads

  1. Different way of doing things
    By sam_sam in forum ASP Development
    Replies: 1
    Last Post: April 7th, 2005, 06:15 PM
  2. Need help on some things.
    By Borgis1 in forum Code Bank
    Replies: 46
    Last Post: February 17th, 2005, 02:16 AM
  3. Replies: 3
    Last Post: December 28th, 2003, 11:48 PM
  4. Need HELP! Trying to limit data in a chart among other things
    By electrobirdy in forum Microsoft Access Help
    Replies: 1
    Last Post: November 16th, 2003, 10:11 PM
  5. weird things with Redirect
    By Steve Schofield in forum ASP Development
    Replies: 2
    Last Post: November 9th, 2000, 03:56 AM

IMN logo majestic logo threadwatch logo seochat tools logo