IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► KB ►► Website Scri...ASP Classic   Print This    All Groups  

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
12 years ago
(3 Comments , last by petter.s )

Error
Nothing New Since Your Last Visit
14033
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
12 years ago
(7 Comments , last by Natalie.Z )

Code
Nothing New Since Your Last Visit
8466
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
12 years ago, and updated 11 years ago
(2 Comments , last by Jeorge.W )

Code

KB Post
Nothing New Since Your Last Visit  
16155
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
12 years ago

Code
Nothing New Since Your Last Visit
19328
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
12 years ago
(1 Comments , last by Levi.M )

Code
Nothing New Since Your Last Visit
8118
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
12 years ago

Code
Nothing New Since Your Last Visit
8434
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
12 years ago

Code
Nothing New Since Your Last Visit
7683
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
12 years ago
(3 Comments , last by fuzail.f )

Code
Nothing New Since Your Last Visit
18082
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
13 years ago, and updated 12 years ago
(4 Comments , last by Eugene.P )

Code

Article
Nothing New Since Your Last Visit  
46363
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
13 years ago

Code

Article
Nothing New Since Your Last Visit
18483
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
12 years ago, and updated 11 years ago
(2 Comments , last by Jeorge.W )

Code

KB Post
Nothing New Since Your Last Visit  
16155
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
14 years ago, and updated 12 years ago
(3 Comments , last by Donnavan.L )

FAQ
Nothing New Since Your Last Visit
29364
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
13 years ago, and updated 12 years ago
(4 Comments , last by Eugene.P )

Code

Article
Nothing New Since Your Last Visit  
46363
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
12 years ago
(3 Comments , last by petter.s )

Error
Nothing New Since Your Last Visit
14033
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
12 years ago

Code
Nothing New Since Your Last Visit
19328
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
12 years ago
(7 Comments , last by Natalie.Z )

Code
Nothing New Since Your Last Visit
8466
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
15 years ago, and updated 12 years ago
(1 Comments , last by Uwais.Q )

KB Post
Nothing New Since Your Last Visit
36841
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
16 years ago, and updated 12 years ago
(14 Comments , last by joe.e )

KB Post
Nothing New Since Your Last Visit
40052
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
12 years ago
(1 Comments , last by Levi.M )

Code
Nothing New Since Your Last Visit
8118
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
12 years ago

Code
Nothing New Since Your Last Visit
8434
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).
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]