Top Articles

Create a Win7 Gadget

DanRollins11/20/2009, 12:00 AM

This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista.  Gadgets can be dropped anywhere on the desktop to provide instant information, or to act as a gateway to a website or a larger pr

Topic: Windows ProgrammingTags: tutorial, sample, Windows 7, gadget.xml, sidebar, Hello World, localappdata, debugging, ZIP file, Dan Rollins

Views: 71091Comments: 20

C++ Q & A / Interview Practice Questions

evilrix08/27/2009, 12:00 AM

How good is your C++? Below is a collection of questions that I have built up over time that test how well someone who claims to know C++ actually does. Knowing the answers to these questions will probably help you avoid making a lot of the mistakes

Topic: C++ Programming LanguageTags: c++ interview questions

Views: 34373Comments: 47

jQuery AJAX-Enabled Forms in Modal Dialog

anoyes12/13/2009, 12:00 AM

It's a problem I'm sure many of you have faced in developing web applications.  You've got a form to add a new something - perhaps a customer or an item in a to-do list.  When the user clicks that link to add a new item, a new page loads, they fill

Topic: JqueryTags: jquery, ui, dialog

Views: 26803Comments: 20

How Oracle Stores Passwords

sdstuber06/09/2009, 12:00 AM

How Oracle Stores Passwords Sean D. Stuber 2009-06-09 Up to date through Oracle version 11g Overview: Many times a DBA may want to replicate a user from one system to another and migrate that same password,such as refreshing a production syste

Topic: Oracle DatabaseTags: Oracle, 10g, 11g, DBA_USERS, SYS.USER$, password, hash

Views: 23156Comments: 36

Pie Chart Techniques

ValentinoV10/29/2009, 12:00 AM

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips.  This article explained how to optimize a Column Chart.  Today I have returned to show you some Pie Chart implementation techniques. As usual, I will

Topic: MS SQL ReportingTags: SSRS, SQL Server Reporting Services 2008, pie chart, reporting services, charting

Views: 21870Comments: 12

Simple Multithreading in Visual C++

DanRollins09/23/2009, 12:00 AM

Here's a summary of how to use multithreading, with short, easy-to-follow example code in C++.   Before you embark on this journey, I suggest that you read Multithreading -- When and Why because odds are, you really don't need to create additiona

Topic: Windows ProgrammingTags: multi-threading with C++, Create Thread, AfxBeginThread, TerminateThread, killing a thread

Views: 19705Comments: 4

Convert string to number / Convert number to string in JavaScript

DanRollins09/25/2009, 12:00 AM

This EE article provides JavaScript examples of conversion from string to integer, string to floating-point, and number to string.  We'll also look at some related topics, including how to format numeric output with two decimal places, and one way t

Topic: JavaScriptTags: javascript, JScript, convert to string, convert to integer, convert to floating point, format currency, toFixed, parseInt, toString

Views: 16670Comments: 3

Execute a Program with C++

DanRollins09/19/2009, 12:00 AM

This article describes several ways to launch a program using C++, including one that will launch a DOS (console-style) program and capture the console output (the standard output) for programmatic processing. We are going to focus on the task of

Topic: Windows ProgrammingTags: Execute a DOS program, ShellExecute, launch a program, C++, show web browser, print PDF file, CreateProcess, unzip, runas, Dan Rollins

Views: 16101Comments: 10

Median, Mode, Skewness, and Kurtosis in MS Access

matthewspatrick02/24/2010, 12:00 AM

by Patrick G. Matthews Introduction Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance

Topic: Microsoft Access DatabaseTags: Microsoft, Access, Statistics, Mean, Median, Mode, Standard Deviation, Skewness, Kurtosis, Sampling, Visual Basic, Visual Basic for Applications, VBA

Views: 15728Comments: 23

Your First OLAP Report

ValentinoV01/24/2010, 12:00 AM

This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting

Topic: MS SQL ReportingTags: SSRS, SQL Server, Reporting Services, mdx, olap, SSAS, Analysis Services, cube

Views: 15583Comments: 12

Retrieving Data From Excel Using OPENROWSET()

ValentinoV05/04/2010, 12:00 AM

The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a significant amount of time has probably come into contact

Topic: MS SQL ServerTags: import Excel, openrowset, SQL Server, SQL

Views: 15468Comments: 6

MFC Feature Pack for VS 2008 and 2010

DanRollins12/19/2009, 12:00 AM

In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual

Topic: Windows MFC ProgrammingTags: VC++, Visual Studio, MFC Feature Pack, Win7, CMFCMaskedEdit, CMFCMenubar, CMFCButton, CMFCFontComboBox, Tear-off menus, Dan Rollins

Views: 15030Comments: 7

3 Ways to Speed Up MySQL

gr8gonzo07/27/2009, 12:00 AM

There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these 3 ways. Here they are, in order of importance: 1. Optimize queries 2. Tune the MySQL configuration 3. Add more hardware ...

Topic: MySQL ServerTags: mysql, database, performance, optimization, indexes, queries, slow, caching

Views: 14482Comments: 59

AjaxControlToolkit’ TabContainer control’ Javascript functions.

sand198002/25/2010, 12:00 AM

