IT SOLUTIONS
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

View:
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  

Yesid.B
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
7 years ago
10 replies. Last post:

amna.s
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.  https://alternativestips.com/alternatives-of-putlocker
58 months ago
Nothing New Since Your Last Visit
1637
Hits

Thread 4 of 5
Thread Starter  

PS_2709
http://www.cbsnews.icu/
{Too Long!}
Posted to MB Topic: ASP Classic Coding
59 months ago
Nothing New Since Your Last Visit
361
Hits

Thread 3 of 5
Thread Starter  

cmccullough
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.
17 years ago
Nothing New Since Your Last Visit
11854
Hits

Thread 2 of 5
Thread Starter  

Craig.D
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
11 years ago
Nothing New Since Your Last Visit
2881
Hits

Thread 1 of 5
Thread Starter  

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

Bryan.V
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
15 years ago
Nothing New Since Your Last Visit
11423
Hits
More...

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

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

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

Code

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

Code
Nothing New Since Your Last Visit
20510
Hits
More...

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

Topics

  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: www.prestwood.com Or visit our legacy sales site: 
    legacy.prestwood.com


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