All tricks on da WWWeb

Search meta data of SQL, Oracle + Source code w/ Google Deskbar+GPLEX

2006-04-18T00:42:00.000-07:00

The Gplex Database and source code crawler
– Search all the metadata in your SQL, Oracle and now
DB2 (beta) databases and source code (*.cpp, *.asp, *.js, *.cs, etc.) :

GplexDB crawls and indexes all your SQL, Oracle and DB2(beta)
databases for Functions,

Triggers, Procedures, Tables, Columns, Views, Packages and Procedures and your source
code

all of which are searchable from a single interface.
Try the Gplex Crawler

Unlike competitive search solutions which require large upfront investment, the
Gplex Database Search is an easy to use, downloadable product that delivers high
quality search results for an free. And since Gplex Database and Source Code
crawler is open source you can modify it and tweak it to your needs.

How many times have you searched your database and source
to find a particular error message or field that is used in a procedures or package
and forgotten where in your database or source code a particular field is being
used?

How much faster could your new employees become productive if there was a
consolidated searchable view of your source code and databases metadata so that
they could find the package, trigger, procedure, function instantly and on demand?

Meet the Gplex Database and Source Crawler. Designed to help
any business make the most of their employees, the Gplex Database is a software
search product that delivers the power and productivity of searching across your
organization’s databases and source code independent of your backend being Oracle,
SQL, DB2 and regardless of what programming language you use.

The Gplex Database and Source Code Crawler:

Can be searchable immediately
while it completes indexing of your databases and sources.

Free to use, and with the source
code avaliable for download you are free to modify and use it.

Windows - RUN command shortcuts

2006-04-18T00:20:00.000-07:00

RUN command shortcuts

I know there are a lot of people who love using the run prompt or the command prompt rather than using the mmc control ... So here are some quick tips that you can use ... Enjoy ...

Accessibility Controls : access.cpl

Add Hardware Wizard : hdwwiz.cpl

Add/Remove Programs : appwiz.cpl

Administrative Tools : control admintools

Automatic Updates : wuaucpl.cpl

Bluetooth Transfer Wizard : fsquirt

Calculator : calc

Certificate Manager : certmgr.msc

Character Map : charmap

Check Disk Utility : chkdsk

Clipboard Viewer : clipbrd

Command Prompt : cmd

Component Services : dcomcnfg

Computer Management : compmgmt.msc

Date and Time Properties : timedate.cpl

DDE Shares : ddeshare

Device Manager : devmgmt.msc

Direct X Control Panel (If Installed)* : directx.cpl

Direct X Troubleshooter : dxdiag

Disk Cleanup Utility : cleanmgr

Disk Defragment : dfrg.msc

Disk Management : diskmgmt.msc

Disk Partition Manager : diskpart

Display Properties : control desktop

Display Properties : desk.cpl

Display Properties (w/Appearance Tab Preselected) : control color

Dr. Watson System Troubleshooting Utility : drwtsn32

Driver Verifier Utility : verifier

Event Viewer : eventvwr.msc

File Signature Verification Tool : sigverif

Findfast : findfast.cpl

Folders Properties : control folders

Fonts : control fonts

Fonts Folder : fonts

Free Cell Card Game : freecell

Game Controllers : joy.cpl

Group Policy Editor (XP Prof) : gpedit.msc

Hearts Card Game : mshearts

Iexpress Wizard : iexpress

Indexing Service : ciadv.msc

Internet Properties : inetcpl.cpl

IP Configuration (Display Connection Configuration) : ipconfig /all

IP Configuration (Display DNS Cache Contents) : ipconfig /displaydns

IP Configuration (Delete DNS Cache Contents) : ipconfig /flushdns

IP Configuration (Release All Connections) : ipconfig /release

IP Configuration (Renew All Connections) : ipconfig /renew

IP Configuration (Refreshes DHCP & Re-Registers DNS) : ipconfig /registerdns

IP Configuration (Display DHCP Class ID) : ipconfig /showclassid

IP Configuration (Modifies DHCP Class ID) : ipconfig /setclassid

Java Control Panel (If Installed) : jpicpl32.cpl

Java Control Panel (If Installed) : javaws

Keyboard Properties : control keyboard

Local Security Settings : secpol.msc

Local Users and Groups : lusrmgr.msc

Logs You Out Of Windows : logoff

Microsoft Chat : winchat

Minesweeper Game : winmine

Mouse Properties : control mouse

Mouse Properties : main.cpl

Network Connections : control netconnections

Network Connections : ncpa.cpl

Network Setup Wizard : netsetup.cpl

Notepad : notepad

Nview Desktop Manager (If Installed) : nvtuicpl.cpl

Object Packager : packager

ODBC Data Source Administrator : odbccp32.cpl

On Screen Keyboard : osk

Opens AC3 Filter (If Installed) : ac3filter.cpl

Password Properties : password.cpl

Performance Monitor : perfmon.msc

Performance Monitor : perfmon

Phone and Modem Options : telephon.cpl

Power Configuration : powercfg.cpl

Printers and Faxes : control printers

Printers Folder : printers

Private Character Editor : eudcedit

Quicktime (If Installed) : QuickTime.cpl

Regional Settings : intl.cpl

Registry Editor : regedit

Registry Editor : regedit32

Remote Desktop : mstsc

Removable Storage : ntmsmgr.msc

Removable Storage Operator Requests : ntmsoprq.msc

Resultant Set of Policy (XP Prof) : rsop.msc

Scanners and Cameras : sticpl.cpl

Scheduled Tasks : control schedtasks

Security Center : wscui.cpl