In this blog we will start with a common requirement for the tab container control i.e. setting focus to a tab using javascript and later at the end of this blog we will also see some important javascript functions available with ASP.NET AJAX Tab Co

Topic: Programming for ASP.NETTags: ASP.NET AJAX, TabConainer, ASP.NET

Views: 14411Comments: 0

Function pointers vs. Functors

evilrix06/07/2009, 12:00 AM

Often, when implementing a feature, you won't know how certain events should be handled at the point where they occur and you'd rather defer to the user of your function or class. For example, a XML parser will extract a tag from the source code, wh

Topic: C++ Programming LanguageTags: C++

Views: 14352Comments: 8

Using Regular Expressions in Visual Basic for Applications and Visual Basic 6

matthewspatrick08/17/2009, 12:00 AM

Using Regular Expressions in VBA and VB6 Projects By Patrick Matthews (matthewspatrick, ...

Topic: Visual Basic ProgrammingTags: Regular Expressions, RegExp, Visual Basic, VB6, VBA, RegExpFind, RegExpReplace, Excel, Access, Office

Views: 13734Comments: 51

Calculating Distinct Counts in Access

matthewspatrick02/08/2010, 12:00 AM

by Patrick G. Matthews All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception.  As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns t

Topic: Microsoft Access DatabaseTags: Access, Query, Queries, SQL, Distinct, Count, Distinct Count, VBA, Visual Basic, Aggregate, Domain Aggregate

Views: 13412Comments: 18

Add a Custom Command Button to the Windows 7 Explorer Toolbar

DanRollins12/30/2009, 12:00 AM

This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article, we saw how to put the Delete button back there where it belongs.  "Delete" is a predefined action, but today, we're going to

Topic: Windows ProgrammingTags: Win7, Explorer toolbar, FolderTypes, command bar, custom button, RegEdit, registry, jscript, Dan Rollins

Views: 12727Comments: 12

ASP.NET : Mobile Device Detection and Redirection

amimpat01/19/2010, 12:00 AM

This article explains approaches for ASP.NET mobile development to determine if an HTTP request is coming from a mobile phone and then redirecting the request to a page optimized for a mobile browser. Examples in below article are in c#.net Me

Topic: Programming for ASP.NETTags: ASP.NET, Device Detection, Browser Detection, ASP.NET Mobile, Mobile Web

Views: 11867Comments: 34

Use AJAX ModalPopupExtender in GridView or other data controls

prairiedog04/08/2009, 12:00 AM

AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays,

Topic: Programming for ASP.NETTags: ASP.NET, AJAX ModalPopupExtender

Views: 11657Comments: 2

Connect by prior

ivostoykov02/12/2010, 12:00 AM

by Ivo Stoykov One of challenges in data digging is hierarchical data representation. Usually manipulating trees in relational database raises lots of questions and confusions. In following lines I’ll try to scatter the fog around this topic. For

Topic: Oracle DatabaseTags: oracle hierarchy query select data parent child

Views: 11597Comments: 8

Create a Win7 Maze! Gadget

DanRollins11/20/2009, 12:00 AM

This article shows a few slightly more advanced techniques for Windows 7 gadget programming, including how to save and restore user settings for your gadget and how to populate the "details" panel that is displayed in the Windows 7 gadget gallery.  

Topic: Windows ProgrammingTags: Tutorial, sample, Windows 7, sidebar, wrench, settingsUI, onShowSettings, onSettingsClosed, System.Gadget, Dan Rollins

Views: 11110Comments: 11

Adding an Else to your Switch

ValentinoV01/16/2010, 12:00 AM

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T

Topic: MS SQL ReportingTags: Reporting Services, SSRS, IIF, Switch, if, switch else, sql server

Views: 10288Comments: 7

Oracle Backup and Recovery: Best Practice #1: RMAN Autobackup

mrjoltcola05/24/2009, 12:00 AM

If you are an Oracle DBA, and you don't know RMAN, don't bet on being taken seriously in a competitive job market. More importantly, you are making your job more difficult by sheer laziness of learning. Many years have passed since Oracle 8 introduc

Topic: Oracle DatabaseTags: rman oracle backup recovery best practices autobackup controlfile parameter mrjoltcola

Views: 10092Comments: 5

Create a Win7 Gadget with a Flyout Panel

DanRollins11/22/2009, 12:00 AM

This article shows how to make a Windows 7 gadget that extends its U/I with a flyout panel -- a window that pops out next to the gadget.  The example gadget shows several additional techniques:  How to automatically resize a gadget or flyout panel t

Topic: Windows ProgrammingTags: Tutorial, Windows 7, gadget, sidebar, flyout, System.Shell, size to content, ActiveX, JavaScript, action verbs, FolderItem, Dan Rollins

Views: 10070Comments: 3

Checking for valid IP addresses using JavaScript Regular Expressions

HonorGod06/28/2009, 12:00 AM

There are times when an Internet Protocol (IP) address needs to be verified/validated.  What are examples of valid IP addresses? 127.0.0.1 1.2.3.4 192.168.1.100 The pattern is that we have 4 integer values (from 0 to 255) separated by period

Topic: JavaScriptTags: JavaScript, RegExp, Regular Expression, IP Address

Views: 9747Comments: 11

How to Mimic the T-SQL IsNumeric() Function in MySQL

mwvisa111/21/2008, 12:00 AM

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number

Topic: SQL Query SyntaxTags: MySQL, IsNumeric, RegExp, Regular Expression, Sorting Text and Numbers Separately, SQL, RegExp_Like

Views: 9737Comments: 28

Hide/Show Validator Callout Control Using Javascript

sand198004/06/2010, 12:00 AM

In this article we will see how to show and hide a ASP.NET AJAX’ (AJAXControlToolkit) ValidatorCalloutExtender control using Javascript.  Below is an .aspx page with a validator callout control. <%@ Page Language="C#" AutoEventWireup="true" CodeF

Topic: Programming for ASP.NETTags: ASP.NET AJAX, ValidatorCalloutExtender, ASP.NET

Views: 9706Comments: 16

Dynamic Pivot Procedure for SQL Server

mark_wills05/15/2009, 12:00 AM

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively

Topic: SQL Server 2005Tags: SQL2005 sql2008 PIVOT

Views: 9595Comments: 16

Create a Win7 DropTarget Gadget

DanRollins11/21/2009, 12:00 AM

This article shows how to make a Windows 7 gadget that accepts files dropped from the Windows Explorer.  It also illustrates how to give your gadget a non-rectangular shape and how to add some nifty visual effects to text displayed in a your gadget.

Topic: Windows ProgrammingTags: Windows 7, transparent, drag and drop, target, sidebar, sample, g:background, g:text, System.Shell, ondrop, Dan Rollins

Views: 9562Comments: 3

How to FTP with Oracle PL/SQL

sdstuber05/09/2010, 12:00 AM

Sometimes you need to get data from a server into your database, or from your database into a remote server.  There are many ways this can be done such as  SOAP or REST web service calls, database links,  pipes,  or external tools.  Another option,

Topic: Oracle DatabaseTags: Oracle, FTP, PL/SQL

Views: 9516Comments: 33

POSIX Threads Programming in C++

w00te03/05/2010, 12:00 AM

Written by John Humphreys C++ Threading and the POSIX Library This article will cover the basic information that you need to know in order to make use of the POSIX threading library available for C and C++ on UNIX and most Linux systems.   Be

Topic: C++ Programming LanguageTags: C++, C, POSIX, Threads, Linux, pthread_create, pthread.h

Views: 8967Comments: 12

PHP - Prevent SQL Injection

abolinhas05/26/2009, 12:00 AM

SQL injection vulnerabilities have been described as one of the most serious threats for Web applications. Web applications that are vulnerable to SQL injection may allow an attacker to gain complete access to their underlying databases. Because

Topic: PHP and DatabasesTags: php, mysql

Views: 8963Comments: 14

PHP Client Registration, Login, Logout and Easy Access Control

Ray_Paseur02/03/2010, 12:00 AM

Introduction A frequent design pattern question for new PHP developers goes something like this, "How do I handle client registration and login?"  It's done in every framework and CMS, and all of them use a similar pattern.  This article builds the

Topic: PHP Scripting LanguageTags: login, client validation, session, cookie, password

Views: 8762Comments: 47

Expanding a Hierarchical Data Structure

mbizup06/20/2008, 12:00 AM

Introduction One of the earliest concepts learned by database developers is parent-child (one-to-many) relationships.  These relationships are integral in countless database applications.  A purchase request containing one or more items ordered i

Topic: Microsoft Access DatabaseTags: Databases, MS Access, Bill of Materials, BOM, Parts Lists, heirarchical, recursion

Views: 8689Comments: 42

Chart Optimization Tips

ValentinoV09/26/2009, 12:00 AM

Here are some optimization techniques that can be used when creating charts in SQL Server 2008 Reporting Services.  These tips will probably be already known to experienced chart developers, but freshmen charters may spent some time searching how to

Topic: MS SQL ReportingTags: SQL Server Reporting Services 2008, chart, SSRS, Reporting Services

Views: 8659Comments: 14

Building Android app with NDK - integrated in Eclipse with CDT

alexcohn11/16/2010, 12:00 AM

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project automates most of the tasks discussed in this article. You can even find instructions for debugging your n

Topic: EclipseTags: Android NDK, Eclipse

Views: 8531Comments: 5

Mouse Wheel Programming in JavaScript

DanRollins01/16/2010, 12:00 AM

In this article I'll describe cross-browser techniques for using the mouse wheel (or "scroll wheel") in your JavaScript programming for HTML pages.  I'll show example Javascript for option selection and image zooming. The mouse wheel is generally

Topic: JavaScriptTags: mousewheel, scroll wheel, DOMMouseScroll, onmousewheel, pentominos, wheelDelta, Dan Rollins

Views: 8316Comments: 9

Simple Linear Regression in MS Access

matthewspatrick04/03/2010, 12:00 AM

by Patrick G. Matthews Introduction Linear regression analysis is a common statistical technique used to infer the possible relationships between a dependent variable and one or more independent variables.  While Microsoft Access does not

Topic: Microsoft Access DatabaseTags: Access, Microsoft, regression, regression analysis, linear regression, statistics, VBA, VB, Visual Basic, coefficients, r squared, standard error

Views: 8189Comments: 13

Working with Modal Popup extender control.

sand198008/08/2010, 12:00 AM

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal

Topic: Programming for ASP.NETTags: ASP.NET, ASP.NET AJAX, Modal Popup Extender

Views: 8168Comments: 24

Convert String to int / Convert int to String in C++

DanRollins09/17/2009, 12:00 AM

This EE article provides examples of conversion techniques for various types of string variables:  classic C-style strings, MFC/ATL CStrings, and STL's std::string data type. Convert Integer to String int to C-style (NULL-terminated char) string

Topic: C++ Programming LanguageTags: atoi, sprintf, itoa, convert integer to string, convert string to integer, std::string, ostreamstring, atoi_s, sprintf_s, Dan Rollins

Views: 8147Comments: 12

Building a Formless WinForms Application with a NotifyIcon in VB.Net 2008

Idle_Mind03/24/2010, 12:00 AM

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru

Topic: Microsoft Visual Basic.NetTags: ApplicationContext, NotifyIcon, WinForms, Visual Basic.Net

Views: 8133Comments: 20

Trimming strings in Javascript

quincydude11/20/2008, 12:00 AM

User input plays a big role on webpages. It acts as an interface between users and the server. Handling user inputs is important as we need to ensure what data can be sent to the server and we cannot expect what the user will send. One of the most c

Topic: JavaScriptTags: Trimming, trim, strings, Javascript

Views: 7992Comments: 7

Custom File Filtering Using Java File Choosers

mwvisa112/16/2008, 12:00 AM

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi

Topic: Java Programming LanguageTags: Java, javax.swing.JFileChooser, javax.swing.filechooser.FileFilter, Nested Anonymous Class, Inheritance, Custom File Filtering, Open File Dialog, Save File Dialog, File Choosers

Views: 7945Comments: 8

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

matthewspatrick02/02/2010, 12:00 AM

by Patrick G. Matthews A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query.  For example

Topic: Microsoft Access DatabaseTags: Access, VBA, SQL, query, domain aggregate, concatenate

Views: 7941Comments: 21

Decoding the Oracle ROWID (and some Base64 for fun)

mrjoltcola06/13/2009, 12:00 AM

Most Oracle programmers have heard of ROWIDs. Many have even used ROWIDs at some point. A few even have an idea of what the ROWID is, logically, but only a very select few actually know the details. It is sufficient to know that the ROWID exists and

Topic: Oracle DatabaseTags: oracle dba rowid base64 dbms_rowid utl_encode base64_decode block mrjoltcola

Views: 7888Comments: 22

Client side input validation with Javascript

quincydude11/20/2008, 12:00 AM

Html Form is the main way for users to interact with server side. It can bring a lot of functionalities to web sites such as searching, data storing and different kinds of calculations. However, page involving user inputs also implies users can do s

Topic: JavaScriptTags: Client side, validation, Javascript, form

Views: 7769Comments: 2

Radio Buttons in MFC Dialogs

DanRollins09/12/2009, 12:00 AM

Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli

Topic: Windows MFC ProgrammingTags: MFC, DDX_Radio, C++, DoDataExchange, RadioButton group, enabling dilaog items, Dan Rollins

Views: 7727Comments: 1

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error

aelliso307/07/2010, 12:00 AM

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t

Topic: MS SQL ReportingTags: SSRS 2008 SQL Server R2 User Access Control UAC Permission Error

Views: 7595Comments: 6

Handling Date and Time in PHP and MySQL

Ray_Paseur11/20/2008, 12:00 AM

The DATETIME Tower of Babel Human beings can read dates and times in a variety of ways.  We readily understand such things as September 5th, 2010, and we know that it comes before November 11th, 2010,and after May 9th, 2010.  We have shorthand conv

Topic: PHP Scripting LanguageTags: PHP, MySQL, date, time, mktime, strtotime

Views: 7386Comments: 49

Output an XML type attribute using DataContract

williamcampbell08/31/2009, 12:00 AM

This tutorial will show you how to add an attribute to an XML stream returned from a Windows Communication Foundation (WCF) Web Service.  Some knowledge of WCF and XML is required; the code is in C#.  Below is an XML sample of an attributed XML stre

Topic: Web Services and WCFTags: DataContract Attribute, XML, C#, WCF

Views: 7372Comments: 39

20 Tips to Optimize your ActionScript

moagrius12/15/2009, 12:00 AM

Introduction This article is primarily concerned with ActionScript 3 and generally specific to AVM2.  Most suggestions would apply to ActionScript 2 as well, and I've noted those tips that differ between AS2 and AS3. With the advent of ActionS

Topic: ActionScriptTags: AS, ActionScript, AS3, Optimization, Performance

Views: 7033Comments: 18

Subquery Factoring WITH Oracle

ivostoykov02/02/2010, 12:00 AM

WITH Clause OR Subquery Factoring WITH Oracle by Ivo Stoykov Digging information from a database sometimes requires creating complicated queries. Often a simple select * from . . . is nested into another one and both into another one and so

Topic: Oracle DatabaseTags: WITH Clause Factoring Oracle

Views: 6962Comments: 2

Advanced Object-Oriented Programming in PHP

gr8gonzo03/08/2010, 12:00 AM

This article is intended to cover some of the more advanced topics of object-oriented programming (OOP) in PHP, and is intended to follow up on my previous article covering the basics of OOP in PHP. Specifically, this article will teach you all abou

Topic: PHP Scripting LanguageTags: object-oriented programming, OOP, PHP, get, set, accessors, mutators, interface, extending, classes

Views: 6937Comments: 10

PIVOT Transformation - SSIS - Complete Tutorial

reza_rad02/15/2010, 12:00 AM

Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft : Mi

Topic: SSISTags: PIVOT, PIVOT Transformation, SSIS, Tutorial

Views: 6922Comments: 9

Analytical SQL : Where do you rank?

mwvisa109/16/2009, 12:00 AM

"Top 10 customers by salesperson" sound familiar?  Yes!  I would expect so, and am sure there are a number of other great business analyses with a similar principle now flowing through your mind. So, how do you query this data in your SQL system?

Topic: SQL Query SyntaxTags: Analytical Functions, Row_Number, Rank, NTile, Dense_Rank, Over, MySQL, Oracle, MS SQL, MS Access

Views: 6882Comments: 27

Delimited String Parsing in SQL Server 2005 and later

BrandonGalderisi11/20/2008, 12:00 AM

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa

Topic: SQL Server 2005Tags: parse, string parsing, delimited string, user defined function, sql server 2005, sql server 2008

Views: 6771Comments: 8

File permissions with Java

Venabili09/10/2009, 12:00 AM

Java has always been considered a multi-platform language - you write your code once and then you use it on almost any Operating System. Unfortunately for most Java developers, this is often taken quite literally from anyone that had no knowledge of

Topic: Java Programming LanguageTags: Java, Permissions, Unix

Views: 6754Comments: 10

Closures in Java 7 - does a new era start for the language?

Venabili03/18/2010, 12:00 AM

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde

Topic: Java Programming LanguageTags: java 7, closures

Views: 6734Comments: 20

How to use Access Control Lists in Oracle

sdstuber10/28/2011, 12:00 AM

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth

Topic: Oracle DatabaseTags: Oracle, ORA-24247, ACL DBMS_NETWORK_ACL_ADMIN

Views: 6616Comments: 9

How to Succeed in ... Anything

ericpete10/07/2009, 12:00 AM

This article originally appeared in the Experts Exchange Newsletter, and is republished here by request. It never ceases to amaze me the lengths to which people will go. I've been a member of the workforce since I was about 12. I didn't have t

Topic: Project ManagementTags: management, personnel

Views: 6595Comments: 37

Covariance and Correlation in MS Access

matthewspatrick03/24/2010, 12:00 AM

by Patrick G. Matthews Introduction Access provides functions for computing several common descriptive aggregate statistics for column data, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev,

Topic: Microsoft Access DatabaseTags: correlation, correlated, covariance, MS, Microsoft, Access, domain aggregate, Visual Basic, Visual Basic for Applications, VB, VBA

Views: 6419Comments: 23

Advanced DOS batch pitfalls

Qlemo05/21/2009, 12:00 AM

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some

Topic: Windows Batch ScriptingTags: DOS, batch, inconsistency, file redirection, delayed expansion

Views: 6386Comments: 20

SARGable functions in SQL Server

rob_farley02/24/2010, 12:00 AM

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou

Topic: SQL Server 2008Tags: SQL Server, Indexing

Views: 6357Comments: 6

Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else.

RiteshShah02/04/2010, 12:00 AM

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008,

Topic: SQL Server 2008Tags: Encryption, decryption, backup database, restore database, certificate, symmetric key

Views: 6344Comments: 13

Separating C++ template declaration and implementation

evilrix07/18/2009, 12:00 AM

The following question was the inspiration for this short article:"Splitting a template and class into definition and declaration.". In this question the asker asks, "I have the code below, which is all well and good but I'd like to move the definit

Topic: C++ Programming LanguageTags: c++ templates

Views: 6339Comments: 8

Parallel Port Control with Delphi

thiagoblimeira12/29/2009, 12:00 AM

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print

Topic: Delphi ProgrammingTags: Parallel Port, Delphi, LPTPort, Device Driver

Views: 6285Comments: 8

Registration and Email Confirmation in PHP

Ray_Paseur10/17/2010, 12:00 AM

One of the frequent application design questions goes something like this: "How can I confirm when a client registers on my web site?" The registration might be for general use of a self-administered site like a forum, or for attendance at a spec

Topic: PHP Scripting LanguageTags: PHP, MySQL, Registration, Confirmation, Activation, Email, Hnadshake

Views: 6241Comments: 2

Connect to your SQL Server

angelIII10/28/2009, 12:00 AM

If you are already familiar with all the terms, you can skip this section.   Anyone else just read on for the quick introduction of the terms that are important to know and distinguish, when troubleshooting SQL server login issues.  First, the pur

Topic: MS SQL ServerTags: MS SQL Server, Database, Instance, Connect

Views: 6228Comments: 20

Introduction to Casting

aikimark10/11/2009, 12:00 AM

This article is about data casting. I am going to cover VBA/VB6 explicit casting.  It doesn't have anything to do with fly fishing, reel fishing, surf fishing, acting, or broken limbs.  You may have done some casting and not known it because VB do

Topic: Visual Basic ProgrammingTags: VBA, VB6, SQL, Excel, Access, data type, cast, convert, conversion

Views: 6199Comments: 10

Dlookup and the Domain Functions

JDettman06/18/2008, 12:00 AM

 Applies to: All versions of Access   Skill Level:Beginner   One of the common questions we see in the Access zone is how to get a value from a table.  One way to do that is with a set of built-in functions called Domain functions.  These functio

Topic: Microsoft Access DatabaseTags: "Microsoft Access" Access VBA Beginner

Views: 6176Comments: 17

Displaying progress in the main form from a thread in Delphi

Geert_Gruwez11/21/2008, 12:00 AM

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the

Topic: Delphi ProgrammingTags: Delphi 7.0, Thread, Progressbar

Views: 6161Comments: 6

C++ Smart pointers

evilrix11/14/2009, 12:00 AM

This article is a discussion on smart pointers, what they are and why they are important to C++ programmers. Following the primary discussion I present a simple implementation of a reference counted smart pointer and show a simple example of using i

Topic: C++ Programming LanguageTags: C++ RAII smart pointer

Views: 6154Comments: 20

UPDATES with JOIN... for everybody?

angelIII09/12/2009, 12:00 AM

One of the regular tasks for a SQL Developer (or DBA) is to UPDATE data of existing rows, after they are in the table. A simple example, to update an existing row, based on the primary key, would look like this: UPDATE tbl_employee    SET last_n

Topic: Databases MiscellaneousTags: UPDATE JOIN, MS SQL Server, MySQL, Oracle

Views: 6142Comments: 28

Create a Standard DLL with VC++

DanRollins06/06/2009, 12:00 AM

This tutorial is about how to put some of your C++ program's functionality into a standard DLL, and how to make working with the EXE and the DLL simple and seamless.   We'll be using Microsoft Visual Studio 2008 and we will cut out the noise; that i

Topic: Windows ProgrammingTags: C++, DLL, Visual Studio, debugging, two projects, tutorial, .DEF file, EXPORTS

Views: 6127Comments: 3

Updating a Splash Screen with Loading Progress in a VB.Net WinForms Application

Idle_Mind09/08/2010, 12:00 AM

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel

Topic: Microsoft Visual Basic.NetTags: VB.Net, Visual Basic, Splash Screen, Update, Progress, WinForms

Views: 6127Comments: 14

Multiple Commands on a Single Line in VBScript

tigermatt11/21/2008, 12:00 AM

Unlike scripting languages such as C# where a semi-colon is used to indicate the end of a command, Microsoft's VBScript language relies on line breaks to determine when a command begins and ends. As you can imagine, this quickly results in messy cod

Topic: VB ScriptTags: ASP, VBS, vbscript, multiple commands, single line

Views: 6031Comments: 8

Delimited list as parameter: what are the options?

angelIII09/14/2009, 12:00 AM

Earlier or later, every sql developer will be confronted with queries like this:select * from tbl_employees where ssn in ('123-456-789','777-777-777'); But with the issue that the list should be a parameter at some point (either in the sql proced

Topic: Databases MiscellaneousTags: comma delimited list pocedure in MS SQL Server MySQL Oracle

Views: 6002Comments: 43

Browser Bot -- Automate Browsing Sequences With C++ (PART ONE)

DanRollins07/05/2009, 12:00 AM

Having a custom web bot can save you lots of time and effort.  For instance, you might need to log in to a site, click a certain link, scroll down to locate some particular information, copy it to a clipboard for pasting into a spreadsheet, ... then

Topic: Windows ProgrammingTags: webbot, C++, login, webbrowser control

Views: 5985Comments: 9

Using SendKeys to Automate Repetitive Tasks

DanRollins02/12/2010, 12:00 AM

If you have ever found yourself doing a repetitive action with the mouse and keyboard, and if you have even a little programming experience, there is a good chance that you can use a text editor to whip together a sort of macro to automate the proce

Topic: Windows ProgrammingTags: WshShell, WScript, SendKeys, AppActivate, send keys, automate keystrokes, keyboard macro, JavaScript, VBScript, Dan Rollins

Views: 5974Comments: 14

Getting Your Application Kinect-ed

kaufmed06/17/2011, 12:00 AM

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK for the Xbox 360 Kinect. If you don't know what a Kinect is, then I will assume you do indeed live under a rock. The Xbox 360 peri

Topic: .NETTags: c#, .NET, VB.NET, Kinect, XBox

Views: 5963Comments: 30

DISTINCT and GROUP BY... and why does it not work for my query?

angelIII06/01/2010, 12:00 AM

Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, and you don't ge

Topic: Databases MiscellaneousTags: DISTINCT, GROUP BY, UNION, JOIN, MS SQL Server, Oracle, MySQL, datetime, last date, last time

Views: 5943Comments: 16

MySQL Workbench Remote Administration using SSH to Windows Server

rcombis12/08/2010, 12:00 AM

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m

Topic: MySQL ServerTags: MySQL Workbench, SSH, Windows Server, MySQL Remote Administration

Views: 5924Comments: 3

Migrating from VSS 2005 to TFS 2010 using VSSConverter -- Missing Instructions

rscowden04/24/2010, 12:00 AM

If you have have been using Visual Studio 2008 with VSS and are now migrating to Visual Studio 2010 and Team Foundation Server, you may need to migrate your VSS data to TFS.  Microsoft has made VS 2010 TFS available to VS2008 with MSDN subscribers a

Topic: Visual StudioTags: VSS, TFS

Views: 5815Comments: 2

Speedier Execution of Stored Procedures in SQL Server

Bobaran9807/30/2009, 12:00 AM

I started a new job about six months ago, and with that job I inherited a mission-critical SQL Server 2005 database with over 800 stored procedures and tens of millions of records.  I also inherited what appeared to be a growing problem:  certain of

Topic: MS SQL ServerTags: parameter sniffing, stored procedure, query, sql server, sql server 2005, sql server 2008, sql server 2000, t-sql, optimization, sql

Views: 5710Comments: 35

Simple ASP.NET download page

PaulHews03/11/2010, 12:00 AM

Download the code and data for this sample application. There are times when you need to track downloads of a particular resource from your server.  While IIS maintains logs of each HTTP request, it would be painful to use them to track downloads

Topic: Programming for ASP.NETTags: ASP.NET 2.0, track downloads

Views: 5649Comments: 10

How to set multiple events in Oracle

franckpachot10/20/2009, 12:00 AM

A quick example on how to set multiple events. (For example, you are asked by Oracle support to set an event and you already have one that you want to keep) In the spfile: the name is 'event' and values are quoted then comma separated as in:

Topic: Oracle DatabaseTags: set events, set event

Views: 5572Comments: 12

Database Concepts: Keys

jagadeesh_motamarri10/06/2009, 12:00 AM

In this part, I will be briefing about different kind of keys available in database systems. Base example I will be using the following table to explain about database keys - EMPLOYEE Candidate Key A candidate key is a combination of attr

Topic: Databases MiscellaneousTags: databases, keys, primary key, sql, oracle, db2

Views: 5513Comments: 13

Using the Switch Function in Microsoft Access

matthewspatrick08/10/2010, 12:00 AM

By Patrick G. Matthews Introduction In Microsoft Access, Switch is a very useful and powerful function that allows you to build conditional branching logic into your expressions in queries, forms, and reports.  In essence, you pass Switch

Topic: Microsoft Access DatabaseTags: Access, Microsoft, Switch, Query, Queries, SQL, VBA, Visual Basic, Visual Basic for Applications, Office

Views: 5492Comments: 17

SQL Server: Table Joins Explained!

chapmandew03/17/2010, 12:00 AM

A Brief Primer on Database Systems Relational Database Management Systems (RDBMS) such as SQL Server are based on the idea of designing a logical system composed of entities and relationships among those entities.   This logical system is sometimes

Topic: MS SQL ServerTags: SQL Server, join, left join, cross join, where, criteria, NULL, missing data, duplicate data, ANSI, ANSI JOIN

Views: 5467Comments: 31

Simple Binding. Cocoa GUI Application without Outlets.

pgnatyuk07/09/2010, 12:00 AM

An Outlet in Cocoa is a persistent reference to a GUI control; it connects a property (a variable) to a control.  For example, it is common to create an Outlet for the text field GUI control and change the text that appears in this field via that Ou

Topic: Objective-C Programming LanguageTags: Cocoa, Key-Value Coding, Binding

Views: 5438Comments: 7

Converting Active Directory Timestamps in Microsoft SQL Server

mwvisa106/04/2009, 12:00 AM

If you are an Active Directory administrator working with AD data in SQL Server, then this article is for you! INTRODUCTION As AD admins or those having to deal with AD data, you probably have had to convert a timestamp or two like last logo

Topic: MS SQL ServerTags: SQL Server 2005, MS SQL Server, Date Functions, User Defined Functions, Active Directory, Timestamps

Views: 5405Comments: 13

Fast Base64 Encode and Decode

DanRollins06/06/2010, 12:00 AM

This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi

Topic: Windows ProgrammingTags: base64, CryptoAPI, CryptBinaryToString, CryptStringToBinary, Base64Encode, Base64Decode, Dan Rollins

Views: 5297Comments: 23

The Difference Between Truncation and Deletion in Microsoft SQL Server

chapmandew03/14/2010, 12:00 AM

The removal of data is a common activity inside all database systems. There are two mechanisms to remove records inside the SQL Server database engine: the DELETE statement and the TRUNCATE TABLE statement. While both of these statements are similar

Topic: MS SQL ServerTags: sql server, delete, truncate, remove data, database, truncate vs delete, truncate or delete, truncation vs deletion

Views: 5251Comments: 22

How to provide a CALLBACK function into a C++ class object

DanRollins05/16/2009, 12:00 AM

Some Windows API functions expect you to provide a pointer to a CALLBACK function that the system will need to call as part of the operation.  Such API functions as SetTimer, timeSetEvent, CreateThread, EnumWindows, LineDDA, even window message hand

Topic: C++ Programming LanguageTags: timeSetEvent, CreateThread, EnumWindows, LineDDA, CreateDialog, Windows API, CALLBACK, ThreadProc, WNDENUMPROC, EnumWindowsProc, LPTHREAD_START_ROUTINE, PFNLVCOMPARE

Views: 5224Comments: 4

How to use Script Component as Asynchronous Transformation

reza_rad04/16/2010, 12:00 AM

Suppose you have a flat file which is not delimited or fixed width or Ragged right. the structure of data is not well formed for Flat File Connection manager to read, This is an example of data file: date              : 04/14/2010 custome

Topic: SSISTags: SSIS, Script Component Transformation, Asynchronous Transformation

Views: 5222Comments: 6

Hex Maze Part 2

DanRollins09/24/2011, 12:00 AM

In Part 1 we covered the hexagonal maze basics -- how the cells are represented in a JavaScript array and how the maze is displayed.  In this part, we'll add logic to find the solution to the maze using a depth-first search, and we'll animate the ac

Topic: JavaScriptTags: JavaScript, hexagonal maze, maze solution algorithm, HTML, depth-first searching, Dan Rollins

Views: 5222Comments: 7

Submitting a multidimensional array from a form to PHP via POST

mltsy02/12/2010, 12:00 AM

After much searching on the subject myself, I've found that many people have wondered whether it's possible to submit a multidimensional array from an HTML form to a PHP script.  And for some reason, all the articles answering this query are convo

Topic: PHP Scripting LanguageTags: nested array, multidimensional array, PHP, form, POST array

Views: 5216Comments: 1

URL Routing with reverse rewriting with Framework 3.5 sp1

zadeveloper01/30/2010, 12:00 AM

Introduction This article will explain how to use URL Routing dot Net Framework 3.5 sp1 (and I guessing eventually framework 4) and C# ASP .NET. URL Routing is the ability to format your url strings into friendly names and using the data pass

Topic: Programming for ASP.NETTags: ASP C# URL Rewriting URL routing

Views: 5213Comments: 1

DATE and TIME ... don't be scared, and do it right (the first time)

angelIII09/10/2009, 12:00 AM

DATE and TIME ... don't be scared, just do it right DATE,TIME,MS SQL Server,MySQL,Oracle I presume you all have already worked with databases and queries, and found some difficulties to get the date/time stuff right. Though it's not rocket

Topic: Databases MiscellaneousTags: DATE, TIME, MS SQL Server, MySQL, Oracle

Views: 5209Comments: 32

Loading Advertisement...

Top Programming Experts

  1. CodeCruiser

    1,474,441

    Genius

    17,178 points yesterday

    Profile
    Rank: Genius
  2. Ray_Paseur

    1,239,842

    Genius

    3,744 points yesterday

    Profile
    Rank: Savant
  3. kaufmed

    1,043,915

    Genius

    7,080 points yesterday

    Profile
    Rank: Genius
  4. for_yan

    853,901

    Sage

    0 points yesterday

    Profile
    Rank: Genius
  5. slightwv

    840,473

    Sage

    3,900 points yesterday

    Profile
    Rank: Genius
  6. mbizup

    730,484

    Sage

    8,030 points yesterday

    Profile
    Rank: Genius
  7. sdstuber

    711,516

    Sage

    7,610 points yesterday

    Profile
    Rank: Genius
  8. capricorn1

    661,838

    Sage

    0 points yesterday

    Profile
    Rank: Savant
  9. leakim971

    595,749

    Sage

    10 points yesterday

    Profile
    Rank: Genius
  10. BuggyCoder

    589,408

    Sage

    3,000 points yesterday

    Profile
    Rank: Sage
  11. boag2000

    575,695

    Sage

    4,000 points yesterday

    Profile
    Rank: Genius
  12. mlmcc

    547,194

    Sage

    5,500 points yesterday

    Profile
    Rank: Savant
  13. DaveBaldwin

    470,294

    Wizard

    4,300 points yesterday

    Profile
    Rank: Genius
  14. jogos

    444,860

    Wizard

    0 points yesterday

    Profile
    Rank: Sage
  15. TheLearnedOne

    434,302

    Wizard

    8,600 points yesterday

    Profile
    Rank: Savant
  16. LSMConsulting

    420,775

    Wizard

    2,000 points yesterday

    Profile
    Rank: Savant
  17. Idle_Mind

    401,253

    Wizard

    8,000 points yesterday

    Profile
    Rank: Savant
  18. fyed

    391,241

    Wizard

    20 points yesterday

    Profile
    Rank: Genius
  19. acperkins

    386,983

    Wizard

    2,600 points yesterday

    Profile
    Rank: Genius
  20. ScottPletcher

    381,817

    Wizard

    0 points yesterday

    Profile
    Rank: Genius
  21. lcohan

    362,242

    Wizard

    5,400 points yesterday

    Profile
    Rank: Genius
  22. HainKurt

    356,835

    Wizard

    0 points yesterday

    Profile
    Rank: Genius
  23. ValentinoV

    349,025

    Wizard

    50 points yesterday

    Profile
    Rank: Genius
  24. matthewspatrick

    328,458

    Wizard

    210 points yesterday

    Profile
    Rank: Savant
  25. peter57r

    327,268

    Wizard

    0 points yesterday

    Profile
    Rank: Savant

Hall Of Fame