IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► eMag   Print This    All Groups  
View Group Edition:
Full Edition Your Edition || Prev Next || Subscription Center

Prestwood IT Newsletter Apr 2010 Issue - ASP Classic Edition

Subscribe!

Start subscribing now! It's free!

Each month on or after the 1st, and only once a month, we will send you content from up to 5 community groups. If you select this ASP Classic group, you'll receive the following content below mixed in with the other groups you elect to include.

Prestwood eMag
Our monthly opt-in coupons+newsletter.
portal.prestwood.com
  April 2010 - ASP Classic Edition Year 12 Issue 4  
Your full service technology partner!
From The Editor
Mike Prestwood

Hi all,

Prestwood.com websites now on a dedicated server!!!   Finally. Sunday April 25th we finished migrating our family of websites to a dedicated server. {#biggrin} Now all our websites should be much more enjoyable to use:

Now that we are no longer running into slowness nor that dreaded 503 error, we can start to re-enable some of the features we disabled. You'll notice the Who's Online box has returned at the bottom of the pages when you're on either community.prestwood.com or PrestwoodBoards.com. Other community features will return shortly.

Enjoy!!!



Expert guidance from working professionals!
SQL Servers topic (classic post):
General SQL Optimization Tips
by Bryan Valencia

In this article, you will be shown a few generic methods to optimize your SQL queries.  This information is not database-specific (other than in a few places) and should apply to any SQL based database.






 ASP Classic Group Top 
Visit Group | My Group Settings
Language Basics topic (classic post):
Random Numbers with Rnd and Randomize
by Mike Prestwood
Call randomize then call Rnd to generate a random number between 0 and 1.

OOP topic (classic post):
ASP Classic Member Visibility (Private, Public)
by Mike Prestwood

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.


 Monthly ASP Classic Lesson
ASP Classic Topic:
Code Snippet of the Month

ASP uses MoveFirst, MoveLast, MoveNext, and MovePrevious to move a database cursor (a RecordSet).

objRecordSet.MoveNext

The following snippet moves to the second to last record of a given RecordSet object:

objRecordSet.MoveLast
objRecordSet.MovePrevious
Tool Basics Topic:
Question: 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.

ASP Classic Topic:
Tip of the Month

When naming constants, Microsoft suggests you prefix each constant with "con" as in conYourConstant. Although, they also say the older all caps with words separated by an underscore is still acceptable (i.e. YOUR_CONSTANT).

Because I code in multiple languages and I really don't like all caps with underscores, I've adopted a lowercase k in place of con as in kFeetToMeter.



Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


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