Convert to DVD

VSO ConvertXtoDVD 3.8.0.193f Final – Multilingual – Full
Incl. Serials ( 100% Working )
New Release: SEP28, 2009

Vso Convertxtodvd 3 8 0 193f Final - Multilingual

Information:

ConvertXtoDVD (formerly DivXtoDVD) is a software to convert and burn your videos to DVD. With ConvertXtoDVD and in a few clicks you can backup your movies to DVD playable on any home DVD player.

ConvertXtoDVD supports most popular format such Xvid, MOV, VOB, Mpeg, Mpeg4, MP4, AVI, WMV, DV and stream formats. It converts your files into a compliant DVD Video set of files and burns it on a DVD media.

The aspect ratio can be automatically selected or forced to a specific format. The program works for NTSC and PAL video formats and creates chapters automatically. Multiple audio tracks are supported. Version 2 uses a completely rewritten interface with subtitles support and a lot of new settings.

Features:
* Video formats supported: avi, divx, xvid, mov, mkv, flv, mpeg-1, mpeg2-, mpeg-4, nsv, dvr-ms, tivo, ts, ifo, vob, asf, wmv, realmedia, rm, rmvb, ogm, existing files from digital camcorders, TV/Sat, capture cards, etc. No external codecs needed like avi codec download
* Create DVD menus with different templates available, possibility to add background video, image or audio, have chapter and audio/subtitle menus
* Conversion advisor wizard, control of the conversion speed vs. quality
* Fast and quality encoder, typically less than 1 hour for converting 1 movie, and supports Multi-Core processors!
* Included burning engine with burn speed control choice of SAO or packet writing methods, supports all DVD formats
* Custom and or automatic chapter creation with markers and preview window
* Advanced file merging possibilities
* Audio formats supported internal and external: AC3, DTS, PCM, OGG, MP3, WMA and more…
* Subtitles files supported internal and external: SRT, .SUB/IDX, .SSA with color and font selection, and supports tags like italic, bold
* Video output for video standard (NTSC, PAL), TV Screen (Widescreen 16:9, Fullscreen 4:3) and DVD Resolution (Full D1, Boradcast D1, Half D1, SIF), or choose automatic for all choices listed above. Also convert video from NTSC to PAL or PAL to NTSC
* Video post processing settings like video resize-pad/cropping and de-interlacing options

* Multilingual support: English, Spanish, French, Italian, Japanese, Chinese, German, etc
* conpatible with: Windows XP, Vista, Win7 (32/64-bits)


http://hotfile.com/dl/14498937/b2431d4/Vso.ConvertXToDVD.3.8.0.193f_by.tano1221.rar.html

Dont execute code on page reload

I have an asp page which when loads, sends notification emails and adds data to a Mysql database.people refreshing the page or when navigating back to the page using the browser, this script is run again. So to stop the code to execute again on page reload insert the below code into the page.

CODE:

<%
if Request.Cookies("Mail")<>"" then
Response.Write "cant mail twice!!"
else
Response.Cookies("mail")="Ams"
Response.Write "Mailed!!"
//Put your insert/mail code here.
end if
%>

How To Use On Error Resume Next

Often when using ASP or Active Server Pages with VBScript you will find it necessary to check for errors when you do certain things that may fail and then handle it accordingly. Things like opening a database connection or writing to a text file come to mind.

Generally if an error is encountered in your .asp file, the processing of your script stops and an error message is returned to the browser. If you want to continue processing your page even if an error is encountered, include the following line at the beginning of your .asp file:

<% On Error Resume Next %>

That being said just ignoring errors in your code is not a very good idea. What you really want to do is handle the error in some way.

The example below opens a database connection and shows you how to trap a potential error and do whatever you want because of it. In this case we are simply displaying the error.

<%
ConnectionString = "DBQ=c:\inetpub\wwwroot\mysite\data\mydatabase.mdb;Driver={Microsoft Access Driver (*.mdb)};"

'*** This code checks the ConnectionString info you entered and reports back the error code if it is not ok
Err.Clear
On Error Resume Next
Set ConnPasswords = Server.CreateObject("ADODB.Connection")
ConnPasswords.Open ConnectionString

If Err.Number <> 0 Then

Response.Write (Err.Description& "<br><br>")

