Your full service technology partner! 
Highlights Updated Posts Unanswered Posts Online Today Who's Reading What Member Birthdays!

HighLights (ASP Classic Group)

Switch to New Group Posts By Type view.

New: ASP Classic Group Members

1. Yesid.B  (17 visits., -- --) 2. Craig.D  (2 visits., -- --) 3. Terry.M  (7 visits. Sacramento, -- --) 4. David.F  (13 visits., -- --) 5. Krishnendu  (3 visits., -- IN) 6. Gary Rust  (3 visits. Rocklin, CA USA) 7. Mamacita  (646 visits. CA ) 8. Hazwa.a  (2 visits., -- UNK) 9. Rodney.N  (4 visits. West Hills, CA USA) 10. Acropolis  (34 visits. San Diego, CA USA)

New ASP Classic Posts: All Types

New?   Title Created By For...
None. No highlights in last 90 days.
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).

New: ASP Classic Message Board Posts

Go To: ASP Classic Message Board

Thread 5 of 5
Thread Starter  

ODBC Join tables
I am attempting to join two tables through an 'INDEX' field like so: SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, , w."INDEX", w.QUAR FROM wrhse AS w, items AS s , WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX" However I am not getting a result. Initially I was using the following: sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc' to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables? Thank you in advance.
Posted to MB Topic: ASP Classic - Handling Data
6 years ago
10 replies. Last post:

If you need a limousine for an important occasion, such as a wedding or a client visit, you need to ensure that your service provider lives up to the expectations of the occasion.
49 months ago
Nothing New Since Your Last Visit

Thread 4 of 5
Thread Starter  

{Too Long!}
Posted to MB Topic: ASP Classic Coding
50 months ago
Nothing New Since Your Last Visit

Thread 3 of 5
Thread Starter  

Coding ASP Classic on Linux
Hello all, First, I should let you know that I am not an experienced ASP coder and, honestly, don't have lots of experience with Microsoft products.  I've been using Unix for more than 20 years and Linux for about 10 years.  Most of my programming experience is with Perl and Python. I just landed a new client that needs some code work on their current online training that they offer.  It's written in ASP Classic and running on a Postgresql back-end.  I don't have experience with ASP Classic but can pick-up on the language relatively quickly (I think).  I will do the work on a Windows XP box if I have to but would prefer to do the coding one of my Linux boxes, if possible.  Does anyone know if this is even possible? Thanks for your help.
16 years ago
Nothing New Since Your Last Visit

Thread 2 of 5
Thread Starter  

Kill Session(s) from Application
Hi there. I need to clear groups of sessions to force-logout groups of users. Can I get a collection of sessions at Application level and abandon them from there? Any help much appreciated, thank you! Craig.
Posted to MB Topic: ASP Classic Coding
10 years ago
Nothing New Since Your Last Visit

Thread 1 of 5
Thread Starter  

Bryan Valencia
ASP Classic Suddenly fails
{Too Long!}
Posted to MB Topic: ASP Classic - Handling Data
14 years ago
2 replies. Last post:

Actually, after much anguish, I found that the latest MS patch had inadvertently changed my site from Low(iis) to Medium(Pooled) Setting it back did the trick. asp classic sites dont work on medium
14 years ago
Nothing New Since Your Last Visit

New: ASP Classic Knowledge Base Posts

Go To: ASP Classic Knowledge Base
  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
14 years ago
(3 Comments , last by petter.s )

Nothing New Since Your Last Visit

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
14 years ago
(7 Comments , last by Natalie.Z )

Nothing New Since Your Last Visit

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
14 years ago, and updated 13 years ago
(2 Comments , last by Jeorge.W )


KB Post
Nothing New Since Your Last Visit  

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
14 years ago

Nothing New Since Your Last Visit

New: To/From Code

Go To: ASP Classic To/From Guides

Code Snippets

  Code Snippet Created
1. Array 3/20/2010
2. Sort Records 2/8/2010
3. Filter Records 2/7/2010
4. Find Record 2/7/2010
5. Edit Record 2/7/2010
6. Record Movement 2/7/2010
7. Comments 1/1/2009
8. End of Statement 1/1/2009
9. Case Sensitivity 1/1/2009
10. Literals 1/1/2009


  Topic Category Created
1. Array Data Structures 3/20/2010
2. Sort Records Database 2/8/2010
3. Filter Records Database 2/7/2010
4. Find Record Database 2/7/2010
5. Edit Record Database 2/7/2010
6. Record Movement Database 2/7/2010
7. Comments Language Basics 1/1/2009
8. Left of String Commands 1/1/2009
9. Prevent Derivation OOP Details 1/1/2009
10. Abstraction OOP Details 1/1/2009

New: eCertified Study Questions

Go To: eCertified
Question Level Type Based on KB Post KB Topic
Are arrays in ASP Classic zero-based? 2 YN {Too Long!} ASP Classic
{Too Long!} 3 MC {Too Long!} OOP
{Too Long!} 3 MC {Too Long!} OOP
{Too Long!} 2 TF {Too Long!} ASP Classic
{Too Long!} 1 MC {Too Long!} ASP Classic
Dim s,  s = Null If Len(s) = 0 Then,   Response.Write("Hello, World!")End If%>, </body></html>">{Too Long!} 3 MC {Too Long!} ASP Classic
{Too Long!} 2 YN {Too Long!} Language Basics
{Too Long!} 1 TF {Too Long!} Language Basics
{Too Long!} 2 MC {Too Long!} ASP Classic
{Too Long!} 2 YN {Too Long!} Language Basics

Switch group?

Prestwood IT:
  • Client HighLights
  • Prestwood IT HighLights
  • Sales Website: Or visit our legacy sales site:

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