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
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
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
- 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.
- 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.
- 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.
<%
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
Examples for Alternating Table Row Colors
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
<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)
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
<%
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
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
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)
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
- 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.
- 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.
- 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.
- Click the Microsoft Office Button and then click Save, or press CTRL+S.
- On the Home tab, in the Views group, click View, and then click Design View.
- In the Field Name column, click your new field.
- Under Field Properties, on the General tab, click in the Default Value property box, and then type Now() or Date().
- Click the Show Date Picker property box, and then select Never from the list.
- 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
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
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 engineFor existing objects with names that contain reserved words, you can avoid errors by surrounding the object name with brackets ([ ]).
MORE INFORMATION
-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:
Source:http://support.microsoft.com/kb/286335
Active Server Pages (ASP) Access Database Errors
Common Access Database Errors
- Cannot update. Database or object is read-only
- Operation must use an updateable query
- General error Unable to open registry key
- Could not find file
- Could not use '(unknown)'; file already in use
- Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'
- Too few parameters. Expected 1
- Either BOF or EOF is True, or the current record has been deleted
- Item cannot be found in the collection corresponding to the requested name or ordinal
- 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.
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.
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'.
Could not find file
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\Inetpub\wwwroot\databaseName.mdb'.
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.
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'.
Too few parameters. Expected 1
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
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.
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.
The search key was not found in any record.
Microsoft JET Database Engine (0x80004005)
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.
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'
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
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
[{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
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.
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
Shiva Prasad
Engineer IT Services
Bangalore
Email me: shivprasad.p@gmail.com
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.
How to install Photoshop Brushes
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.