Services : services.msc

Shared Folders : fsmgmt.msc

Shuts Down Windows : shutdown

Sounds and Audio : mmsys.cpl

Spider Solitare Card Game : spider

SQL Client Configuration : cliconfg

System Configuration Editor : sysedit

System Configuration Utility : msconfig

System File Checker Utility (Scan Immediately) : sfc /scannow

System File Checker Utility (Scan Once At Next Boot) : sfc /scanonce

System File Checker Utility (Scan On Every Boot) : sfc /scanboot

System File Checker Utility (Return to Default Setting) : sfc /revert

System File Checker Utility (Purge File Cache) : sfc /purgecache

System File Checker Utility (Set Cache Size to size x) : sfc /cachesize=x

System Properties : sysdm.cpl

Task Manager : taskmgr

Telnet Client : telnet

User Account Management : nusrmgr.cpl

Utility Manager : utilman

Windows Firewall : firewall.cpl

Windows Magnifier : magnify

Windows Management Infrastructure : wmimgmt.msc

Windows System Security Tool : syskey

Windows Update Launches : wupdmgr

Windows XP Tour Wizard : tourstart

Wordpad : write

Source: Vinod Kumar's Blog

blueshoes php application framework and php cms

2006-03-23T23:47:00.000-08:00

Blueshoes PHP Application framework and php cms

contains lotsa wonderful JavaScript components..
http://www.blueshoes.org/en/javascript/

Complete list of MSDN: RSS Feeds

2006-03-16T22:44:00.000-08:00

About MSDN: RSS Feeds
http://msdn.microsoft.com/aboutmsdn/rss/

OpenSource - Rich Internet Application Development Platform - WOW!!

2006-03-15T22:07:00.000-08:00

OpenLaszlo Overview

OpenLaszlo is the leading open source platform for the development and delivery of rich Internet applications on the World Wide Web.

Cinematic user experience

Applications developed on OpenLaszlo provide a dramatically improved online user experience featuring advanced interfaces delivered on a single Web page. By bringing true application behavior to the Web, OpenLaszlo makes a new generation of online communications, commerce and content services viable for the first time. (more...)

Rapid XML development approach

OpenLaszlo applications are written in LZX, a standards-driven XML and JavaScript description language that enables a declarative, text-based development process. LZX supports rapid prototyping, collaborative software development and long term code maintenance. (more...)

Scalable deployment architecture

Depending on requirements, OpenLaszlo applications can be deployed either SOLO (Standalone OpenLaszlo Output) or from the OpenLaszlo Server. SOLO deployment supports most use cases and works from any HTTP Web server. OpenLaszlo Server deployment supports additional data integration options, persistent connections and run-time media transcoding. The OpenLaszlo server is Java-based and works with leading J2EE application servers and Java Servlet Containers. OpenLaszlo's standards-based architecture delivers exceptional reliability and scalability, proven in deployments serving millions of users to date. (more...)

Benefits

Develop standards-based rich Internet Applications that support any web browser with a single code base in XML and JavaScript

Deploy them from any HTTP Web server in SOLO mode, or from a J2EE application server or Java servlet container running the OpenLaszlo Server under Linux, UNIX, Windows or Mac OS X

Display them in any Web browser enabled with the Flash 6 Player or above, reaching 96% of all Web-enabled desktops

Architecture

The OpenLaszlo SDK consists of a compiler written in Java, a runtime JavaScript library, and an optional Java servlet that provides additional services to the running application.

Architecture | OpenLaszlo

Flash ads disabled in IE (on applying latest IE update)

2006-03-07T01:07:00.000-08:00

Flash ads disabled inIE

I have downloaded the patch. It is not as bad as I thought it was going to be. For me, all flash ads still show. To interact with the flash ads, you have to click on them first.

Posted by Michael | 1:28 pm on March 3, 2006.

How is it that this may just affect flash ads? What about flash of any kind on a site?

Posted by Andrew | 1:33 pm on March 3, 2006.

The following table lists the DTHML events that are blocked when ActiveX controls are inactive.

onactivate ondragleave onmouseout
onbeforeactivate ondragover onmouseover
onbeforecopy ondragstart onmouseup
onbeforecut ondrop onmousewheel
onbeforedeactivate onfocus onmove
onbeforepaste onfocusin onmoveend
onblur onfocusout onmovestart
onclick onhelp onpage
oncontextmenu onkeydown onpaste
oncontrolselect onkeypress onresize
oncopy onkeyup onresizeend
oncut onlosecapture onresizestart
ondblclick onmousedown onscroll
ondeactivate onmouseenter onselectstart
ondragend onmouseleave
ondragenter onmousemove

Posted by Developer | 3:04 pm on March 3, 2006.

There is a work around to this which eliminates the extra click. If the OBJECT tag is written to the page by JavaScript it will bypass the extra click. HOWEVER. The document.write must be contained in an external JS file. It can not be inline with the code.

Posted by Jeff | 3:25 pm on March 3, 2006.

The suggestions already posted in these comments rein in the most common workarounds to the IE update, and you can find more information and resources to help address the change published at the URL below.

http://www.macromedia.com/devnet/activecontent/

Note- this behavioral change in IE is not specific to Flash, but any embedded ‘active content’, for the record (applets, Quicktime movies, etc.).

As suggested earlier, putting the object/embed tag in a document.write() call within an external Javascript file (and then including that JS file in your HTML doc) will remove the need for a user click to activate the control. By parameterizing your external JS file/functions, it could also be reused by passing in references to different SWF movies, requiring only one external JS file across multiple resources.

Hope this helps out.