Response.Write("This means there is most likely a problem with the" & vbCrLf)
Response.Write("""ConnectionString"" info that you specified.<br>" & vbCrLf)
Response.End

End If
On Error GoTo 0
%>

We put the "On Error GoTo 0 at the end because that will essentially end the "on error resume next"
That is something you want to do so any later errors in your application do not get ignored without you knowing about it.

Below is another example. In this example our application logs user info in a text file when they sign in to a site.
We add "On Error Resume Next" here simply so no nasty error message come up if by chance write permissions to the text file do not exist.

<%
Set ObjMyFile = CreateObject("Scripting.FileSystemObject")
Err.Clear
On Error Resume Next
LogFileName = "aspprotect.log"
LogFileDirectory = "c:\somedirectory"

'Open Text File.. If doesn't exist create it and append to it .. If exists just append to it
Set WriteMyData = ObjMyFile.OpenTextFile(LogFileDirectory & "\" & LogFileName,8,True)
RowHeaderString = Session("User_ID") & vbTab
RowHeaderString = RowHeaderString & Session("Username") & vbTab
RowHeaderString = RowHeaderString & NOW & vbTab
RowHeaderString = RowHeaderString & Request.ServerVariables("REMOTE_ADDR")
WriteMyData.WriteLine(RowHeaderString)
WriteMyData.Close
On Error GoTo 0
%>

You have to be really careful using "On Error Resume Next".
Using the "On Error GoTo 0" helps tremendously though because at least you can stop it from ignoring errors later on in your code.

Sending email using CDOSYS

If you are using a Windows 2000 / 2003 Server, or even XP Pro chances are that CDOSYS is your best bet for sending email from Active Server Pages. That is because CDOSYS is installed on all of them by default. Gone are the days of using CDONTS which was the old way of sending email from ASP. CDOSYS is it's replacement.

That being said there are actually a lot of ways to configure and use CDOSYS. When I 1st started using CDOSYS I assumed the CDOSYS code I was using would work in any situation, but that is not the case. This is something most articles about CDOSYS do not mention so I am going to show you 3 different CDOSYS examples each sending email using a slightly different method.

1. Method 1 involves sending email using a local pickup directory. Meaning you have the IIS SMTP Virtual Server Running. If you are on a local development machine this is probably for you. Under this scenario any emails you send from your scripts put a ".eml" file in the local pickup directory. Then hopefully the SMTP Virtual Server grabs the file and sends it off. The Virtual SMTP server is however known to hiccup and not send out the emails right away.
2. Method 2 involves port forwarding. I am not exactly sure how you set that up on the server but the code I wrote for it works under that scenario. The hosting company known as Verio actually implements this with CDOSYS on their servers. I actually implemented this method in some of my software because of a customer that couldn't get emails to send on one of their servers.
3. Method 3 involves sending the email using a remote mail server. This supports outgoing SMTP authentication should your server require that for outgoing emails. Many do these days. This method is also the best method to use because you are using a real email server with valid MX records. Many modern email systems block emails that do not have valid MX records and you want your emails to reach the recipients.

Method 1 ( Local Pickup Directory where server is running SMTP Virtual Server )

<%
Dim ObjSendMail
Dim iConf
Dim Flds

Set ObjSendMail = Server.CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
Set Flds = iConf.Fields

Flds("http://schemas.microsoft.com/cdo/configuration/sendusing") = 1

'**** Path below may need to be changed if it is not correct
Flds("http://schemas.microsoft.com/cdo/configuration/smtpserverpickupdirectory") = "c:\inetpub\mailroot\pickup"
Flds.Update

Set ObjSendMail.Configuration = iConf
ObjSendMail.To = "someone@someone.net"
ObjSendMail.Subject = "this is the subject"
ObjSendMail.From = "someone@someone.net"

' we are sending a text email.. simply switch the comments around to send an html email instead
'ObjSendMail.HTMLBody = "this is the body"
ObjSendMail.TextBody = "this is the body"

ObjSendMail.Send

Set ObjSendMail = Nothing
%>



Method 2 ( Using mail forwarding on port 25 )
Include this metatype library code on the page you use this emailing with code because there are some things in it this method needs. You can probably get rid of these two lines if you figure out what it references but I didn't take the time to look.




<%
Dim ObjSendMail
Dim iConf
Dim Flds

Set ObjSendMail = Server.CreateObject("CDO.Message")
Set iConf = Server.CreateObject("CDO.Configuration")

Set Flds = iConf.Fields
With Flds
.Item(cdoSendUsingMethod) = 2
.Item(cdoSMTPServer) = "mail-fwd"
.Item(cdoSMTPServerPort) = 25
.Item(cdoSMTPconnectiontimeout) = 10
.Update
End With

Set ObjSendMail.Configuration = iConf

Set ObjSendMail.Configuration = iConf
ObjSendMail.To = "someone@someone.net"
ObjSendMail.Subject = "this is the subject"
ObjSendMail.From = "someone@someone.net"

' we are sending a text email.. simply switch the comments around to send an html email instead
'ObjSendMail.HTMLBody = "this is the body"
ObjSendMail.TextBody = "this is the body"

ObjSendMail.Send

Set ObjSendMail = Nothing
Set iConf = Nothing
Set Flds = Nothing
%>

Method 3 ( Using remote mail server )

<%
Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

'This section provides the configuration information for the remote SMTP server.

ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'Send the message using the network (SMTP over the network).
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") ="mail.yoursite.com"
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False 'Use SSL for the connection (True or False)
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60

' If your server requires outgoing authentication uncomment the lines bleow and use a valid email address and password.
'ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 'basic (clear-text) authentication
'ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") ="somemail@yourserver.com"
'ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") ="yourpassword"

ObjSendMail.Configuration.Fields.Update

'End remote SMTP server configuration section==

ObjSendMail.To = "someone@someone.net"
ObjSendMail.Subject = "this is the subject"
ObjSendMail.From = "someone@someone.net"

' we are sending a text email.. simply switch the comments around to send an html email instead
'ObjSendMail.HTMLBody = "this is the body"
ObjSendMail.TextBody = "this is the body"

ObjSendMail.Send

Set ObjSendMail = Nothing
%>

In addition to what you see here there are plenty of properties you can add to these examples.
Here are a few examples.

Carbon Copy
ObjSendMail.CC = "someone@someone.net"

Blind Carbon Copy
ObjSendMail.BCC = "someone@someone.net"

Send Attachment (we hard code it here, but you could specify the file path using Server.Mappath as well)
ObjSendMail.AddAttachment "c:\myweb\somefile.jpg"

and a ton of other things you can do...
See Microsoft's CDOSYS Documentation

website templates

the best websites for free html templaes are as given below:

• http://www.boxedart.com
• http://www.bestfreetemplates.info/allfree.php
• http://www.metamorphozis.com/
• http://www.freesitetemplates.com/
• http://www.templateworld.com/free_templates.html
• http://www.freewebtemplates.com/
• http://www.freewebsitetemplates.com/

Examples for Alternating Table Row Colors

' ASP Version
strsql = "SELECT Adjective, Noun FROM DrSeussLines"
objRS.Open strsql,objCN,adOpenForwardOnly,adLockReadOnly,adCmdText
i = 0
Response.write "<table>"
Do While Not objRS.EOF
i = i + 1
Response.write "<tr class=""d" & (i And 1) & """>"
Response.write "<td>" & objRS(0) & "</td>"
Response.write "<td>" & objRS(1) & "</td>"
Response.write "</tr>" & vbCrLf
objRS.MoveNext
Loop
objRS.Close
Response.write "</table>"

// PHP Version
$query = "SELECT Adjective, Noun FROM DrSeussLines";
$result = mysql_query($query);
$i = 0;
print "<table>";
while(($row = mysql_fetch_row($result)) !== false) {
$i++;
print "<tr class=\"d".($i & 1)."\">";
print "<td>".$row[0]."</td>";
print "<td>".$row[1]."</td>";
print "</tr>\n";
}
mysql_free_result($result);
print "</table>";

For non-DB pages

Efficient Alternating Table Row Colors

To produce the same effect with less code, instead define two types of TR classes. Then, use inheritance to the TD tag. Read the example and the explanation will follow.

<style type="text/css">
tr.d0 td {
background-color: #CC9999; color: black;
}
tr.d1 td {
background-color: #9999CC; color: black;
}
</style>
<table>
<tr class="d0"><td>One</td><td>Fish</td></tr>
<tr class="d1"><td>Two</td><td>Fish</td></tr>
<tr class="d0"><td>Red</td><td>Fish</td></tr>
<tr class="d1"><td>Blue</td><td>Fish</td></tr>

Hide a table row on change of a select box

<html>
<head>
<title>change code</title>
<script language="javascript">
function changeCode()
{
if(document.getElementById('country').selectedIndex > 6)
{
document.getElementById('ukcode').style.display="none";
document.getElementById('ukcode').style.visibility="hidden";
document.getElementById('eucode').style.display="block";
document.getElementById('eucode').style.visibility="visible";
}
else
{
document.getElementById('eucode').style.display="none";
document.getElementById('eucode').style.visibility="hidden";
document.getElementById('ukcode').style.display="block";
document.getElementById('ukcode').style.visibility="visible";
}

}
</script>
</head>
<body onLoad="changeCode();">
<table>
<tr>
<td><strong>Country:</strong></td>
<td>
<select name="country" id="country" onChange="changeCode();">
<option value="UK" selected>United Kingdom</option>
<option value="NI" >N. Ireland</option>
<option value="BF" >BFPO</option>
<option value="CI" >Channel Islands</option>
<option value="SH" >Scottish Highlands</option>
<option value="NI" >-----------</option>
<option value="E1" >Europe 1</option>
<option value="E2" >Europe 2</option>
<option value="E3" >Europe 3</option>
<option value="E4" >Europe 4</option>

</select>
</td>
</tr>
<tr>
<td colspan="2">
<div id="ukcode" name="ukcode">
<strong>Postcode (UK):</strong>
<input type="text" name="postcode1" size="3" maxlength="20">
- <input type="text" name="postcode2" size="3" maxlength="4">
</div>
</td>
</tr>
<tr>
<td colspan="2">
<div id="eucode" name="eucode">
<strong>Postcode (EU):</strong>
<input type="text" name="postcodeEU" size="8" maxlength="20">
</div>
</td>
</tr>
</table>
</body>

Text Box Characters Counter (IE, Opera, FireFox, & Safari)

In forms when using text boxes or text areas with limited character length (usually needed for forms that submit data to a database) it is always a good idea to tell the user how many characters they have remaining. This javascript snippet is especially useful for textarea fields since they can't be assigned a text limit in HTML but can be restricted using this code.

The following example shows how you can do this. This is a very simple and cute idea to help the user know exactly how many characters can be typed further. Do these small add-ons to your forms and they will look really professional. We recommend using this counter inside CMS solutions and custom built Admin Panels where your clients/visitors can be instructed to use all browsers like IE, Opera, FireFox, Netscape or Safari.

JavaScript to be pasted in head tags

<script language = "Javascript">
/**
* DHTML textbox character counter script. Courtesy of SmartWebby.com (http://www.smartwebby.com/dhtml/)
*/

maxL=255;
var bName = navigator.appName;
function taLimit(taObj) {
if (taObj.value.length==maxL) return false;
return true;
}

function taCount(taObj,Cnt) {
objCnt=createObject(Cnt);
objVal=taObj.value;
if (objVal.length>maxL) objVal=objVal.substring(0,maxL);
if (objCnt) {
if(bName == "Netscape"){
objCnt.textContent=maxL-objVal.length;}
else{objCnt.innerText=maxL-objVal.length;}
}
return true;
}
function createObject(objId) {
if (document.getElementById) return document.getElementById(objId);
else if (document.layers) return eval("document." + objId);
else if (document.all) return eval("document.all." + objId);
else return eval("document." + objId);
}
</script>

html code to be pasted within body tags

<font> Maximum Number of characters for this text box is 255.<br>
<textarea onKeyPress="return taLimit(this)" onKeyUp="return taCount(this,'myCounter')" name="Description" rows=7 wrap="physical" cols=40>
</textarea>
<br><br>
You have <B><SPAN id=myCounter>255</SPAN></B> characters remaining
for your description...</font>

Creating a login script with ASP

login.asp

<%
Response.Expires = -1000 'Makes the browser not cache this page
Response.Buffer = True 'Buffers the content so our Response.Redirect will work
Session("UserLoggedIn") = ""
If Request.Form("login") = "true" Then
CheckLogin
Else
ShowLogin
End If

Sub ShowLogin
%>

<form name=form1 action=login.asp method=post>
User Name : <input type=text name=username><br>
Password : <input type=password name=userpwd><br>
<input type=hidden name=login value=true>
<input type=submit value="Login">
</form>
>%
End Sub

Sub CheckLogin
If LCase(Request.Form("username")) = "guest" And LCase(Request.Form("userpwd")) = "guest" Then
Session("UserLoggedIn") = "true"
Response.Redirect "protectedpage.asp"
Else
Response.Write("Login Failed.<br><br>")
ShowLogin
End If
End Sub
%>

Protectedpage.asp
<%
Response.Expires = -1000 'Makes the browser not cache this page
Response.Buffer = True 'Buffers the content so our Response.Redirect will work

If Session("UserLoggedIn") "true" Then
Response.Redirect("login.asp")
End If
%>

This page is full of password protected content. If you are reading this you entered

the correct name and password.


read more

ASP Sending e-mail with CDOSYS

CDOSYS is a built-in component in ASP. This component is used to send e-mails with ASP.
Sending e-mail with CDOSYS

CDO (Collaboration Data Objects) is a Microsoft technology that is designed to simplify the creation of messaging applications.

CDOSYS is a built-in component in ASP. We will show you how to use this component to send e-mail with ASP.
How about CDONTs?

Microsoft has discontinued the use of CDONTs on Windows 2000, Windows XP and Windows 2003. If you have used CDONTs in your ASP applications, you should update the code and use the new CDO technology.
Examples using CDOSYS

Sending a text e-mail:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.TextBody="This is a message."
myMail.Send
set myMail=nothing
%>

Sending a text e-mail with Bcc and CC fields:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.Bcc="someoneelse@somedomain.com"
myMail.Cc="someoneelse2@somedomain.com"
myMail.TextBody="This is a message."
myMail.Send
set myMail=nothing
%>

Sending an HTML e-mail:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.HTMLBody = "<h1>This is a message.</h1>"
myMail.Send
set myMail=nothing
%>

Sending an HTML e-mail that sends a webpage from a website:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.CreateMHTMLBody "http://www.w3schools.com/asp/"
myMail.Send
set myMail=nothing
%>

Sending an HTML e-mail that sends a webpage from a file on your computer:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.CreateMHTMLBody "file://c:/mydocuments/test.htm"
myMail.Send
set myMail=nothing
%>

Sending a text e-mail with an Attachment:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.TextBody="This is a message."
myMail.AddAttachment "c:\mydocuments\test.txt"
myMail.Send
set myMail=nothing
%>

Sending a text e-mail using a remote server:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.TextBody="This is a message."
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing")=2
'Name or IP of remote SMTP server
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver")="smtp.server.com"
'Server port
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=25
myMail.Configuration.Fields.Update
myMail.Send
set myMail=nothing
%>
insert variable in mail body:
" & Request.Form("firstname") & "

Dynamic Excel Reports with ASP

Sometimes it's useful to present data to users in Excel format, so they can easily manipulate the data themselves. In this article, a very simple technique for accomplishing this is demonstrated.

Technique

There are many situations in which you may wish to convert table data into an Excel spreadsheet format for the user. There are several methods available for doing this; I will describe in this article one of the simplest ones. It basically tricks the user's browser into thinking the HTML it is downloading is actually an Excel document, and then Excel does the rest of the work by parsing the HTML into a worksheet. Because of the way this works, although this technique is free and easy, it is also very limited in how it can be used. Also, this method only works if the client has Excel 97 or later installed.

If you need to generate Excel documents on the web server in any kind of scalable, robust, or customized fashion, the best tool available is OfficeWriter (formerly ExcelWriter) from SoftArtisans. AspAlliance author Andrew Mooney has written a fairly detailed review of an older version (v4) of ExcelWriter.

In order to create an Excel report dynamically, you must simply create a .asp file with the header of:

1 <% 2 Response.ContentType = "application/vnd.ms-excel"
3 %>

This informs the browser that the code to follow is Excel formatted, and Netscape or IE will prompt the user to Save or Open the file. When they Open the file, Excel is launched and the report is viewed by Excel. In order for Excel to understand your data, you need only to create an HTML table, which Excel 97 will then convert into its own format. NOTE: This must be the first line of code on the page! (Actually, it just has to be before any other header or HTML info is output to the browser, but put it at the top and it won't cause you problems)

Code

They also want to be able to manipulate this data using Excel, and perform some calculations on it. They created an Excel sheet using this code:

<%
Response.ContentType = "application/vnd.ms-excel"

set conntemp=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath("/stevesmith/data/timesheet.mdb")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
set RS=conntemp.execute("select * from donut")
%>
<TABLE BORDER=1>
<TR>
<%
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % Loop through Fields Names and print out the Field Names
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
j = 2 'row counter
For i = 0 to RS.Fields.Count - 1
%>
<TD><B><% = RS(i).Name %></B></TD>
<% Next %>
<TD><B>On Hand (calculated)</B></TD>
<TD><B>Gross (calculated)</B></TD>
</TR>
<%
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % Loop through rows, displaying each field
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Do While Not RS.EOF
%>
<TR>
<% For i = 0 to RS.Fields.Count - 1
%>
<TD VALIGN=TOP><% = RS(i) %></TD>
<% Next %>
<TD>=b<%=j%>-c<%=j%>-d<%=j%></TD>
<TD>=d<%=j%>*e<%=j</TD>
</TR>
<%
RS.MoveNext
j = j + 1
Loop
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % Make sure to close the Result Set and the Connection object
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
RS.Close
%>
<TR BGCOLOR=RED>
<TD>Totals</TD>
<TD>=SUM(B2:B6)</TD>
<TD>=SUM(C2:C6)</TD>
<TD>=SUM(D2:D6)</TD>
<TD>n/a</TD>
<TD>=SUM(F2:F6)</TD>
<TD>=SUM(G2:G6)</TD>
</TR>
</TABLE>

Add a date or time stamp to new records in access db

In some Microsoft Office Access tables, it is important to keep track of the date or the date and time when a new record is added. This is often referred to as a date or time stamp. You can use the Now or Date functions to have Access automatically fill in the date or time when a new record is added. Use the Now function to fill in the date and time, or the Date function to fill in just the date.

Add a date or time stamp field

1. In the Navigation Pane, double-click the table to which you want to add the time stamp field.

   Access opens the table in Datasheet view.

2. In the first blank column, double-click the column header labeled Add New Field, type a name for the field, such as Date Added, and then press ENTER.
3. Select the column that you just added and then, under Table Tools, on the Datasheet tab, in the Data Type & Formatting group, select Date/Time in the Data Type list.
4. Click the Microsoft Office Button and then click Save, or press CTRL+S.
5. On the Home tab, in the Views group, click View, and then click Design View.
6. In the Field Name column, click your new field.
7. Under Field Properties, on the General tab, click in the Default Value property box, and then type Now() or Date().
8. Click the Show Date Picker property box, and then select Never from the list.
9. Save your changes, and then close the table.

Each time you add a new record to the table, Access automatically inserts the date or the date and time in the Date Added field.

Age Calculator

This Javascript Age calculator is used to calculate your age.This age calculator is used to calculate the age,number of days and seconds from the given date or from the day your birth.

Features:

a) Age calculator is used to calculate the age. b) This is free javascript calculator. c) Copy the code from given textarea and to use this calculator.

