- Classic ASP file upload limit of 200kb in IIS 7L
- Find Column with Lower Case Text
- 0x8007232B DNS Name Does Not Exist Error on Windows Activation
- How to update a column with incrementing numbers
- How to get top N rows for each group?
- How to put a column into a delimited form
- How to export results of a stored procedure to a txt file
- Parsing delimited words from a column
- How to get N-th max value
- How to get a random row from a table
Dreaded Single Quote Problem
One of the biggest problems new ASP developers have is with single quotes (I know I did). When a user enters a name like "O'Neal" and then you try to write it to the database you'll get an error. It's not as hard as you might think it is. When 2 single quotes are entered SQL accepts them as 1 quote. There are two easy ways to go about it...
USE A FUNCTION
If InStr(var, "'") <> 0 Then
var = Replace(var, "'", "''")
SQLQuote = var
Then use is like this: SqlQuote(txtPubTitle)
txtPubTitle = replace(Request.Form("txtPubTitle"),"'","''")
note: If you're using Stored Procedures you won't have to worry about this.
Source: Chuck Dearbeck