ASP Classic Coding New and Updated KB Posts

Page Contents


Recently Created

(ASP Classic Coding Group)

  KB Article  

Mike Prestwood
1. ASP Classic Error 3709

Run-time error '3709':
Operation is not allowed on an object referencing a closed or invalid connection.

Posted to KB Topic: Language Details
7/11/2010

Error
Nothing New Since Your Last Visit
13542
Hits

Mike Prestwood
2. ASP Classic Yes/No Function

The following function demonstrates one technique for coding a Yes/No dropdown. It uses a for loop which can be expanded to handle more than the 3 states (Y, N, and blank).

Example of calling the function:

Do you fish? <%=YesNoDropDown("ynFish", "")%>
Posted to KB Topic: ASP Classic
6/15/2010

Code
Nothing New Since Your Last Visit
7954
Hits

Mike Prestwood
3. ASP Classic Array (x = Array())

Arrays in ASP Classic use a 0-based indice.

Use UBound to get the number of elements. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: ASP Classic
3/20/2010, and updated 3/7/2011

Code

KB Post
Nothing New Since Your Last Visit  
15242
Hits

Mike Prestwood
4. ASP Classic Edit Record (AddNew, Update, Delete)

In ASP, using ADO, you use RecordSet.AddNew to add a new record, Recordset.Update to post the record, and RecordSet.Delete to delete it. To edit a record, you open the RecordSet using an editable cursor.

Posted to KB Topic: ASP Classic
3/1/2010

Code
Nothing New Since Your Last Visit
18649
Hits

Mike Prestwood
5. ASP Classic Sort Records (Sort)

In ASP, using ADO, you sort a set of records using the Sort property.

Posted to KB Topic: ASP Classic
2/8/2010

Code
Nothing New Since Your Last Visit
7579
Hits

Mike Prestwood
6. ASP Classic Filter Records (Filter)

In ASP, using ADO, you filter a set of records using Filter.

Posted to KB Topic: ASP Classic
2/8/2010

Code
Nothing New Since Your Last Visit
7958
Hits

Mike Prestwood
7. ASP Classic Find Record (Find, Seek)

In ASP, using ADO, you use Find and Seek to move a cursor of a RecordSet to a matching record.

Posted to KB Topic: ASP Classic
2/7/2010

Code
Nothing New Since Your Last Visit
7198
Hits

Mike Prestwood
8. ASP Classic Record Movement (MoveFirst, MoveLast, MoveNext)

ASP uses MoveFirst, MoveLast, MoveNext, and MovePrevious to move a database cursor (a RecordSet).

objRecordSet.MoveNext
Posted to KB Topic: ASP Classic
2/7/2010

Code
Nothing New Since Your Last Visit
17444
Hits

Mike Prestwood
9. ASP Classic Empty String Check (Len(s&vbNullString))

In ASP Classic, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted to KB Topic: ASP Classic
9/17/2009, and updated 9/21/2010

Code

Article
Nothing New Since Your Last Visit  
44625
Hits

Mike Prestwood
10. ASP Classic Member Visibility (Private, Public)

The member visibility modifiers are Private and Public. If not specified, the default is Public. Private and Public have the usual meaning. Private members are visible only within the class block. Public members are visible within the class and outside of the class.

Posted to KB Topic: OOP
3/11/2009

Code

Article
Nothing New Since Your Last Visit
17479
Hits




Recently Updated

(ASP Classic Coding Group)

  KB Article  

Mike Prestwood
1. ASP Classic Array (x = Array())

Arrays in ASP Classic use a 0-based indice.

Use UBound to get the number of elements. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: ASP Classic
3/20/2010, and updated 3/7/2011

Code

KB Post
Nothing New Since Your Last Visit  
15242
Hits

Mike Prestwood
2. Associative Arrays in ASP Classic

What is the syntax in ASP Classic for using an associative array?

Posted to KB Topic: Language Details
6/18/2008, and updated 11/5/2010

FAQ
Nothing New Since Your Last Visit
28566
Hits

Mike Prestwood
3. ASP Classic Empty String Check (Len(s&vbNullString))

In ASP Classic, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted to KB Topic: ASP Classic
9/17/2009, and updated 9/21/2010

Code

Article
Nothing New Since Your Last Visit  
44625
Hits

Mike Prestwood
4. ASP Classic Error 3709

Run-time error '3709':
Operation is not allowed on an object referencing a closed or invalid connection.

Posted to KB Topic: Language Details
7/11/2010

Error
Nothing New Since Your Last Visit
13542
Hits

Mike Prestwood
5. ASP Classic Edit Record (AddNew, Update, Delete)

In ASP, using ADO, you use RecordSet.AddNew to add a new record, Recordset.Update to post the record, and RecordSet.Delete to delete it. To edit a record, you open the RecordSet using an editable cursor.

Posted to KB Topic: ASP Classic
3/1/2010

Code
Nothing New Since Your Last Visit
18649
Hits

Mike Prestwood
6. ASP Classic Yes/No Function

The following function demonstrates one technique for coding a Yes/No dropdown. It uses a for loop which can be expanded to handle more than the 3 states (Y, N, and blank).

Example of calling the function:

Do you fish? <%=YesNoDropDown("ynFish", "")%>
Posted to KB Topic: ASP Classic
6/15/2010

Code
Nothing New Since Your Last Visit
7954
Hits

Mike Prestwood
7. Clear Application and Session Variables Using ASP classic

Use Application.Contents.RemoveAll and Session.Contents.RemoveAll

Posted to KB Topic: Language Basics
2/16/2007, and updated 5/1/2010

KB Post
Nothing New Since Your Last Visit
35933
Hits

Mike Prestwood
8. Response.Flush and Response.Buffer

Response.Flush sends the contents of the buffer to the browser. This command is useful for showing a visitor something while slow loading pages load.

Posted to KB Topic: Language Details
12/19/2006, and updated 4/10/2010

KB Post
Nothing New Since Your Last Visit
39466
Hits

Mike Prestwood
9. ASP Classic Sort Records (Sort)

In ASP, using ADO, you sort a set of records using the Sort property.

Posted to KB Topic: ASP Classic
2/8/2010

Code
Nothing New Since Your Last Visit
7579
Hits

Mike Prestwood
10. ASP Classic Filter Records (Filter)

In ASP, using ADO, you filter a set of records using Filter.

Posted to KB Topic: ASP Classic
2/8/2010

Code
Nothing New Since Your Last Visit
7958
Hits
Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).
www.prestwood.com For service: 916-726-5675
or support@prestwood.com
Copyright (C) Prestwood IT Solutions.
All Rights Reserved.
Printed 9/29/2020