| |
| |
Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.
|
|
|
| |
| |
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
|
|
|
| |
| |
Sample implementation (source code)illustrating how to implement a 'Suggestion Box' style form using ASP and MS Access. Easily installed, and customized.
|
|
|
| |
| |
Have you ever wanted to format a date in your ASP pages (using VBScript) to conform with RFC-822? These are required for various things but in particular they are required format for dates in RSS feeds. While I was producing some RSS feeds I couldn't find any functions that converted ASP dates to the required formats so I created the following functions to do it for you
|
|
|
| |
| |
This tutorial will show you how to display the current date with the ordinal suffix e.g. Wednesday 12th May
|
|
|
| |
| |
Following example displays usage of setDate method in JScript. 'setDate methods sets the numeric date of the Date object using local time.
|
|
|
| |
| |
DatePart function is a very useful function to get the a part of a date. You may get year, month, day of year .. etc. of a specific date.
|
|
|
| |
| |
In this source code, you may see how can you display date in diffrent formats. This simple ASP code displays current time in short, long and regional settings.
|
|
|
| |
| |
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement
|
|
|
| |
| |
This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.
|
|
|
| |
|