Javascript to be pasted in head tags:

<!-- Script by hscripts.com -->
<!-- Copyright of HIOXINDIA -->
<!-- More scripts @www.hscripts.com -->
<script language="javascript">
var startyear = "1950";
var endyear = "2010";
var dat = new Date();
var curday = dat.getDate();
var curmon = dat.getMonth()+1;
var curyear = dat.getFullYear();
function checkleapyear(datea)
{
if(datea.getYear()%4 == 0)
{
if(datea.getYear()% 10 != 0)
{
return true;
}
else
{
if(datea.getYear()% 400 == 0)
return true;
else
return false;
}
}
return false;
}
function DaysInMonth(Y, M) {
with (new Date(Y, M, 1, 12)) {
setDate(0);
return getDate();
}
}
function datediff(date1, date2) {
var y1 = date1.getFullYear(), m1 = date1.getMonth(), d1 = date1.getDate(),
y2 = date2.getFullYear(), m2 = date2.getMonth(), d2 = date2.getDate();

if (d1 < d2) {
m1--;
d1 += DaysInMonth(y2, m2);
}
if (m1 < m2) {
y1--;
m1 += 12;
}
return [y1 - y2, m1 - m2, d1 - d2];
}

function calage()
{
var calday = document.birthday.day.options[document.birthday.day.selectedIndex].value;
var calmon = document.birthday.month.options[document.birthday.month.selectedIndex].value;
var calyear = document.birthday.year.options[document.birthday.year.selectedIndex].value;
if(curday == "" || curmon=="" || curyear=="" || calday=="" || calmon=="" || calyear=="")
{
alert("please fill all the values and click go -");
}
else
{
var curd = new Date(curyear,curmon-1,curday);
var cald = new Date(calyear,calmon-1,calday);

var diff = Date.UTC(curyear,curmon,curday,0,0,0) - Date.UTC(calyear,calmon,calday,0,0,0);

var dife = datediff(curd,cald);
document.birthday.age.value=dife[0]+" years, "+dife[1]+" months, and "+dife[2]+" days";
var monleft = (dife[0]*12)+dife[1];
var secleft = diff/1000/60;
var hrsleft = secleft/60;
var daysleft = hrsleft/24;
document.birthday.months.value=monleft+" Month since your birth";
document.birthday.daa.value=daysleft+" days since your birth";
document.birthday.hours.value=hrsleft+" hours since your birth";
document.birthday.min.value=secleft+" minutes since your birth";
var as = parseInt(calyear)+dife[0]+1;
var diff = Date.UTC(as,calmon,calday,0,0,0) - Date.UTC(curyear,curmon,curday,0,0,0);
var datee = diff/1000/60/60/24;
document.birthday.nbday.value=datee+" days left for your next birthday";


}
}
</script>

