Add time period to date

Add time period to date
In the table the actual servers date is shown(first part of the table), and bellow we have add diferent intervals of times to actual date. The new date has been saved to a variable named Mydate and date, year, month, monthname, day, and weekday corresponding to Mydate has been shown in each line .

This kind of code may be useful to display the correct date corresponding to a country or region when the server is located in a different country (for example, the server is located in US, and the visitors are from Spain)

date Year Month MonthName Day Weekday
The actual date
9/13/2008
2008
9
September
13
7

Add a time period to actual date
Add 3 years to actual date:
9/13/2011 2011 9 September 13 3
Add 3 quarters to actual date:
6/13/2009 2009 6 June 13 7
Add 3 months to actual date:
12/13/2008 2008 12 December 13 7
Add 3 days to actual date:
9/16/2008 2008 9 September 16 3
Add 24 hours to actual date:
9/13/2008 3:00:00 AM 2008 9 September 13 7
Add 1440 minutes to actual date:
9/13/2008 12:03:00 AM 2008 9 September 13 7
Add 86400 seconds to actual date:
9/13/2008 12:00:03 AM 2008 9 September 13 7

http://www.asptutorial.info/sscript/Addtimeperiodtodate.html

ASCII Chart

As boring as an ASCII chart maybe.. sometimes you just need a look up table to reference if needed.
http://www.startupinternetmarketing.com/resources/ascii.html
————————–

ASCII Chart
This chart contains the code for all printable ASCII characters. Simply copy the code for the character that you want to display, and paste it into your document.

General font = any standard font face
Symbol font = the symbol font available in Windows

Character
General font Character
Symbol font # code Alternate
HTML Description
 Unused
 Unused
Carriage Return
 Unused
 Unused
Space Space
! ! ! Exclamation point
" " " " Double Quotes
# # # Number symbol
$ $ $ Dollar symbol
% % % Percent symbol
& & & & Ampersand
' ' ' Single quote
( ( ( Open parenthesis
) ) ) Close parenthesis
* * * Asterisk
+ + + Plus sign
, , , Comma
- - - Hyphen
. . . Period
/ / / Slash (bar)
0 0 0 Zero
1 1 1 One
2 2 2 Two
3 3 3 Three
4 4 4 Four
5 5 5 Five
6 6 6 Six
7 7 7 Seven
8 8 8 Eight
9 9 9 Nine
: : : Colon
; ; ; Semicolon
< > > > Greater than
? ? ? Question mark
@ @ @ At symbol

————————–

Plus many more at: http://www.startupinternetmarketing.com/resources/ascii.html

Recordset.Move()

Recordset.Move()

The Recordset.Move() technique was the first example I ever posted in this article. In an attempt to eliminate the need for heavy recordset objects, I decided to try the Move() method to skip the first n rows in the resultset to start at the first row for the page we are interested in.

<%
rstart = PerPage * Pagenum – (PerPage – 1)

dataSQL = “SELECT ArtistName, Title FROM SampleCDs WITH (NOLOCK)”

set rs = conn.execute(dataSQL)

if not rs.eof then

rs.move(rstart-1)

response.write “

”

for x = 1 to PerPage

if rs.eof then exit for

artist = rs(0)
title = rs(1)

if artist prevArtist then
prevArtist = artist
response.write “

“
response.write ”

”

rs.movenext
next

response.write “

“ response.write artist & “	“ else response.write “
	“ end if response.write title & “

“
else
response.write “No rows found.”
response.end
end if
%>

This code can be found at:
http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html

Display an Image in a SQL Database

Display an Image in a SQL Database

second option :

in file test.html, put this code :-

<img src=”image.asp?id=1″>

then, in same directory, make file image.asp
and put this code :-

<%
Response.ContentType = “image/gif” 

Response.Expires = 0
Response.Buffer = TRUE
Response.Clear

id = Request.QueryString(”id”)

`checking the data exist or not
`Server Name=test
`SQL Server database name=test

cme = “DRIVER={SQL SERVER};SERVER=test;UID=sa;pwd=;DATABASE=test”

`field ImageItem is image datatype in SQL Server.
cmdsql = “SELECT ImageItem from EQUIPMENT WHERE id =`”&id&”`”
set rs = Server.CreateObject(”adodb.Recordset”)
rs.open cmdsql, cme

Response.BinaryWrite rs(”ImageItem”)
Response.End 
%>

FOUND AT: http://www.codetoad.com/forum/16_9829.asp

What do we do Now?

What do we do Now?
-by Peter Francese

