ASP Classic

	ASP Classic Group Home
Get Started Page eMag: ASP Classic Highlights WEEKLYLESSON Week 11 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	ASP Classic KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles ASP Classic News Errors Library File Library Resource Links ASP CLASSICTIDBITS: All as FlashCards Code Snippets FAQs Tips

	ASP Classic To/From
To/FromCODEGuides ASP Classic To/From

	ASP Classic Study Test
PRESTWOODCERTIFIED ASP Classic Study Test

	ASP Classic Store
PRESTWOODSTORE Store Home Buy ASP Classic Items

	Members Only
MEMBERSONLY ASP Classic Member List Member Only KB Posts ASP Classic Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code

Prestwood eMagazine

March Edition

Subscribe now! It's Free!

► KB ► ASP Classic Knowledge Base

Print This All Groups

ASP Classic FAQ Page

These FAQs are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the ASP Classic sub-topics.

Contribute a FAQ

Expand All

4 ASP Classic Coding FAQs

Group: ASP Classic Coding

Topic: ASP Classic

Q1. How do you find last Monday? I want to return a date for last Monday or today if today is Monday.

Answer:

While Weekday(ADate) <> vbMonday
     ADate = DateAdd("d", -1, ADate)
WEnd

You could wrap this up in a function as follows:

Function SU_GetLastDOW(ADate, AWeekDayConst)
    While Weekday(ADate) <> AWeekDayConst
        ADate = DateAdd("d", -1, ADate)
    WEnd
    
    SU_GetLastDOW = ADate
End Function

Posted By Mike Prestwood, Post #100713, KB Topic: ASP Classic

More Info +Add Comment (4 Comments)

Q2. What does VBScript stand for?

Answer: VBScript is short for Visual Basic Scripting. VBScript brings scripting to a wide variety of environments, including Web client scripting in Microsoft Internet Explorer and Web server scripting in Microsoft Internet Information Service. It is used in Visual Basic, Access, Word, Excel, ASP, etc.

Posted By Mike Prestwood, Post #100783, KB Topic: ASP Classic

More Info +Add Comment

Topic: Tool Basics

	Q3. Can you edit Access and MS SQL Server views?
	Answer: Although this question really depends on the provider, in general, the answer is no to MS Access views and yes to MS SQL Server views so long as you open the RecordSet editable. Posted By Mike Prestwood, Post #100800, KB Topic: Tool Basics More Info +Add Comment (1 Comments)

Topic: Language Details

	Q4. What is the syntax in ASP Classic for using an associative array?
	Answer: Use a dictionary: Dim StateList set StateList = Server.CreateObject("Scripting.Dictionary") StateList.Add "CA", "California" Response.Write "NV is " & StateList("NV") For more examples, refer to our ASP Classic Associative Array (Scripting.Dictionary) article. Posted By Mike Prestwood, Post #101199, KB Topic: Language Details More Info +Add Comment (3 Comments)