keskiviikko 12. syyskuuta 2007

Loop through HTML tags and change theirs attributes with Javascript

Idea behind this is to get all images of current webpage and change the picture shown with Javascript.

<html>
<head>
<title>Looping through IMG-tags example</title>
<script type="text/javascript">
function getImages()
{
var images = document.getElementsByTagName("IMG");
var numOfImages = images.length;
var origImage;
for(i=0;i<numOfImages;i++)
{
origImage = images[i].src;
images[i].src="http://www.google.com/ig/images/igoogle_logo_sm.gif";
images[i].alt="Original image used is " + origImage;
}
}
window.onload = getImages;
</script>
</head>
<body>
<img src="http://www.lo.fi/goo.gif" height="55" width="166">
<img src="http://www.lo.fi/gaa.gif" height="55" width="166">
</body>
</html>

How to connect to Ingres 2 database, another way

sql vnode::databasename

Standard Ingres SQL style.
http://docs.ingres.com/connectivity/UsingNet

How to connect to Ingres 2 database

qbf vnode::databasename -t tablename

-t parameter can be used to connect directly to specific table.
F10 is general *back button*
TAB to move forward in columns.
CTRL+P to move previous column.

lauantai 8. syyskuuta 2007

asp test 2

<%=response.write("Hi!") %>

tiistai 4. syyskuuta 2007

Basic Confirm box with Javascript

// Basic Confirm box with Javascript
if (confirm("Do you want to continue?")) {
alert("Yes, you do!");
}
else {
alert("Nah, you don't..");
}

Paste this to external.js -file and call it from HTML page like this

<head>
<script language="javascript" type="text/javascript" src="external.js">
</script>
</head>

language="javascript" is not recommended anymore by W3C. Use only type="text/javascript".

How to add sum field to MS ACCESS Report

http://office.microsoft.com/en-us/access/HA011224441033.aspx

=Sum([SomeSumField])

How to handle NULLS with IsNull()

Two ways to handle null values in Forms.

If IsNull(Me.StartDate) Then
Me.StartDate = "1.1.1899"
End If

If IsNull([Forms]![AddForm1]![EndDate]) Then
[Forms]![AddForm1]![EndDate] = "1.1.1899"
End If