December 14, 2002

Avoid the Loss of CSS Style in Netscape V4.x

Sometimes it is very helpful to use a JavaScript feature that supports adding properties to build-in prototype “Objects” at runtime. It is generally known that Netscape 4.x has problems in saving the CSS style when the user resizes the view of the browser’s frame.The only safe solution I know is

Ensuring All Non-NULL Values Are Unique

Say you have a column in a SQL Server table that allows NULL values. You want this column to be unique when it has a value other than NULL. What’s the best way to program this behavior?SQL Server has no built-in mechanism to prohibit duplicates exceptNULLs, so you need to

Book Excerpt: Oracle9i The Complete Reference

hapter 21: Using SQL*Loader to?Load DataIn the scripts provided in Appendix A, a large number of insert commands are executed. In place of those inserts, you could create a file containing the data to be loaded and then use Oracle’s SQL*Loader utility to load the data. This chapter provides you

Specify the Order By Clause in a View

SQL Server does not allow you to include the Order By clause in a view.To do this, consider using the following workaround: USE pubsGOCREATE VIEW AuthorsByNameASSELECT TOP 100 PERCENT *FROM authorsORDER BY au_lname, au_fnameGO The only time that SQL Server supports an ORDER BY clause in a view is when

The Ten Developer Commandments of BREW

QUALCOMM’s Binary Runtime Environment for Wireless (BREW) is a platform that is ideally suited to creating powerful applications on memory/footprint-constrained devices. One of the ways BREW is able to do this is by working with truly compiled code that has been written in languages such as C and C++. In

Using Quotation Marks in SQL Server

The standard delimiters for literal strings in SQL are single quotation marks (‘). By default, SQL Server reserves double quotation marks (“) as delimiters for database objects.The SQL Server ODBC driver supports a Quoted Identifiers setting for the session or connection. If this setting is on, double quotation marks are

Avoid NullPointerException Comparing Strings

The standard way to compare a variable String to a constant is to use this syntax: if(myString.equals(“test”)){ doSomething();} However, if myString is null, a NullPointerException will be thrown. Instead, use: if(“test”.equals(myString)){ doSomething();} If myString is null, the comparison will return false rather than an Exception.

Securing Your SQL Server

lanning for database security means a number of things. First, you need to take care that the code you send to SQL Server is not vulnerable to SQL injection. Second, you need to keep up with and apply the latest Microsoft SQL Server security updates. Third, after you take care

Distinguish Between Synchronized Statics & Synchronized Instance Methods

When you invoke a synchronized static method, you obtain the lock associated with the Class object in whose class the method is defined.When you apply synchronized to instance methods and object references, you obtain the lock for the object on which the method was invoked.The following code is not thread

No more posts to show