I.T. Discussion Community!
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  (6 visits., -- --) 2. Craig.D  (2 visits., -- --) 3. Terry.M  (7 visits. Sacramento, -- --) 4. David.F  (12 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:
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).

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 months ago
3 replies. Last post:

saifullah.s
{Too Long!}
87 days ago
Nothing New Since Your Last Visit
307
Hits

Thread 4 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.
10 years ago
Nothing New Since Your Last Visit
10400
Hits

Thread 3 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
50 months ago
Nothing New Since Your Last Visit
2292
Hits

Thread 2 of 5
Thread Starter  

Bryan Valencia
ASP Classic Suddenly fails
{Too Long!}
Posted to MB Topic: ASP Classic - Handling Data
8 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
8 years ago
Nothing New Since Your Last Visit
10518
Hits

Thread 1 of 5
Thread Starter  

khatib_b
Diplaying javascript error message from DB
{Too Long!}
Posted to MB Topic: ASP Classic - Handling Data
8 years ago
1 Reply:

dmichael
{Too Long!}
8 years ago
Nothing New Since Your Last Visit
4769
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
8 years ago
(2 Comments , last by haris.w )

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

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

Code

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

Code
Nothing New Since Your Last Visit
16807
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?

Water-Cooler:
  • AmericanIT HighLights
  • Industry HighLights
  • Linux HighLights
  • Owners HighLights
  • PrestwoodBoards HighLights
  • Windows HighLights
  • IT Professionals:
  • Analyst HighLights
  • Coder HighLights
  • DBA HighLights
  • Proj Man HighLights
  • Tech HighLights
  • Tech Writer HighLights
  • Tester HighLights
  • Desktop Databases:
  • Access HighLights
  • Paradox HighLights
  • V.FoxPro HighLights
  • Website Scripting:
  • ASP Classic HighLights
  • Design HighLights
  • JavaScript HighLights
  • Perl HighLights
  • PHP HighLights
  • General Dev Tools:
  • C# HighLights
  • C++ HighLights
  • Delphi HighLights
  • Java HighLights
  • Prism HighLights
  • VB Classic HighLights
  • VB.Net HighLights
  • -
       Contact Us!
     
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    3,763 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...


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