Since October of 2007, the value of an index fund based on the Dow Jones Industrial Average has fallen 40 percent.  But a great many stock funds are down at least 50 percent from a year ago, and hardly anyone is suggesting that this is the bottom.

By comparison from October of 2007 to this past October, the median sale price of a New Hampshire residence (not including condominiums) has fallen just 13 percent.  All homeowners can rightly be distressed about the drop in home prices in our state, but over the past year it’s pretty clear which was the better investment.

Considering the sharp drop in retail sales and the general economic situation, it’s likely to be some months before consumer confidence climbs up from its all-time low point.  The president of Best Buy recently said, “In my 42 years of retailing, we’ve never seen such difficult times for the consumer.  People are making dramatic changes in how much they spend, and we’re not immune from those forces.”

The fact that, despite their problems, Best Buy is so much better off than their chief competitor, Circuit City, which has filed for bankruptcy, offers some insight for REALTORS®. The biggest difference between those firms is that Best Buy invested a great deal more in their website, and they invested more heavily to understand how customers for electronic goods were changing.

There is no doubt that this is an extraordinarily difficult time for New Hampshire REALTORS®.  But it is my belief that when the economy recovers, the most successful ones will be those who invested in upgrading their website and increasing their knowledge of today’s home buyers.

Results from the monthly survey which we ask you to complete will provide more information about home buyers (October survey results are described below).

But improving your website really requires some technical assistance.  Here are three suggestions for the next time you upgrade your site:

• 1. Make the  print bigger.  More of the people visiting your site are older and have trouble reading small print.
• 2. Use as many virtual tours or video tours of homes as you budget permits.  More site visitors will expect to see some type of video presentation rather than just small still photos.
• 3. Describe in more detail a home’s benefits in terms that matter to prospective buyers.  More buyers, for example, want to know if it has broadband access, how close it is to town or if it’s handicap accessible and/or energy efficient.

New IDX Broker Website Release

Prudential Green Mountain Realty
(IDX Real Estate Website Design & Rutland VT & Southern VT Web Design)

New website includes Google VREIN & NNEREN MLS Mapping along a ton of information for buyers, sellers, community & mortgage. Go to: www.GreenMTNRealty.com

Need a Slideshow? Try Google AJAX Slide Show

Looking for an easy to install slide show?

The Google AJax slide show is very easy to install and can even use a custom rss feed to use your own images from your database on the fly.  Uses flash with no real options for button changes but the ease of installation makes this a great call for most any project.

AJAX Slide Show Specs

The Slide Show is a simple to use application of the Google AJAX Feed API that is designed to let you add photo slide shows to your pages, sites, and blogs. The slide show control takes photo feeds from all popular sites, such as PhotoBucket, Flickr, and Picasa Web Albums. Any feeds that use Media RSS can be used without customization. However, the slide show control allows any photo-based feed to be accomodated, such as iTunes feeds similar to those found in the Tune Bar solution or the custom feed example below.

The Slide Show control is highly customizable, allowing you to specify options such as the number of photos to display, display and transition time between photos, how the photos link back to their source, etc.

Adding the Slide Show to your page is a snap. The easiest way is to start with our sample “hello world” sample. If you want to tweak the code even further, we have a complete Slide Show Programming Guide available for you to learn from.

New IDX Broker Website Release

CENTURY 21 Summit View & Lakes Realty
(IDX Real Estate Website Design & Lakes Region NH Web Design)

New website includes Google NNEREN Mapping along a ton of information for buyers, sellers, community & mortgage. View Live Website

Submit Site-map to MSN & Yahoo!

Submit Site-map to MSN & Yahoo!

Did you know you can now submit your websites site-map to both MSN Live along with Yahoo? Submitting a valid site-map allows the search engines to easily find and index every page within your website. If your site isn’t dynamic it will be easy to product your site-map with just able any free site-map generators you find when searching the web. If your site is dynamic and contains anymore then 500 pages you will need a special generator that can help.

GSite Crawler: http://gsitecrawler.com/en/download/

Or try AuditMyPC: http://www.auditmypc.com/free-sitemap-generator.asp

Once you generate a site-map for your site visit MSN and Yahoo’s developers section for complete instructions on adding your site-map.

MSN Developers: http://webmaster.live.com/

Yahoo! Site Explorer: http://siteexplorer.search.yahoo.com/

Monitor Your Websites Uptime

In todays market we all need to be sure our websites are up and running properly, but what if you have multiple websites?  Try this service..  its totally free!

Montastic

Website monitoring made cool:

Get an email when your site goes down

Get an email when it goes back up

Read statuses via RSS or Yahoo widget

Fun, easy and elegant user interface

No unreasonable limit on the number of websites monitored