I.T. Discussion Community!
-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
9 years ago
(3 Comments , last by petter.s )

Error
Nothing New Since Your Last Visit
13197
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
9 years ago
(1 Comments , last by neil.j )

Code
Nothing New Since Your Last Visit
7644
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
9 years ago, and updated 8 years ago

Code

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

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

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

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

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

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

Code

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

Code

Article
Nothing New Since Your Last Visit
16683
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
9 years ago, and updated 8 years ago

Code

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

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

Code

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

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

Code
Nothing New Since Your Last Visit
18128
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
9 years ago
(1 Comments , last by neil.j )

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

KB Post
Nothing New Since Your Last Visit
35013
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
13 years ago, and updated 9 years ago
(4 Comments , last by Pervez.J )

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

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

Code
Nothing New Since Your Last Visit
7650
Hits
Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 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).

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech