There is no “IIF” function in SQLSERVER as of VB and Access.For example, say you had a table like this: StudID Subject Marks—— —— ——1 Maths 801 Physics 751 Chemistry
Open Internet Services Manager from the Administrative Tools group.Right-click on your server and select properties. From Master Properties choose WWW Services and click the “Edit…” button. Select the HomeDirectory, and
Suppose that you have the following code: String strObj; if(strObj != null) if(strObj.equals(“something”)){ // } You can use instead “something”.equals(strObj), so you don’t have to test if strObj is null.
You probably know that there are basically two methods to search a value in an array: the brute force approach (i.e. linear searching) and the binary search. Both of them
Oftentimes, we need to convert ResultSets to XML for transferring data across different applications. Here is very simple code that transforms ResultSets into XML. import java.sql.*;import java.io.*;public class XMLWriter{ public
This is a piece of my actual code. It’s rather self-explanatory. public static String quote(String symbol) { try { java.net.URL url = new java.net.URL( “http://quotes.nasdaq.com/quote.dll?page=_xml&mode=stock&symbol=” + symbol); com.borland.xml.XmlData data =
When automating Outlook from a VB application, I needed to find a way to transfer data from a RichTextBox control to an Outlook message. Unfortunately using Clipboard.SetText and Clipboard.GetText did
There is a simple way to test if a character in a string is a letter.Just by using the UCase() And LCase() functions. Public Function IsLetter(Char As String) As Boolean
When you want to send an integer through the socket from a Java application to a C application, or your Java application needs to save some integer in the file