Posted by Scott Fegette | 4:28 pm on March 3, 2006.

There’s a few Javascript methods of embedding Flash that fix this…

I’ve been tracking the issue here.

Posted by Geoff | 11:49 am on March 5, 2006.

So - Would all the publishers ask people to download Firefox… to protect their revenues?

flash like dhtml based image-zoom menu (list of links)

2006-02-13T23:20:00.001-08:00

Wonderful dhtml based image zoom navigation.. looks like flash..!!

// LinkDock - V 1.4
// By Brian Gosselin of http://scriptasylum.com
// Release Info:
// V 1.0 - Initial release.
// V 1.1 - Minor code changes for magnification smoothness and accuracy.
// V 1.2 - Added option to include text under the links as they are hovered over.
// Fixed a magnification bug when the page is too small to fit the whole menu.
// V 1.3 - Fixed a bug where you get script errors if you hover over an image before the
// page finishes loading.
// V 1.4 - Added a tweak by RAJ to smoothen the entry into the menu.

// ENTER LINK ATTRIBUTES IN THE ARRAY BELOW; EACH LINE CONTAINS ALL THE
// PARAMETERS FOR ONE LINK. USE THE FOLLOWING FORMAT:
// [ 'LINK_URL' , 'IMAGE_URL' , 'URL_TARGET', 'TEXT_UNDER_LINK' ]
// VALID VALUES FOR 'URL_TARGET' ARE:
// '_blank' (NEW WINDOW)
// 'name' (THE NAME OF AN EXISTING WINDOW OR FRAME)
// '' (CURRENT PAGE)
// IF YOU DO NOT WANT TEXT DISPLAYED UNDER A LINK, SIMPLY USE AN EMPTY STRING AS THE PARAMETER FOR 'TEXT_UNDER_LINK'.

var linkList=[
[ 'index.html' , 'images/home.gif' , 'content', 'Home Page' ],
[ 'people.html' , 'images/people.gif' , 'content', 'Friends & Family' ],
[ 'hobbies.html' , 'images/hobbies.gif' , 'content', 'My Interests' ],
[ 'win98.html' , 'images/windows98.gif' , 'content', 'Windows 98 Hints & Tricks' ],
[ 'winxp.html' , 'images/windowsxp.gif' , 'content', 'Windows XP Hints & Tricks' ],
[ 'funny.html' , 'images/thoughts.gif' , 'content', 'Random Thoughts' ],
[ '../fsguestbook.html' , 'images/gbpresent.gif' , 'content', 'Sign & View My Guestbook' ],
[ 'oldguestbook.html' , 'images/oldgb.gif' , 'content', 'Past Guestbook Entries' ],
[ '../index.html' , 'images/sa.gif' , '_top', 'My Javascript/DHTML site...' ]
//[ 'mailto:scriptasylum@hotmail.com' , 'images/email.gif' , 'content', 'Contact Me...' ]
]

// CHANGE THE OTHER VALUES BELOW TO SUIT YOUR APPLICATION

var startSize=50; // THE STARTING WIDTH *AND* HEIGHT OF EACH IMAGE (THE IMAGES WILL BE SCALED).
//
var endSize=100; // THE ENDING WIDTH *AND* HEIGHT OF EACH IMAGE (THE IMAGES WILL BE SCALED).
var useText=true; // true = USE TEXT UNDER THE LINK, false = NO TEXT UNDER THE LINK.
var defText='Hover over a link...' // DEFAULT TEXT TO APPEAR UNDER THE LINKS WHEN NOT HOVERED OVER.
// USE AN EMPTY STRING FOR NO TEXT.
var textGap=10; // PIXEL GAP FROM BOTTOM OF MENU TO TOP OF OPTIONAL TEXT (WHEN defText IS SET TO true).
var effectW=3.5; // THE NUMBER OF ICONS AFFECTED BY OF THE MAGNIFICATION AT ONCE (APPROXIMATE). USE VALUES BETWEEN 2 AND 5.

// BELOW IS THE STYLE-SHEET RULE FOR HOW THE TEXT IS TO BE DISPLAYED. USE VALID CSS RULES.

var textStyle="font-family:verdana; font-size:11pt; color:white; font-weight:bold";

//********** DO NOT EDIT BEYOND THIS POINT **********\

var w3c=(document.getElementById)?true:false;
var ie4=(document.all && !w3c)?true:false;
var ie5=(document.all && w3c)?true:false;
var ns4=(document.layers)?true:false;
var mx=0;
var overEl=false;
var enterEl=false;
var id=0;
var elList=new Array();
var elText;
var pgLoaded=false;
if(defText=='')defText=' ';
effectW=Math.max(2,Math.min(5,effectW))+.5;
var wA=effectW*endSize/2;
var mX=wA/1.5;

function getMxy(v){
mx=(ie5||ie4)?event.clientX:v.pageX;
}

function getEl(s){
if(ns4)return findLayer(s,document);
else return (ie4)?document.all[s]:document.getElementById(s);
}

function getW(e){
return parseInt(e.style.width);
}

function setImgS(i,x){
elList[i].style.width=x;
elList[i].style.height=x;
document.images['linkDockI'+i].width=x;
document.images['linkDockI'+i].height=x;
}

function getL(el){
var x=0;
var sx=(document.all)?document.body.scrollLeft:0;
while(el.offsetParent!=null){
x+=el.offsetLeft;
el=el.offsetParent;
}
return x+el.offsetLeft-sx;
}

function rAll(){
// decrease size of zoomed images gradually
for(i=0;i//
setImgS(i,curSize);
}}}

