Page 2 - Things You Should Know

Yup, thanx Bslintx and to Phoenix who started the debate

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

nah.... there is links chain starting here:
http://forums.aspfree.com/showpost....174&postcount=1
no need to clean anything.

Thank You for the post. I didn't know that. From now on there will be no underscore in the names of the servers.


http://www.cyanyz.com

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

very nice John, I've added this to the chain as well. gave you points in the original thread where you posted it.

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:
Next Part

Things You Should Know Part 7

http://www.adopenstatic.com/faq/rec...lternatives.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

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

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

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:


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.

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

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: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.This will prevent Mozilla (Geko) based browser from caching pages, thus disabling the back button.

Next Part

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

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