Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- HELP!!! Conditional Formatting on an Access Data Page
- I have developed an Access Data Page (access2003) and I need to do conditional formating in a page depending on the scores from the fields in X table. I used the script from this MSDN article, http://msdn2.microsoft.com/en-us/library/aa139969(office.10).aspx#odc_customizecontrols_cf It works, BUT when there are Null values, I get a "Type...
- Tags: mjaimea07@..., NULL VALUE, Access Data, Microsoft Access
- Discussion threads 2007-10-26
- Exporting fields from SQL server with prefixes........
- HelloI'm trying to export some data with prefixed codes against each field. Which will be then imported into another legacy system using the codes as positional pointers.e.g:Name.......Address.......Location001Smith...002High St....003ManchesterThis I can do with no probs:SELECT'001'+Name,'002'+Address,'003'+LocationFROMTableNameHowever looking at the overall data export if there are NULL values in the data it correctly...
- Tags: Databases, dcleary@..., server, Microsoft SQL Server, NULL VALUE
- Discussion threads 2007-08-23
- Handling NULL values in SQL Server 2005
- In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare...
- Tags: Function, Microsoft SQL Server, Column, Microsoft SQL Server 2005, Value, Tim Chapman
- Blog posts 2007-08-06
- Finding the highest value in several SQL Server columns
- greatest at leastFiding the highest or lowest values in a row is something that I stumbled upon years ago.In my job I have to handle several RDBMSs, among them MSSQL, Oracle, Postgresql and MySQL.I added a couple of function in my MSSQL library named dbo.least(@n1,@n2) and dbo.greatest(@n1,@n2) since I...
- Tags: philippe.e@..., NULL VALUE, greatest, least, feedback, arg, Microsoft SQL Server, server
- Discussion threads 2007-02-27
- Understand the effects of NULLs on inner and outer JOINs
- For reader clarificationFor reader clarification, the reason you cannot join the value 1 with the value NULL is becuase the value NULL is unknown. You, and the system for that matter, will not know the value NULL until an explicit value is entered
- Tags: tim chapman, Value at Risk, software, NULL, NULL VALUE, NULLS, chapman.tim@..., foreign key
- Discussion threads 2006-11-28
- Define NULL
- since it came up in a discussion about sql.I figured I would ask here.what is the definition of NULL in sql,c, c++,java,perl,python.and from where do you get this definition?the discussion I'm pulling this querstion from:In SQL, NULL means "unknown value". How could you assert that two NULLs are equal?which doesn't...
- Tags: Define NULL, Jaqui, NULL value, programming, SQL, Value at Risk
- Q&A 2005-01-24
- Avoid a potential problem when searching for Null values with ADO
- Visual Basic for Applications VBA consistently supports a set of rules for using SQL WHERE criteria to search for data. If you're like most developers, you expect that set of rules to be supported in any library that Access supports. Unfortunately, you'd be wrong—once you leave the world of Access...
- Tags: Scripting languages, Databases, Susan Harkins, wherecondition argument, VBA, ActiveX Data Objects, NULL VALUE, Microsoft Access, SQL-WHERE
- Technical articles 2003-09-12
- Avoid Null value conflicts between Access and SQL Server
- Often, Access functions that you've come to depend on in regular usage aren't supported in an Access project (e.g., .adp file) that links to a SQL server database. Most of the time, though, there's an alternative Transact-SQL (T-SQL) function that's recognized by SQL Server. Such is the case with the...
- Tags: Databases, Microsoft Office, Susan Harkins, server, Microsoft SQL Server, NULL VALUE, Microsoft Access
- Technical articles 2003-05-20
Additional Resources
- Control null data in Oracle using the ORDER BY clause
- Related Tip (SQL*Plus Only)On a related point, I used to have problems distinguising between result sets with spaces in certain columns, and nulls in those columns (esp. when I wasn't ordering by them). Then I actually read Johnathan Gennick's book, and discovered that all I had to do was...
- Tags: psinger1, Oracle Corp.
- Discussion threads 2007-06-20
- 10 tricks for handling null values in Microsoft Access
- Have you ever run into problems caused by someone who neglected to accommodate null values? Are there any additional situations where you've had to work around or proactively handle null values to prevent errors?HmmWhere not(source.field) is null
- Tags: 10 things, JodyGilbert, Microsoft Access, Microsoft Corp., Null, software, sql, susan harkins
- Discussion threads 2006-10-12
- Evaluating Oracle Null Date in Crystal
- I am using Crystal Reports in Visual Studio 2003.I am unable to evaluate a null date/time in a formula field. All I want to do is :If date is null then "No" else "Yes";My unsuccessful attempts :1. "Is Null" errors out looking for a "Then" even...
- Tags: Crystal, Crystal Reports, Oracle Corp., programming, SpiderDad
- Q&A 2005-10-21
- Include Null values in calculated queries in Access
- About the NZ functionNZ is one of those VBA function that can be used when building expressions in the query grid.Although NZ stands for Null to Zero it can return another value too. Add a second parameter to NZ and specify the value returned if Null. Can be a number...
- Tags: Microsoft Access, daniel@..., Nz Function
- Discussion threads 2007-11-24
- Virtual Null Modem (exe)
- To emulate null-modem connection Virtual Null Modem can be effectively used. The program emulates one or more couples of RS-232 serial ports connected via virtual null-modem cable. It is possible to create the unlimited couples of VSP on a single PC without additional hardware and connect them in any sequence...
- Tags: Serial Port, Modems, Cable, Network Technology, Hardware, Components, Telecommunications, Personal Technology, Networking
- Software downloads 2005-08-17
- Accommodate Null values in Access queries
- Not getting the results you want can be frustrating. But if the problem is Null values, it's easily resolved. Use a simple expression to include or exclude Null. by Susan Harkins
- Tags: Microsoft Access, Portland, Seattle, Null, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-08-17
- null sessions
- I have a problem trying to connect a large format hp printer on my network, i need to add a shared folder into the registry of the network in null sesstions WHERE IS THE REGISTRY FOR NULL SESSIONS? :(
- Tags: andyharrop_11@...
- Discussion threads 2005-08-02
- 10 tricks for handling null values in Microsoft Access
- Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you understand and effectively address null values in various situations. Database expert Susan Harkins explains a...
- Tags: Microsoft Access, Microsoft Corp., Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2006-10-12
- Save time and prevent coding headaches with nullable types in C# 2.0
- Before C# 2.0, the inability to assign a null value to some types was a headache for developers. This limitation forced developers to come up with their own solutions and workarounds for setting a non-nullable variable to null. In C# 2.0, Microsoft remedies this situation with the addition of nullable...
- Tags: C#, .Net, Programming Languages, Software Development, Software/Web Development
- Download resources 2006-08-03
- SQL in MS Access
- I am looking for help on a specific SQL query in MS Access. I keep running into syntax errors. I have 4 fields in the query. When the data I'm querying is LIKE the data in field 1 AND the data in field 3 and/or 4 IS NULL or BLANK,...
- Tags: Microsoft Office, Databases, kms_cryswater@..., Microsoft Access, Field 3, SQL, Microsoft Corp.
- Discussion threads 2007-07-02
- Understand the inner workings of generics in Java
- mentionnice article.Message was edited by: beth.blakely@...RE: Understand the inner workings of generics in JavaWhen You say "writing non-null elements to the list is not allowed" does it mean You can not write anything but null value to the List ? Or I am missing something...A typoThis is atypo, thanks. What...
- Tags: Programming languages, teksty32@..., Java
- Discussion threads 2007-08-23
- Power Linux with pipes and redirection
- more on redirecting standard output and errorThe order of redirection in the case of redirecting standard output and error is important depending what you want. If say you want to get rid of all messages from a command the correct way is:> /dev/null 2>&1which send all output to the bottomless...
- Tags: Microsoft Windows Vista (Longhorn), Microsoft Windows XP, stomfi@..., Linux, redirection
- Discussion threads 2007-10-16
- << Previous
- page 1 of 1
- Next >>