function dockMagnify(){
var tEl,n1,n2;
//
if(overEl){
for(i=0;itEl=elList[i];
if((getL(tEl)>=mx-wA)&&(getL(tEl)<=mx+wA)){
n1=getL(tEl)+getW(tEl)/2+10;
n2=mx-wA;
//
setImgS(i,Math.max(n1,startSize));
}else setImgS(i,startSize);
}}}

function mOver(){
overEl=true;
clearTimeout(id);
}

function mOut(){
overEl=false;
id=setTimeout('rAll()',100);
}

// FUNCTION TO FIND NESTED LAYERS IN NS4 BY MIKE HALL
function findLayer(name,doc){
var i,layer;
for(i=0;ilayer=doc.layers[i];
if(layer.name==name)return layer;
if(layer.document.layers.length>0)if((layer=findLayer(name,layer.document))!=null)return layer;
}
return null;
}

function writeText(text){
if(useText && pgLoaded){
text=(text<0)?defText:linkList[text][3];
if(text=='')text=' ';
if(ns4){
elText.document.open();
elText.document.write(''+text+'');
elText.document.close();
}
else elText.innerHTML=text;
}}

function writeHTML(){
var t='';
if(w3c||ie4){
t+='
';
for(i=0;it+='';
t+='';
t+='';
}
t+='
';
if(useText)t+='
'+defText+'
';
}else{
t+='';
for(i=0;i';
t+='';
if(useText)t+='';
t+='
';
}
document.write(t);
}

window.onload=function(){
if(w3c||ie4){
for(j=0;jelList[j]=getEl('linkDockD'+j);
elList[j].n=j;
elList[j].onmouseover=mOver;
elList[j].onmouseout=mOut;
}
document.onmousemove=getMxy;
setInterval('dockMagnify()',20);
}
elText=getEl('dockText');
if(ns4)writeText(-1);
pgLoaded=true;
}

writeHTML();

XML/SWF Charts

2006-02-13T23:13:00.000-08:00

XML/SWF Charts

Dynamically Filtering Dropdown Lists in Javascript

2006-01-30T06:39:00.000-08:00

Dynamically Filtering Dropdown Lists in Javascript
By: Justin Whitford

http://evolt.org/node/55035

This article describes a technique that takes input from a form text field and uses it to bring matching options to the top in a dropdown list

Javascript Page search/filter

2006-01-23T02:44:00.000-08:00

Javascript based in-page filter / search (display contents based on search string - on the same page)
http://avantbard.com/~gabe/lab/search_filter_test.html

Javascript Tidy :)

2006-01-23T02:42:00.000-08:00

Windows based tool that cleans / formats / indents Javascript, HTML files..
http://www.snapfiles.com/reviews/JavaScript_Code_Improver/jscode.html

RICO: Javascript for Rich Internet Apps

2005-10-22T02:19:00.000-07:00

http://openrico.org/rico/demos.page?demo=ricoEffectSize.html

Web References

2005-10-22T02:12:00.000-07:00

Javascript for Rich Internet Applications
http://openrico.org/rico/home.page

http://www.zvon.org/index.php?nav_id=references

DOM2:
http://www.zvon.org/xxl/DOM2reference/Output/index.html

JS:
http://www.devguru.com/Technologies/ecmascript/quickref/javascript_index.html

CSS2:
http://www.zvon.org/xxl/CSS2Reference/Output/index.html

Ajax.NET Links

2005-10-22T00:40:00.000-07:00

Ajax .Net : http://ajaxpro.schwarz-interactive.de/
Blog: http://weblogs.asp.net/mschwarz/

Ajax Wikipedia:
http://en.wikipedia.org/wiki/AJAX#Perl

