This procedure retrieves the table name, table id, column or fieldname, data type, the length of the field in bytes, and the order in which the fields were created. I
Use this stored procedure to send an email: DECLARE @SenderAddress varchar(100)DECLARE @RecipientAddress varchar(100)DECLARE @Subject varchar(200)DECLARE @Body varchar(8000)DECLARE @oMail int –Object referenceDECLARE @resultcode intSET @SenderAddress = ‘[email protected]’SET @RecipientAddress= ‘[email protected]’SELECT @Subject =
Use this code to change the read-only permissions of a file in JDK 1.2.2: public void changeFilePermission(){ String osName = System.getProperty(“os.name”); try{ if (osName.equalsIgnoreCase(“WINDOWS NT”) ||osName.equals(“Windows 2000”) ) { Runtime.getRuntime().exec(“cmd.exe
JavaScript doesn’t have a trim to strip the spaces around strings. This little bit of code uses regular expressions to strip the spaces around given input. function trim(input){ var lre
It has been stated before that hard-coded, literal strings are to be avoided. I disagree. There is an easy, convenient way to handle hard-coded, literal strings: use a macro directly
Use the following code to scale an image into double its original size: import java.applet.*;import java.awt.*;import java.net.*;public class ScaleImage extends Applet{ Image img; public void init() { try { img
Private Declare Function GetProfileString Lib “kernel32” Alias _ “GetProfileStringA” (ByVal lpAppName As String, ByVal lpKeyName As String, _ ByVal lpDefault As String, ByVal lpReturnedString As String, _ ByVal nSize As
‘ Format a date as a DateSerial for Access’ Example: Debug.Print GetDBDate(date)Public Function GetDBDate(sDate As String) As String On Error GoTo ERROR_GetDBDate Dim sTmp As String If IsDate(sDate) = False