Programming Support - Programming Help from Programming Experts

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: 70666Comments: 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: 34167Comments: 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: 26600Comments: 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: 22957Comments: 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: 21668Comments: 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: 19568Comments: 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: 16532Comments: 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: 15900Comments: 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: 15626Comments: 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: 15402Comments: 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: 15259Comments: 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: 14955Comments: 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: 14392Comments: 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: 14324Comments: 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: 14296Comments: 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: 13631Comments: 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: 13304Comments: 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: 12702Comments: 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: 11780Comments: 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: 11622Comments: 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: 11514Comments: 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: 11088Comments: 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: 10196Comments: 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: 10056Comments: 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: 9986Comments: 3
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: 9696Comments: 28
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: 9652Comments: 11
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: 9641Comments: 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: 9543Comments: 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: 9493Comments: 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: 9409Comments: 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: 8947Comments: 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: 8940Comments: 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: 8720Comments: 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: 8572Comments: 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: 8557Comments: 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: 8500Comments: 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: 8236Comments: 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: 8111Comments: 13
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: 8077Comments: 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: 8028Comments: 20
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: 8025Comments: 24
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: 7972Comments: 7
"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: 7907Comments: 21
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: 7874Comments: 8
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: 7831Comments: 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: 7738Comments: 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: 7680Comments: 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: 7503Comments: 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: 7361Comments: 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: 7340Comments: 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: 6976Comments: 18
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: 6917Comments: 10
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: 6874Comments: 2
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: 6844Comments: 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: 6827Comments: 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: 6744Comments: 8
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: 6723Comments: 20
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: 6718Comments: 10
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: 6587Comments: 37
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: 6565Comments: 9
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: 6365Comments: 20
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: 6365Comments: 23
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: 6340Comments: 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: 6319Comments: 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: 6300Comments: 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: 6230Comments: 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: 6210Comments: 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: 6191Comments: 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: 6163Comments: 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: 6149Comments: 17
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: 6143Comments: 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: 6131Comments: 28
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: 6121Comments: 6
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: 6109Comments: 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: 6040Comments: 14
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: 5991Comments: 43
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: 5968Comments: 8
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: 5950Comments: 9
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: 5925Comments: 16
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: 5887Comments: 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: 5883Comments: 30
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: 5864Comments: 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: 5792Comments: 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: 5701Comments: 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: 5615Comments: 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: 5511Comments: 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: 5499Comments: 13
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: 5454Comments: 31
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: 5436Comments: 17
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: 5387Comments: 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: 5366Comments: 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: 5257Comments: 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: 5243Comments: 22
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: 5213Comments: 7
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: 5203Comments: 6
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: 5198Comments: 1
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: 5181Comments: 1
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: 5179Comments: 4
Which STL Container? evilrix04/07/2010, 12:00 AM Included as part of the C++ Standard Template Library (STL) is a collection of generic containers. Each of these containers serves a different purpose and has different pros and cons. It is often difficult to decide which container to use and Topic: C++ Programming LanguageTags: stl container c++ vector deque list set map multiset multimap bitset Views: 5166Comments: 20

Top Articles

Top Programming Experts