<!-- Script by hscripts.com -->

html code to be pasted in body tags:

<form name="birthday">
Date<select name="day" size="1">
<script language=javascript>
for(var j=1;j<32;j++)
document.write("<option value="+j+">"+j+"</option>");
</script></select>
Month<select name="month" size="1">
<script language=javascript>
for(var i=1;i<13;i++)
document.write("<option value="+i+">"+i+"</option>");
</script></select>
Year<select name="year" size="1">
<script language=javascript>
for(var k=startyear;k<endyear;k++)
document.write("<option value="+k+">"+k+"</option>");
</script></select>
<input name="start" onclick="calage()" value="Calculate" type="button"><br>
<input name="age" size="40" value="Result"><br>
You have been living for:<br>
<table style="border:solid green 1px"> <tr><td>In months:</td><td><input name="months" size="30"></td></tr> <tr><td>In days:</td><td><input name="daa" size="30"></td></tr> <tr><td>In hours:</td><td><input name="hours" size="30"></td></tr> <tr><td>In minutes:</td><td><input name="min" size="30"></td></tr> <tr><td colspan=2>Your next birthday will be in:</td></tr> <tr><td colspan=2><input name="nbday" size="40"><a href="http://www.hscripts.com" style="color:#3D366F;text-decoration:none;cursor:pointer;font-size:10px">hscripts.com</a></td></tr> </table> </form>

