Prevent Empty Parameters from Automatically Converting to Null
You can define parameters for the SqlDataSource control. If a parameter value is an empty string, the driver automatically converts that into a NULL value, which can lead to unexpected
You can define parameters for the SqlDataSource control. If a parameter value is an empty string, the driver automatically converts that into a NULL value, which can lead to unexpected
Oftentimes, cursors are used to concatenate multiple columns into one string. For instance, you may want something like this to show as ‘A,B,C’ on your report (Table table_A): Id Char_Value1
If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and
This algorithm helps you to retrieve all the elements contained in the first set (set1), but not in the second (set2). Here’s the template: templatevoid Diff(const T& set1, const T&
orporations encounter various scenarios in which they need parallel processing to achieve high throughput and better response times. For example, various financial institutions perform reconciliation as batch jobs at the
uilding enterprise Java applications is a challenging process in which you build, package, and deploy multiple components to a variety of environments. And these components will frequently depend on one
This installment of “The Baker’s Dozen” presents a Windows Forms database application that demonstrates some of the primary attributes of a distributed architecture. These attributes include authentication and connectivity, data
ey there! This month, I’m bringing Ambrose Little on board and we’re starting a new column entitled “angryCoder vs. dotNetTemplar.” In each issue of CoDe Magazine, we’re going to debate
any experienced developers loathe changing their DTDs (Document Type Definitions) because of their cumbersome syntax and semantics. For newcomers, DTD syntax just looks like Greek. A brand new addition to
# is a small language. It doesn’t support writing regular expressions, for example, or accessing a relational database, or even using simple data-structures like stacks, queues, and lists. Of course
att Mannion is an Engagement Manager for Clarity Consulting Inc., a Chicago-based technology consulting firm and Microsoft Gold Certified Partner. Matt has delivered many large-scale, WinForm and WebForm systems for
ast week was the end of an era for me. I was lucky enough to see Revenge of the Sith in an audience that included BillG (Bill Gates) himself. I
ea, I know. English is a living language, but there have to be some rules. You can’t just make up words. You can’t make up ways to use those words.
ulti-criteria search functionalities, which allow combinations of many optional criteria fields, are common in modern Web-enabled business applications (see Sidebar 1. When to Use Multi-Criteria Searches). An example of this
adio frequency identification (RFID) technology is rapidly becoming ubiquitous as businesses seek to streamline supply chains and respond to mandates from key customers. But RFID and other new wireless ID
ager to gain momentum in the creation of software that facilitates local search and geo-centric applications, Microsoft has released a new version of its mapping software?not only with speed and
If you set the TextMode property of a TextBox Web control to “Password,” any default value you assign to the TextBox won’t show up. To work around this problem, add
Suppose a CVS -n update throws the following error: cvs update: inflate: unknown compression methodcvs [update aborted]: reading from server: Input/output error When you use the -n option, there’s a
Between two tables of similar size, a merge join is the best possible join an optimizer can choose. If you have clustered indexes on the join columns, the optimizer will
import com.ibm.mq.*; public class MQPutGet{ private String qManager = “QMGRname”; private String qName = “QUEUEname”; private MQQueueManager qMgr; // define a queue manager object public static void main(String args[]) {
have tried?quite hard at times?to rely on Eclipse as my main Java IDE, but I have been unable to because, simply stated, Eclipse hasn’t met the evolving needs of Java
The main reason to pass parameters by value is to improve performance, which is somewhat of a paradox, because this is also one of the main reasons to pass by
ast month I tried to encourage readers to embrace a couple of simple math concepts to expand the ol’ ActionScript skill set. I tried to show that by understanding some
equence diagrams are used to map out class interactions. A sequence diagram is made up of objects, each with its own object lifeline. Interactions between the objects occur by messages
here’s two things that most developers are (or should be) excited about in the upcoming Vista version of Windows (formerly codenamed Longhorn), and one of them is Avalon. Avalon is
ost enterprise applications today use database systems to persist data, and they utilize these data for various organizational needs. Often these applications need to store, retrieve, and manipulate date and
s Web applications become more sophisticated, developers increasingly need to be able to incorporate dynamic graphics and animation. Unfortunately, Web browsers were originally designed to display static HTML; displaying dynamic
ML Encryption provides end-to-end security for applications that require secure exchange of structured data. XML itself is the most popular technology for structuring data, and therefore XML-based encryption is the
One of the challenges of cross-platform development is managing your build environment. With so many platforms these days using the combination of Microsoft Visual Studio and an emulator to facilitate
JAX is catching on, but handling multiple XML responses on the client side is difficult. Current methods of easing the hassle ignore important programming principles that are known to help