DotnetBips: (Simple apps using AJAX and ASP.Net :
http://www.dotnetbips.com/bdb52d60-1100-43b0-9b80-b765937201e8.aspx?articleid=306

AJAX Discovery: (Recent / popular AJAX web sites)
http://www.blinklist.com/tag/ajax/

http://www.mousewhisperer.co.uk/ajax_page.html

kryogenix.org

2005-08-26T21:39:00.000-07:00

All about latest happenings in web programming..
--> CSS, DOM, DHTML, and other intereseting stuff...

AJAX: toolbox - nice example

2005-08-18T06:48:00.000-07:00

http://www.ajaxtoolbox.com/request/examples.php

The above is created by Matt Kruse

DHTML: flash like img-zoom menu

2005-08-16T02:47:00.000-07:00

Wonderful flash like - image-zoom menu in DHTML!!
http://scriptasylum.com/personal/

MSSQLCity.Com - DB comparison articles

2005-08-07T23:24:00.000-07:00

MSSQLCity.Com comparison articles

This one seems to be straight-fwd and useful:

Feature	SQL Server 2000	Oracle 9i
database name length	128	8
column name length	128	30
index name length	128	30
table name length	128	30
view name length	128	30
stored procedure name length	128	30
max columns per index	16	32
max char() size	8000	2000
max varchar() size	8000	4000
max columns per table	1024	1000
max table row length	8036	255000
max query size	16777216	16777216
recursive subqueries	40	64
constant string size in SELECT	16777207	4000
constant string size in WHERE	8000	4000

--end--

Oracle Unleashed + other web programming tutorials

2005-07-28T04:12:00.000-07:00

Oracle Unleashed

Courtesy: Nkaliape

CSS: Position Is Everything - Modern browser bugs explained in detail!

2005-07-25T05:08:00.000-07:00

/* Position Is Everything */ �� Modern browser bugs explained in detail!

CSS-based Dropdown with a twist

2005-07-25T05:05:00.000-07:00

Menu options unfold in the same horizontal space..
CSS-based Dropdown with a twist

CSS Image Rollover Map ~ Europe ~ Sample

2005-07-25T04:34:00.000-07:00

This is a good "single image based" CSS hover implementation.. VERY GOOD..

CSS Image Rollover Map ~ Europe ~ Sample

Remote control CSS revisited

2005-06-29T23:47:00.000-07:00

Remote control CSS revisited

Wonderful image usage..

CSS : Double Rollover Effect

2005-06-29T23:44:00.000-07:00

Double Rollover Effect

But works only in Mozilla / Firefox (standards compliant browsers ;-)

CSS Animation - 'Film Strip' Technique

2005-06-29T06:46:00.000-07:00

The WPDFD 800 Pixel Stakes

Other Wonderful CSS tricks:
http://www.wpdfd.com/editorial/basics/cssbasics15.html

Hey, this is CSS Heaven...!!!
http://www.dezwozhere.com/links.html

and this one too...
http://www.mezzoblue.com/zengarden/resources/

CSS: Three Columns - Flanking Menus

2005-04-26T23:57:00.000-07:00

Good CSS based layouting technique...

[Three Columns - Flanking Menus]

Bullet Madness ? free bullets project at Stylegala

2005-04-15T06:51:00.000-07:00

Bullet Madness ? free bullets project at Stylegala

Show/Hide Article

The Bullet Madness list:

tis a big-big list..

{style:phreak;} - colormatch redux - Color scheme generator

2005-04-15T06:30:00.000-07:00

{style:phreak;} - colormatch redux

source : http://www.stylephreak.com/index.php/archives/category/resources/

CSS Resources - Stylegala

2005-04-15T03:27:00.000-07:00

Wonderful CSS tricks reference - Stylegala

Send email from Oracle

2005-04-04T06:46:00.000-07:00

Source:
http://www.dba-village.com/village/dvp_papers.ReturnBlob?PaperIdA=812
Show/Hide Article


A 4 step approach to sending email via Oracle, this can be implemented irrespective of the Operating System being used as it works off of Oracle.
==========================
-kailash
==========================

1st Step
---------------------------------------------
From SQLPLUS 
sqlplus /nolog
connect sys/change_on_install as sysdba; 
SQL> call sys.dbms_java.loadjava('-v -r -grant PUBLIC -synonym jaf-1.0.1\activation.jar');
SQL> call sys.dbms_java.loadjava('-v -r -grant PUBLIC -synonym javamail-1.2\mail.jar');
** Important **
**** The next 3 calls are to be executed for each user who needs to be able to send email
SQL> exec dbms_java.grant_permission('SCOTT','java.util.PropertyPermission','*','read,write');
SQL> exec dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect, resolve');
SQL> exec dbms_java.grant_permission('SCOTT','java.io.FilePermission','directory_path','read, write');

-------------------
2nd Step
connect scott/tiger
-----------------------------------------------
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "SendMail" AS
  import java.util.*;
  import java.io.*;
  import javax.mail.*;
  import javax.mail.internet.*;
  import javax.activation.*;
  public class SendMail {
     // Sender, Recipient, CCRecipient, and BccRecipient are comma-separated
     // lists of addresses. Body can span multiple CR/LF-separated lines.
     // Attachments is a ///-separated list of file names.
     public static int Send(String SMTPServer,
                            String Sender,
                            String Recipient,
                            String CcRecipient,
                            String BccRecipient,
                            String Subject,
                            String Body,
                            String ErrorMessage[],
                            String Attachments) {
        // Error status;
        int ErrorStatus = 0;
        // Create some properties and get the default Session;
        Properties props = System.getProperties();
        props.put("mail.akadia.com", SMTPServer);
        Session session = Session.getDefaultInstance(props, null);
        try {
           // Create a message.
           MimeMessage msg = new MimeMessage(session);
           // extracts the senders and adds them to the message.
           // Sender is a comma-separated list of e-mail addresses as per RFC822.
           {
              InternetAddress[] TheAddresses = InternetAddress.parse(Sender);
              msg.addFrom(TheAddresses);
           }
           // Extract the recipients and assign them to the message.
           // Recipient is a comma-separated list of e-mail addresses as per RFC822.
           {
              InternetAddress[] TheAddresses = InternetAddress.parse(Recipient);
              msg.addRecipients(Message.RecipientType.TO,TheAddresses);
           }
           // Extract the Cc-recipients and assign them to the message;
           // CcRecipient is a comma-separated list of e-mail addresses as per RFC822
           if (null != CcRecipient) {
              InternetAddress[] TheAddresses = InternetAddress.parse(CcRecipient);
              msg.addRecipients(Message.RecipientType.CC,TheAddresses);
           }
           // Extract the Bcc-recipients and assign them to the message;
           // BccRecipient is a comma-separated list of e-mail addresses as per RFC822
           if (null != BccRecipient) {
              InternetAddress[] TheAddresses = InternetAddress.parse(BccRecipient);
              msg.addRecipients(Message.RecipientType.BCC,TheAddresses);
           }
           // Subject field
           msg.setSubject(Subject);
           // Create the Multipart to be added the parts to
           Multipart mp = new MimeMultipart();
           // Create and fill the first message part
           {
              MimeBodyPart mbp = new MimeBodyPart();
              mbp.setText(Body);
              // Attach the part to the multipart;
              mp.addBodyPart(mbp);
           }
           // Attach the files to the message
           if (null != Attachments) {
              int StartIndex = 0, PosIndex = 0;
              while (-1 != (PosIndex = Attachments.indexOf("///",StartIndex))) {
                 // Create and fill other message parts;
                 MimeBodyPart mbp = new MimeBodyPart();
                 FileDataSource fds =
                 new FileDataSource(Attachments.substring(StartIndex,PosIndex));
                 mbp.setDataHandler(new DataHandler(fds));
                 mbp.setFileName(fds.getName());
                 mp.addBodyPart(mbp);
                 PosIndex += 3;
                 StartIndex = PosIndex;
              }
              // Last, or only, attachment file;
              if (StartIndex < Attachments.length()) {
                 MimeBodyPart mbp = new MimeBodyPart();
                 FileDataSource fds = new FileDataSource(Attachments.substring(StartIndex));
                 mbp.setDataHandler(new DataHandler(fds));
                 mbp.setFileName(fds.getName());
                 mp.addBodyPart(mbp);
              }
           }
           // Add the Multipart to the message
           msg.setContent(mp);
           // Set the Date: header
           msg.setSentDate(new Date());
           // Send the message;
           Transport.send(msg);
        } catch (MessagingException MsgException) {
           ErrorMessage[0] = MsgException.toString();
           Exception TheException = null;
           if ((TheException = MsgException.getNextException()) != null)
             ErrorMessage[0] = ErrorMessage[0] + "\n" + TheException.toString();
             ErrorStatus = 1;
        }
        return ErrorStatus;
     } // End Send Class
  } // End of public class SendMail
/
----------------------------------------------------------
3rd Step
----------------------------------------------------------
CREATE OR REPLACE PACKAGE SendMailJPkg AS
-- EOL is End of Line character and is used to separate text line in the message body
EOL CONSTANT STRING(2) := CHR(13) || CHR(10);

TYPE ATTACHMENTS_LIST IS TABLE OF VARCHAR2(4000);

-- High-level interface with collections
FUNCTION SendMail(SMTPServerName IN STRING,
Sender IN STRING,
Recipient IN STRING,
CcRecipient IN STRING DEFAULT '',
BccRecipient IN STRING DEFAULT '',
Subject IN STRING DEFAULT '',
Body IN STRING DEFAULT '',
ErrorMessage OUT STRING,
Attachments IN ATTACHMENTS_LIST DEFAULT NULL) RETURN NUMBER;
END SendMailJPkg;
/
CREATE OR REPLACE PACKAGE BODY SendMailJPkg AS
PROCEDURE ParseAttachment(Attachments IN ATTACHMENTS_LIST,
AttachmentList OUT VARCHAR2) IS
AttachmentSeparator CONSTANT VARCHAR2(12) := '///';
BEGIN
-- Boolean short-circuit is used here
IF Attachments IS NOT NULL AND Attachments.COUNT > 0 THEN
AttachmentList := Attachments(Attachments.FIRST);
FOR I IN Attachments.NEXT(Attachments.FIRST) .. Attachments.LAST LOOP
AttachmentList := AttachmentList || AttachmentSeparator || Attachments(I);
END LOOP;
ELSE
AttachmentList := '';
END IF;
END ParseAttachment;

FUNCTION JSendMail(SMTPServerName IN STRING,
Sender IN STRING,
Recipient IN STRING,
CcRecipient IN STRING,
BccRecipient IN STRING,
Subject IN STRING,
Body IN STRING,
ErrorMessage OUT STRING,
Attachments IN STRING) RETURN NUMBER;

FUNCTION SendMail(SMTPServerName IN STRING,
Sender IN STRING,
Recipient IN STRING,
CcRecipient IN STRING,
BccRecipient IN STRING,
Subject IN STRING,
Body IN STRING,
ErrorMessage OUT STRING,
Attachments IN ATTACHMENTS_LIST) RETURN NUMBER IS
AttachmentList VARCHAR2(4000) := '';
AttachmentTypeList VARCHAR2(2000) := '';
BEGIN
ParseAttachment(Attachments,AttachmentList);
RETURN JSendMail(SMTPServerName,
Sender,
Recipient,
CcRecipient,
BccRecipient,
Subject,
Body,
ErrorMessage,
AttachmentList);
END SendMail;

FUNCTION JSendMail(SMTPServerName IN STRING,
Sender IN STRING,
Recipient IN STRING,
CcRecipient IN STRING,
BccRecipient IN STRING,
Subject IN STRING,
Body IN STRING,
ErrorMessage OUT STRING,
Attachments IN STRING) RETURN NUMBER IS
LANGUAGE JAVA
NAME 'SendMail.Send(java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String) return int';
END SendMailJPkg;
/
-----------------------------------------------------------------
4th Step
----------------------------------------------------------------
Test 
sqlplus /nolog
connect scott/tiger 
var ErrorMessage VARCHAR2(4000);
var ErrorStatus NUMBER;

-- enable SQL*PLUS output;
SET SERVEROUTPUT ON
-- redirect java output into SQL*PLUS buffer;
exec dbms_java.set_output(5000);
BEGIN
:ErrorStatus := SendMailJPkg.SendMail(
SMTPServerName => 'localhost',
Sender => 'email_id@domainname',
Recipient => 'email_id@domainname',
CcRecipient => '',
BccRecipient => '',
Subject => 'This is the subject line',
Body => 'This is the body of the mail ' ||
SendMailJPkg.EOL || 'that spans 2 lines',
ErrorMessage => :ErrorMessage,
Attachments => SendMailJPkg.ATTACHMENTS_LIST(
'directory_pat\file_name_to_be_sent_as_attachment'
)
);
END;
/

-kailash

Links: CSS, Accesibility and Standards Links

2005-04-01T00:57:00.000-08:00

Collection of various links on CSS, JS, other web techs

CSS, Accesibility and Standards Links

http://www.artypapers.com/csshelppile/

CSS based : 3-col layout

http://www.tanfa.co.uk/css/layouts/

Wonderful 3 col layout (CSS)

http://www.mezzoblue.com/zengarden/resources/

Nice Link: Web Developer Blog

2005-03-31T04:48:00.000-08:00

Web Developer Blog

Fiftyfoureleven.com - Web Design and Development

2005-03-31T04:28:00.000-08:00

Cool link on XMLHttpRequest -
Fiftyfoureleven.com - Web Design and Development

Tabtastic - CSS tabs example

2005-03-30T04:56:00.000-08:00

Tabtastic

Tabtastic

This library is a simple way to implement tabs on your page using CSS, a little JS, and semantic markup which degrades gracefully on browsers with CSS unavailable or disabled.

Not only is it easy to use and accessible for screen-readers, but it supports multiple (nested, even) tabsets on the same page and allows users to bookmark the page loading to a specific tab.

Specifically, you need to copy one CSS file (tabtastic.css),
one JS file (tabtastic.js),
and three JS library files (AttachEvent.js,

AddClassKillClass.js,

AddCSS.js).

Perl Style

2005-03-29T04:24:00.000-08:00

Wonderful Perl 'Style' coding guidelines

Perl Style

PL/SQL Best Practices - Orafaq Article

2005-03-29T03:34:00.000-08:00

Show/Hide Article

By Irfan Haq

As the discipline of software development evolves, software products grow in
size and the code grows in complexity, the need for a set of guidelines and
standards becomes increasingly evident. In this article I will enumerate some of
the industry best practices that the experts have proposed and emphasized, in
the context of PL/SQL programming.

These best practices improve our data marts, data warehouses and programming
environments by introducing the features like manageability, maintainability and
performance, regardless of the size of organization or the development effort.
The list I have provided is neither exhaustive nor complete and I believe that
producing such a list is very subjective given the fact that each software
development effort and development organization is unique and not all the best
practices are applicable in all situations. Here are some of the more common
suggestions that you will find useful:

Use Anchored Declarations:

As Oracle 10G gains more ground, a term that we will all hear repeatedly is
'self-managing'. Oracle has incorporated features in this version that would
reduce DBA intervention to manage it. It would be nice to introduce some
'self-management' features into the our PL/SQL code as well.

Developers and support personnel alike are faced, quite often, with a
situation where the definitions of the tables have to be altered from one data
type to another. In an ideal world nothing else would need modification.
Realistically, this can break all the PL/SQL code that is based on this table.
Modifying all this code can be a daunting task. Using anchored declarations can
bring our ideal world a step closer to us.

Let's assume we have a table called ITEMS, defined as follows:

Name            Null?           Type        
--------------- ------------  -------- 
ITEM_ID                  NUMBER                          
ITM_DESCRIPTION                 VARCHAR2(60)                          
PRICE                    NUMBER(5,2)                           
QTY                      NUMBER

Also, suppose there is a stored procedure that prints out an alert message
when the quantity of an item in stock falls below a certain limit.

CREATE OR REPLACE PROCEDURE inventory_update (item_id_in IN NUMBER) IS
     v_qty NUMBER;
BEGIN
     SELECT qty into v_qty FROM items WHERE item_id = item_id_in;

IF (v_qty < 10 ) THEN

DBMS_OUTPUT.PUT_LINE ('Warning: Stock low...');

END IF;

END inventory_update;

Figure 1: Anchored Declarations

What happens if we later decide to change the definition for the item_id
field from NUMBER to VARCHAR2(20)? The code above will fail. In order to write
the code in a way that it remains un-effected in the face of the changing data
type of a column, replace the definition for the parameter item_id_in from
NUMBER to an anchored data type items.item_cd%TYPE like this:

CREATE OR REPLACE PROCEDURE inventory_update(item_id_in IN
items.item_id%TYPE) IS

Doing this will cause the code to have the same data type as that of the
column in the table. Your code will work without any modification.

Use BULK Collects:

Performance tuning falls under the realm of DBA duties more than developers.
However, developers have an equal stake in the performance and there is a lot
that can be done at the code-level to achieve this goal. One of these is the use
of bulk collects.

By using bulk collects, we can load multiple rows into the collections rather
than one at a time thus reducing strain on database resources by reducing the
pass to the database. The code segments in figure 2 and figure 3 demonstrate
this point.

CREATE OR replace PROCEDURE no_bulk_proc is
  CURSOR item_cur IS 
     SELECT items.item_id, qty FROM items;
    
  item_rec item_cur%ROWTYPE;
BEGIN
    OPEN item_cur;
    LOOP
        FETCH item_cur INTO item_rec;
        EXIT WHEN item_cur%notfound;
        dbms_output.put_line(item_rec.item_id);
        dbms_output.put_line(item_rec.qty);
    END LOOP;
END no_bulk_proc;

Figure 2: Without using BULK collects

CREATE OR REPLACE PROCEDURE bulk_proc IS
  CURSOR item_cur IS
        SELECT item_id, qty FROM items;
    
  TYPE t_item IS TABLE OF ITEMS.item_id%TYPE INDEX BY BINARY_INTEGER;
  TYPE t_qty IS TABLE OF ITEMS.qty%TYPE INDEX BY BINARY_INTEGER;
  
  v_item t_item;
  v_qty t_qty;
BEGIN
      OPEN item_cur;
      FETCH item_cur bulk collect INTO v_item, v_qty limit 100;
  
      FOR i IN v_item.first .. v_item.last LOOP
            dbms_output.put_line(v_item(i));
            dbms_output.put_line(v_qty(i));
      END LOOP;
  
      CLOSE item_cur;
END bulk_proc;

Figure 3: Using BULK collects

Here the 'limit 100' loads only 100 records into memory for processing which
provides an added benefit that we have reduced the risk of running out of main
memory as opposed to the code in figure 3 which may run into memory issues.

Carefully Select Your Control Structures:

Control flow and conditional statements, if-then-else and loops, are the
basic building blocks of any programming language. Both these structures provide
several different variations and forms to choose from. But in my observation as
a programmer, I have noticed that people grow comfortable with using one kind of
structure only and rarely do a comparison when implementing, especially in case
of loop structures. Consider the following code in figure 4.

IF quantity <= 5  THEN
        Shipping_method := standard_shipping;
END IF;

IF quantity > 5 THEN

Shipping_method := expedited_shipping;

END IF;

Figure 4: Multiple Conditional Statements

This is fine as long as the condition is different in each IF clause. But in
our case it is obvious that either one of them will be true at any given time.
However the way this code is written, both the condition will be checked
resulting in an in-efficient module especially when there are more than a few
such situations in the code. Use of ELSIF would improve this situation as shown
in figure 5.

IF quantity <= 5  THEN
      Shipping_method :=  standard_shipping;
ELSIF  quantity > 5  THEN
     Shipping_method :=  expedited_shipping;
END IF;

Figure 5: Replacing IF with ELSIF

Here, either one of the two will be evaluate to true. In case it is the first
one which evaluates to true the rest of the statement will be ignored.

Use of CASE statements, is a much better alternative to nested if-elsif
statements, particularly when number of conditions to check for is large.

CASE quantity 
 WHEN <=5 THEN shipping_method :=  standard_shipping;
 WHEN > 5 THEN shipping_method :=  expedited_shipping;
 ELSE shipping_method :=  0
END CASE;

Figure 6: Using CASE for mutually exclusive condition checking

Use Bind Variables:

A key to improved code performance is the use of bind variables. It is a
simple technique yet powerful enough to improve performance of the PL/SQL code
by several orders of magnitude, depending on the type and size of data. The
reason for that lies in the manner DML statements are handled in Oracle. When an
Oracle SQL statement is issued, the statement is parsed and saved in a shared
memory area so that when the same statement is issued again by the program, the
system can skip the parsing step, thus saving processing time and resources.

Consider the code in figure 7.

(The code given below is for the purpose of demonstration and comparison only
and may not reflect real-life situation.)

DECLARE 
BEGIN 
     FOR i IN 1 .. 1000 LOOP
         EXECUTE IMMEDIATE 
       'SELECT item_id, qty FROM items WHERE qty = ' || i;
     END LOOP;
END;

Figure 7: Without bind variables

Every iteration of the loop produces the following statements:

SELECT item_id, qty FROM items WHERE qty = 1;

SELECT item_id, qty FROM items WHERE qty = 2;

SELECT item_id, qty FROM items WHERE qty = 3;

Etc...

When the system checks the shared memory area (shared pool) it considers each
statement to be unique and fails to make use of the parsed information already
available. We, however, know that the statements are almost identical. Bind
variables can help remedy this situation. Consider the code slightly modified
code in Figure 3.

DECLARE 
BEGIN 
     FOR i IN 1 .. 1000 LOOP
    EXECUTE IMMEDIATE 
      'SELECT item_id, qty FROM items WHERE qty = :x' using i;
     END LOOP;
END;

Figure 7: With bind variables

In this case the parser will get exactly the same information in every loop
iteration and would not have to re-parse the SQL statement.

Not only that the code is faster with the use of the bind variables, it is
also less CPU intensive and allows better sharing of resources by decreasing the
number of latches resulting in not just better performing code but a better
performing system as a whole.

As is evident from the code examples above, bind variables are applicable in
situations where dynamic SQL is being used. Since today's graphical user
interface programming makes very heavy use of dynamic SQL, there are more
opportunities of realizing the advantage of bind variables.

Conclusion:

In my personal experience, the hi-tech community tends to ignore standards or
a set of best practices if the list gets too long. Also, not all the best
practices are applicable in all situations. A practical approach to this would
be to keep the list of best practices small, prioritize items in that list, and
once done, ensure that the list is referred to at appropriate times. It would be
nice if at the end of every PL/SQL development effort the developers would go
through a check list to verify if, and how closely, they have followed the best
practices.

The need for good programming practices cannot be emphasized enough. This is,
arguably, true for database applications more than any other type of
programming. Bulk collects, anchored declarations, decision structures and bind
variables are just a few of the items from the list of best practices that most
experts have proposed to make PL/SQL code more manageable and efficient.

Source: http://www.orafaq.com/articles/archives/000054.htm

JavaScript: DHTML Library, Drag & Drop for Images and Layers

2005-03-29T00:17:00.000-08:00

WalterZorn - Good DHTML (API) site

JavaScript: DHTML Library, Drag & Drop for Images and Layers

DataRequester (Wrapper for XMLHTTPRequest)

2005-03-25T23:53:00.000-08:00

XMLHttpRequest

A JavaScript wrapper for the XMLHttpRequest object that enables the trivial implimentation of dynamic interfaces without the painful necessity for a complete page-refresh to talk to the server. In other words: Ajax without the confusing API.

Download: DataRequestor.js - 15kb