Usage:
a) Copy the above Javascript in your HTML file.
b) Create HTML form using the above HTML code.
c)The function calage() is used for finding the age. The result displays how many days you have lived for in months,days,hours and minutes.
d) Copy the code into your page and to use this calculator.

List of reserved words in Access 2002 and in later versions of Access

This article lists words and symbols that you should not use in field, object, and variable names in Microsoft Access 2002 and later versions of Access because they are "reserved words." Reserved words have a specific meaning to Access or to the Microsoft Jet database engine. If you use a reserved word or symbol, you may receive an error such as the following:

The wizard was unable to preview your report, possibly because a table needed by your report is exclusively locked.

If you use a reserved word, such as date, value, name, text, and year, in Access 2007, you may receive the following message:

The Name you supplied is a reserved word. Reserved words have a specific meaning to Microsoft Office Access or to the Microsoft Office Access database engine

For existing objects with names that contain reserved words, you can avoid errors by surrounding the object name with brackets ([ ]).

MORE INFORMATION

Because it is not practical to provide a list of all reserved words, such as built-in function names or Microsoft Access user-defined names, please check your product documentation for additional reserved words. Note that if you set a reference to a type library, an object library, or an ActiveX control, that library's reserved words are also reserved words in your database. For example, if you add an ActiveX control to a form, a reference is set, and the names of the objects, methods, and properties of that control become reserved words in your database.

-A

ADD

ALL

Alphanumeric

ALTER

AND

ANY

Application

AS

ASC

Assistant

AUTOINCREMENT

Avg

-B

BETWEEN

BINARY

BIT

BOOLEAN

BY

BYTE

-C

CHAR, CHARACTER

COLUMN

CompactDatabase

CONSTRAINT

Container

Count

COUNTER

CREATE

CreateDatabase

CreateField

CreateGroup

CreateIndex

CreateObject

CreateProperty

CreateRelation

CreateTableDef

CreateUser

CreateWorkspace

CURRENCY

CurrentUser

-D

DATABASE

DATE

DATETIME

DELETE

DESC

Description

DISALLOW

DISTINCT

DISTINCTROW

Document

DOUBLE

DROP

-E

Echo

Else

End

Eqv

Error

EXISTS

Exit

-F

FALSE

Field, Fields

FillCache

FLOAT, FLOAT4, FLOAT8

FOREIGN

Form, Forms

FROM

Full

FUNCTION

-G

GENERAL

GetObject

GetOption

GotoPage

GROUP

GROUP BY

GUID

-H

HAVING

-I

Idle

IEEEDOUBLE, IEEESINGLE

If

IGNORE

Imp

IN

INDEX

Index, Indexes

INNER

INSERT

InsertText

INT, INTEGER, INTEGER1, INTEGER2, INTEGER4

INTO

IS

-J

JOIN

-K

KEY

-L

LastModified

LEFT

Level

Like

LOGICAL, LOGICAL1

LONG, LONGBINARY, LONGTEXT

 

-M

Macro

Match

Max, Min, Mod

MEMO

Module

MONEY

Move

-N

NAME

NewPassword

NO

Not

Note

NULL

NUMBER, NUMERIC

-O

Object

OLEOBJECT

OFF

ON

OpenRecordset

OPTION

OR

ORDER

Orientation

Outer

OWNERACCESS

-P

Parameter

PARAMETERS

Partial

PERCENT

PIVOT

PRIMARY

PROCEDURE

Property

-Q

Queries

Query

Quit

-R

REAL

Recalc

Recordset

REFERENCES

Refresh

RefreshLink

RegisterDatabase

Relation

Repaint

RepairDatabase

Report

Reports

Requery

RIGHT

-S

SCREEN

SECTION

SELECT

SET

SetFocus

SetOption

SHORT

SINGLE

SMALLINT

SOME

SQL

StDev, StDevP

STRING

Sum

-T

TABLE

TableDef, TableDefs

TableID

TEXT

TIME, TIMESTAMP

TOP

TRANSFORM

TRUE

Type

-U

UNION

UNIQUE

UPDATE

USER

-V

VALUE

VALUES

Var, VarP

VARBINARY, VARCHAR

VERSION

-W

WHERE

WITH

Workspace

-X

Xor

-Y

Year

YES

YESNO

For more information about special characters to avoid using when you work with the database object names or the field names in all versions of Access, click the following article number to view the article in the Microsoft Knowledge Base:

826763 (http://support.microsoft.com/kb/826763/ ) Special characters that you must avoid when you work with Access databases

Source:http://support.microsoft.com/kb/286335

Active Server Pages (ASP) Access Database Errors

Some of the most common questions asked on the Web Wiz Guide Forums are from people getting errors when using Microsoft Access with ASP. So in this article I'm going to try and explain what a few of the more common errors mean and how to solve them.

Common Access Database Errors

1. Cannot update. Database or object is read-only
2. Operation must use an updateable query
3. General error Unable to open registry key
4. Could not find file
5. Could not use '(unknown)'; file already in use
6. Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'
7. Too few parameters. Expected 1
8. Either BOF or EOF is True, or the current record has been deleted
9. Item cannot be found in the collection corresponding to the requested name or ordinal
10. The search key was not found in any record

Cannot update. Database or object is read-only.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

This is the most common error that I'm asked about. This error usually happens when you try to insert data into or update data in an Access database. It means that you don't have sufficient permissions to write to the database.

If you are running the web server yourself then read the FAQ, Checking and Setting up the Correct Permissions on the Server.

If you are not running the server yourself you will need to contact your web space provider and ask them how to sort the problem out. You may need to use a special folder or they may have to setup a system DSN for you or change the permissions on the directory containing the database.

Operation must use an updateable query
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

This error usually happens when you try to insert data into or update data in an Access database. It means that you don't have sufficient permissions to write to the database.

If you are running the web server yourself then read the FAQ, Checking and Setting up the Correct Permissions on the Server.

If you are not running the server yourself you will need to contact your web space provider and ask them how to sort the problem out. You may need to use a special folder or they may have to setup a system DSN for you or change the permissions on the directory containing the database.

General error Unable to open registry key
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6cc Thread 0x78c DBC 0x144cfc4 Jet'.

This error can happen for a number of reasons the main reason being if the path to the database is incorrect.

You need to check that the path to the database is correct (You must use the physical path on the server to the database and not a virtual path).

The error is also quite common if the permissions on the server are incorrect. Check that IIS has sufficient permissions to access the registry and that the correct permissions, read and write, are set on the directory containing the database and the database itself, for the IUSR account.

Could not find file
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\Inetpub\wwwroot\databaseName.mdb'.

This error is more or less what it says, the database file can not be found. This usually occurs if the path to the database is incorrect.

You need to check that the path to the database is correct (You must use the physical path on the server to the database and not a virtual path).

Could not use '(unknown)'; file already in use
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

This is a bit of an odd error that I have never received myself but have been asked about on number of occasions. It usually means that either incorrect permissions are set on the server or the incorrect version of MDAC (Microsoft Data Access Components installed on the server or the version is not correctly installed). You need to ensure the ODBC version you have is 4 or greater.

If you are running the web server yourself then read the FAQ, Checking and Setting up the Correct Permissions on the Server and the FAQ on, Checking you have the correct ODBC Access Database Drivers.

If you are not running the server yourself you will need to contact your web space provider and ask them how to sort the problem out.

Another reason for this error is that you have the database already open in MS Access or another program, if this is the case shut down the other program you have the Access database open in.

Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'
Microsoft JET Database Engine error '80004005'
Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'.

This error means that you are either unable to open the table or that you already have the table open in 'Design View' in Microsoft Access. Close Access and try again.

Too few parameters. Expected 1
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

This error occurs only with Microsoft Access when one of the field names used in a select statement does not exist in the table being queried.

Check that your SQL query is correct and that you have not misspelled any of the field names in your select statement and that the field name exists in the table being queried.

Either BOF or EOF is True, or the current record has been deleted
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.

This is a recordset error. It means that you have tried to read into a variable or display in a web page a record from the recordset that has either been deleted or does not exist.

The most common occurrence of this error is if you have run a database query that has not returned any records and you have then tried to read in a record from the recordset that contains no data.

You need to first check that there is a record in the recordset before reading it in (eg. 'If NOT rsRecordSet.EOF Then').

Item cannot be found in the collection corresponding to the requested name or ordinal
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.

This like the error above is a recordset error. You have tried requesting a field from the recordset that does not exist.

Check when you are reading in the field from the recordset into a variable or to display in a web page that you have spelt the field name correctly and that the field exists in the database.

The search key was not found in any record.
Microsoft JET Database Engine (0x80004005)

The search key was not found in any record.
This error often means that the database has become corrupted.

The solution to this is to repair the database. If the database is on a remote server download the database and follow the instructions below to repair the database.

Access 2000, XP, and 2003 Compact and Repair Database

Open the database in Microsoft Access, click on the 'Tools' menu and select 'Database Utilities -> Compact and Repair Database'.

Access 2007 Compact and Repair Database
Open the database in Microsoft Access, click on the 'Office Button' in the top left corner then select 'Manage -> Compact and Repair Database'.

Click for more (Err:80040E14 Syntax errors)

#1054 - Unknown column '' in 'field list'

#1054 - Unknown column '' in 'field list'

Solution:Hi there, I had the same issue and it was doing my head in!

I found the cause though; it is to do with using grave accents instead of straight quote
mark/apostrophes in the query.

e.g. `NULL` instead of 'NULL'

I had the problem when I copied and pasted a list of fields from an SQL manager.

I hope this works

Enable eAccelerator delivered with XAMPP

How do I activate the eaccelerator in XAMPP?

Solution:

Open the “php.ini” file in the directory \xampp\apache\bin\php.ini. & for Linux: /opt/lampp/etc/php.ini
Here activate the following lines by removing the semicolon in each line in the [eAccelerator] section:

extension=eaccelerator.dll
eaccelerator.shm_size = “0″
eaccelerator.cache_dir = “\xampp\tmp”
eaccelerator.enable = “1″
eaccelerator.optimizer = “1″

After that, restart the Apache HTTPD!

XL97: Cannot Drag Page Breaks in Page Break Preview

SYMPTOMS
You are not able to drag page breaks in Page Break Preview, although you receiv...
You are not able to drag page breaks in Page Break Preview, although you receive a dialog box indicating that you can.
Back to the top
CAUSE
This problem may occur when the Allow cell drag and drop check box on the Edit...
This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared.
Back to the top
WORKAROUND
To work around this problem, select the Allow cell drag and drop check box: On...
To work around this problem, select the Allow cell drag and drop check box:

1. On the Tools menu, click Options.
2. On the Edit tab, click to select the Allow cell drag and drop check box, and click OK.

Back to the top
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that ar...
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top
REFERENCES
For more information about moving page breaks, click Contents and Index on the...
For more information about moving page breaks, click Contents and Index on the Help menu, click the Index tab in Excel Help, type the following text
page breaks, moving
and then double-click the selected text to go to the "Insert or move a page break" topic. If you are unable to find the information you need, ask the Office Assistant.

Create folder area image for xp

copy the following to notepad

[{BE098140-A513-11D0-A3A4-00C04FD706EC}]
iconarea_image="image file path and name "
iconarea_text=0x00000000

insert the path of your image after the iconarea_image (with the quotations)

eg:-
[{BE098140-A513-11D0-A3A4-00C04FD706EC}]
iconarea_image="E:\Pictures\SG1.jpg "
iconarea_text=0x00000000

if the picture is in the same folder only the image name will do.

the 'iconarea_text=0x00000000' will set the text colour of the icons.
the last six numbers are the colour in hex

eg:- 000000 = black
FFFFFF = White
0000FF = blue

iconarea_text=0x00000000 this will set the text colour to black

iconarea_text=0x00000000 this will set the text colour to white

save the file as "Desktop.ini"

then close the folder and go to Start-Run

type
Attrib +s "Your folder path and name"

eg:- Attrib +s "E\Stargate"

Then go to your folder and check it out.

Customise default fonts in DreamWeaver

You can specify which font and size to be used for the default Proportional font, Fixed font, and Code view. To do this:

1. Select Edit | Preferences to bring up the Preferences dialog box

2. From the Category column, select Fonts

3. Under the Fonts section, from the Font settings list, select the Proportional font, Fixed font, and/or Code view using the pull-down lists to select the desired font and size.

4. Click OK

Create Email ID Images

To create images of your email ID as the one shown below click on the below link.

link

Writing to the Window

Being able to generate an entirely new page from the code of an existing page has advantages. You don't need to create a whole new page for each of your popups, and so the popup content is already loaded when the main page is. First, let's » generate a page.

function dirtypop()

{

  var generator=window.open('','name','height=400,width=500');

  generator.document.write('<html><head><title>Popup</title>');

  generator.document.write('<link rel="stylesheet" href="style.css">');

  generator.document.write('</head><body>');

  generator.document.write('<p>This page was generated by

    the main window.</p>');

  generator.document.write('<p><a href="javascript:self.close()">

    Close</a> the popup.</p>');

  generator.document.write('</body></html>');

  generator.document.close();

}

<a href="javascript:dirtypop();">Generate!</a>

As you can see, we create a new window as a variable again, and then use the variable name in place of window (which normally comes before document) to write directly into it. The document.close() method at the end is not the same as window.close() — in this case it signifies that we've stopped writing to the window. Note that any stylesheet information you have on your main page is not carried through to the popup; you must write the style information into the popup code.

Generating windows like this does bring some problems. For one, the URL of the page is really up to the browser. Some leave it as 'undefined' or 'blank', while others just give it the URL of the main window, which brings up all sorts of issues. You can check what your browser reckons the URL is with the view URL link I added to the window above. Thankfully, while some browsers see the popup as a conjoined part of the same page, self.close() will always close just the popup, not its parent window.

Accessible Popups

Throughout the examples above I've been using the javascript: link style. This is an easy way to execute JavaScript functions, instead of linking to a dummy anchor and using event handlers, as in

<a href="#" onClick="poptastic('page.html');">Pop it</a>

For modern browsers we can write

<a href="javascript:poptastic('page.html');">Pop it</a>

This is an easy way to show popups in action, but is not the recommended way of actually doing popups for real. Creating popups using the javascript: mechanism is bad for two reasons:

1. Users using browsers that don't support JavaScript (or who have disabled JavaScript) won't be able to follow these links, and so will miss the potentially vital information contained in your popups.
2. Most browsers allow you to right click a link and either open it in a new window or a new tab. Since these links don't have proper href values, they'll open blank windows, which can be very annoying.

To this end, there is a more gracefully degrading method of linking to popups, which allows the links to work both ways. The ideal version of the above link is

<a href="page.html" onClick="poptastic(this.href); return false;">Pop it</a>

This will create a link that opens the popped page as a normal page in a non-JavaScript browser. In a modern browser this default action is suppressed (by return false) and the page is popped up as you want it. The URL you're opening is set as this.href, which tells JavaScript to look at the href value of the current link and use that, meaning you don't have to write the same URL twice. » Try it here. You should always code your popups like this, so nobody is left out.

Opening New Windows

Opening new windows is easy enough in plain old HTML, using the target attribute on your links, like so:

<a href="example.html" target="_blank">link text</a>

This will open the new page in a new window, and is perfect for most people’s needs. However, if you want more control over this new window, you will need to use some JavaScript code. To get a rudimentary page to pop up off your main page on command from a link, you'll need the following JavaScript code and JavaScript link:

var newwindow;
function poptastic(url)
{
    newwindow=window.open(url,'name','height=400,width=200');
    if (window.focus) {newwindow.focus()}
}

<a href="javascript:poptastic('poppedexample.html');">Pop it</a>

We're simply defining a new JavaScript function, which we can pass different URLs to each time. This will open the specified url in a new, downsized window, the dimensions of which are set down in the function. Try it here: » Pop it

The HTML for that link simply called the function with the URL of the page we want to pop up as an argument. It looks like this:

<a href="javascript:poptastic('/examples/poppedexample.html');">Pop it</a>

We load the new window (created with the window.open() method) into a variable. This method then takes three arguments: the address of the new page, the name of the window, and a third argument which can hold some, few, or less optional attributes of the window, such as the height and width which I've defined in this case.

The url we're using is passed to the function when we call it, so that this function can be used for any number of different popups (though the height/width and other options will always be the same unless you modify the function to take more arguments). Some browsers prohibit the opening of pages on another server for security reasons, so test your script. The name we specify will be used to open further pages into this new window.
The Arguments

You have a number of options for the third argument. When you define any of them, the remaining Boolean values (which can be true/false or yes/no or 1/0) are all set to false/no/0. Whichever you choose to use, all of your options go into the same quoted string, with commas between the values, and no spaces are allowed between them.

height
    Defines the height of the window in pixels. Percentage values don't work.
width
    Defines the width. Again, you'll have no joy with percentages.
left
    Supported by version 4 browsers and above, this sets how far removed the window appears from the left of the screen. In pixels.
top
    Partner to left, this pushes the window off the top of the screen.
resizable
    Set to true or false, this may allow the user to resize the window.
scrollbars
    Another Boolean value, this adds scrollbars to the new window. If your content may be longer then the dimensions you've specified, make sure this is set to yes.
toolbar
    Specifies whether the basic back/forward toolbar should be visible. If there are links to follow in your new page, set this to yes.
menubar
    Specifies whether the main toolbar (File, Edit, ...) is shown.
location
    Specifies whether the location toolbar (address bar) is shown.
status
    Specifies whether the new window can have a status bar. Best set to yes. For security reasons, Mozilla-based browsers always show the status bar.
directories
    Specifies whether the directories toolbar is shown (Links toolbar in IE).
fullscreen
    Internet Explorer-only Boolean attribute which may open the window in fullscreen. It's annoying — don't use it.
dependent
    Netscape 4-only attribute which makes the popup dependent on the status of the main window. If the main window is closed, the popup closes with it.
screenX & screenY
    Old Netscape attributes for defining the window's position on the page. Use left and top in their place.

So, a fully kitted-out new window might look more like this:

newwindow=window.open(url,'name','height=500,width=400,left=100,
  top=100,resizable=yes,scrollbars=yes,toolbar=yes,status=yes');

Focusing and Closing

Two vital little tricks can make your popups infinitely more usable. Firstly, in our function at the start of this page, we executed the following code once the window had been created:

if (window.focus) {newwindow.focus()}

First we check whether the focus() method is supported — this is vital to stop JavaScript errors. If it is, we set the browser's focus on the new window, so that as soon as it is affected it is at the front of the display. While the browser always gives new windows the focus when they're first created, it doesn't refocus when you send another page to a window that's already open. Omitting this method may leave your new window hidden behind the main window, depending on what else is happening at the time.

Adding the option to close the window is just good practice and you should always add it to your popups. From the main window, we write

<a href="javascript:if (newwindow) newwindow.close()">Close</a> the popup.

First checking if the popup is open (the if() statement checks if the variable has a value), and then using the close() method. Try it here: close the window.

From inside the popup itself, the code is simply

<a href="javascript:window.close()">Close</a> this popup.
Linking to Windows

Once you have popped a window open, you can direct further links into it with the target attribute. If we have defined name to be 'popsome', we can make links open into this window with

<a href="page.html" target="popsome">Link</a>

If the popup window has already been closed your browser will open a new, normal window, and set its name to whatever you've specified as the value of target. Try it with these: Open and then open a new link inside it. Then close.

Contact me

For any IT queries or business related queries contact me

Shiva Prasad
Engineer IT Services
Bangalore

Email me: shivprasad.p@gmail.com

logos

Rounded corners for images

This is a nice photo, sure. It looks good. But immediately noticed are those sharp, boxy corners. The image appears raw and untouched. With powerful tools such as Photoshop, there is no reason this image can’t be enhanced.

By simply adding curved corners, this image will immediately become more warm and appealing.

The process

Within Photoshop, take a look at the Layers palette. The photo should be on it’s own layer, and we’re going to create another layer right on top of that.

On this layer, we are going to draw a rectangle, with the rounded rectangle tool.

Draw the rectangle on the new layer you created.

It doesn’t matter what the fill color is right now. Just try to center the rounded rectangle as best you can. Essentially, whatever falls inside this rectangle will be included in the picture.

Now, go back to the Layers palette, and select the layer that you just drew the rounded rectangle on. Double click on that layer.

The Layer Style palette should open up.

In the Advanced Blending area, slide the Fill Opacity percentage down to 0%.


Back in the Layers palette, click on the Paths tab.


With the current Path selected, click on the little arrow button, in the upper right corner of the Layers palette, and select "Make Selection..." from the select list.



In the "Make Selection" option box, make sure Feather Radius is set to 0 pixels, and Anti–aliased IS checked.


Hit OK. You should get a nice, smooth selection of the rounded rectangle that you created.

Almost done

Now, with the selection still pending action, go to Edit, Copy Merged. Create a new document, and leave the dimensions alone (they should reflect the copy you just made). In the new document, go to Edit, Paste. There you go!

The image should now have nice, smooth corners, instead of the sharp, boxy ones it had before.

Icons smilies for web apps

How to install Photoshop Brushes

First of all, be sure that Photoshop is CLOSE. Installing .ABR files could not be much easier. You simply need to copy the file to the correct directory. If you downloaded the brush set in a zip file, you can just extract the 'abr' file straight to the right place. That "right place" is in the 'Presets' directory of your main Photoshop program folder, under the subdirectory 'Brushes'. For example, using the default installation path for Photoshop CS2, my brushes reside here:

C:\Program Files\Adobe\Adobe Photoshop CS2\Presets\Brushes\

How to install Photoshop Gradients

First of all, be sure that Photoshop is CLOSE.
Installing .GRD files could not be much easier.
You simply need to copy the file to the correct directory.
If you downloaded the gradient set in a zip file, you can just
extract the 'grd' file straight to the right place.
That "right place" is in the 'Presets' directory of your main
Photoshop program folder, under the subdirectory 'Gradients'.
For example, using the default installation path for Photoshop CS2, my
gradients reside here:
C:\Program Files\Adobe\Adobe Photoshop CS2\Presets\Gradients\

Simply copy the file there, and the next time you start Photoshop,
the gradients will be available from your gradients set menu.

How do I install or upgrade an RPM file

• How can I install or upgrade an RPM package under CentOS / RHEL / Fedora / Suse Linux?

A. To install or upgrade an rpm file or package you need to use rpm command. RPM is a RPM Package Manager (originally called Red Hat Package Manager). Both Novell Suse Linux and Red Hat Linux support (Fedora Linux) uses rpm.

To install an rpm you need to use following command (you must be a root user i.e. login as a root user):

# rpm -ivh package.rpm

To upgrade an rpm package you need to use rpm command as follows:

# rpm -Uvh package.rpm

Red Hat enterprise Linux user can use up2date command to install or update package over Internet:

# up2date -i package-name

Fedora Linux user, use yum command to install or update package over Internet:

# yum install package

Fedora Linux Update package:

# yum update package

Customise Application Dirctory in Apache-Tomcat 6.0.16

In server.xml in ${catalina.base} has the <Host> customized asà <Host name="localhost" appBase="D:/Work/IPV/IPV/emptyDir" autoDeploy="false"> <Context path="/" docBase="c:/work/IPV/IPV/site"/> </Host>

For default webapps <Host> tag is as shown belowà <Host appBase="webapps" autoDeploy="true" name="localhost" unpackWARs="true" xmlNamespaceAware="false" xmlValidation="false">         <!-- SingleSignOn valve, share authentication between web applications              Documentation at: /docs/config/valve.html -->         <!--         <Valve className="org.apache.catalina.authenticator.SingleSignOn" />         -->         <!-- Access log processes all example.              Documentation at: /docs/config/valve.html -->         <!--         <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"                 prefix="localhost_access_log." suffix=".txt" pattern="common" resolveHosts="false"/>         --> <Context path="webapps" docBase="C:/xampp/webapps"          debug="0">   <!-- Link to the user database we will get roles from -->   </Context> </Host>