Topic profile page for Null value.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Null value.
Topic "Null value" was discussed 2,616 times on 246 sites in last 3 months
Started 4 days, 7 hours ago (2009-12-03 17:48:00)
by ducky1977
Hi Everyone, I am developing a small app in access 2003 to track ongoing projects and keep getting the following error: you tried to assign the null value to a variable that is not a variant data type This error comes up in twice in 2 different subforms off the main data entry form. In both instances the subforms are built based on 2 separate tables (a table tracking financial ...
Started 4 days, 21 hours ago (2009-12-03 03:50:00)
by Engr.M.K Chowdh...
Dear All, I have created a RADIO GROUP from LOV. when i am assigning this RADIO to a variable in PL/SQL block ..it's return NULL to variable .. declare v_sql varchar2(4000); v_w varchar2(200); v_rc number(3):=NV('P111500_G_RCSTATUS'); begin ... end; How can i get actuall RADIO value ? Thanks Engr.M.K Chowdhury...
Started 1 week ago (2009-12-01 00:00:00)
by Scottgem
Sir, I have table having 6 fields i.e. Year_From,Year_To,March,April,May,June. 2003 2004 10 10 2004 2005 10 2005 2006 10 10 10 10 The Exact figure you see above there is three accounting year and suppose figure ten is given in either months and any months have no figure. I want to get SQL queries in Access to get Total amount in four ...
Started 1 week ago (2009-11-30 20:15:00)
by roamer
Hi, tough, I am writing codes to get Result List via JpaController + Persistence using NetBean. I got a strange behaviour, that is if I tried to "find" the ResultList at the 2nd time via the data (as argument) got in the 1st ResultList, the 1st object value of the List returned is always null, while the rest are fine. Here is some segment of codes below: public static void...
Started 1 week ago (2009-11-30 03:24:00)
by michael.oh
I have the two table that can be left outer join but result is not what I expected. The 'BOM_YM' colume have null value. Can you give me the reason? It should be all 'Y' if keyvalue is existed? This is query select * FROM human.TBL_ITEMCODE A, (SELECT KEYVALUE, 'Y' AS BOM_YN FROM human.TBL__SYSTREE__ WHERE ...
Started 1 week, 4 days ago (2009-11-27 01:13:00)
by Sheenas
Hi, can we assign null value to value type in c# ? I want to know this. I am beginner in c#. And getting error while doing this. I want to know that this is possible or not. If not then I can try for some other trick, so please reply me as soon as possible.
Started 1 week, 5 days ago (2009-11-25 06:28:00)
by user5737516
Hi All, I have this simple query: SELECT NULL as pay_period FROM DUAL UNION SELECT DISTINCT pay_period FROM period_table All I wanna do is to display the NULL value first before everything else. I've tried doing order by and everything else that I could think of but it didn't work. Any ideas? Expected Output: {null} 1 2 3 4 5 etc......
Started 1 week, 6 days ago (2009-11-24 13:17:00)
by blackhorse
find records in t1 but not in t2, but has null value Code: SELECT column1,column2,column3 FROM t1 WHERE (column1,column2,column3) NOT IN (SELECT column1,column2,column3 FROM t2); I can use this query to find records in t1 but not in t2. But this query only will work if column1, column2, column3 are ...
Started 2 weeks ago (2009-11-23 07:54:00)
by phoenix75
Hi all, On SSRS, i draw a table and drop the field from my dataset onto it In one cell, some of the results (come from OLAP cube, a date dimension) are empty. So I would like to check this value, and write an calculation result on this cell instead of the date field. I use this vb expression : =iif(FIELDS!Date_2.Value= "" , "" ,datediff( "d" ,now(),FIELDS!Date_2.Value)) I ...
Started 2 weeks, 1 day ago (2009-11-23 00:41:00)
by arcanedevice
Hoping someone can guide me through this. I have an Access table that has a number of date columns that are 'Text' but with a custom format of 'dd mmmm yyyy'. I also have one form in my application that has a DataGridView that is populated by data from this table, and the data is displaying correctly when called from the table. I then have a second form in my application which I want to ...
Started 1 week, 1 day ago (2009-11-30 01:16:00)
by sharepoint_techie
We are receiving the following error message in MOSS 2007 when trying to approve some workflow items: "Value cannot be null. Parameter name: serverContext" Our SSP seems to be properly configured & is not giving any error messages. Could we be missing on any other settings? Thanks, SharePoint Techie
Started 6 days, 15 hours ago (2009-12-01 10:02:00)
by Lily Wu
Hi, Is it an OOTB workflow or custom approval workflow? In addition to Ashwin’s suggestion, you can also look into the ULS log for more information about this issue. Best Regards.
Started 3 days, 6 hours ago (2009-12-04 19:02:00)
by dbadip
I'm getting an error "Value cannot be null. Parameter name: sddlForm" when trying to remove an instance in SQL Server 2008. Has anyone had this issue before?
Started 6 days, 23 hours ago (2009-12-01 01:25:00)
by Avinash Tripathi
Hi, Yes Oracle 8i is unsupported and outdated version, you should upgrade it. However this problem seems to be data issue rather than DB issue. Cheers, Avinash
Started 5 days, 6 hours ago (2009-12-02 18:56:00)
by eliasen
Hi I have created a smalle example, where I am testing the table looping functoid when elements are present and when they are not present. I cannot reproduce your scenario. If I am to help you anymore, I need to see the solution. Thanks.
Started 3 days, 16 hours ago (2009-12-04 08:28:00)
by Engr.M.K Chowdh...
Hi, i have a share component (LOV) & i have created this radio group base on this LOV. "page applyed change" & when i run page then variable get NULL value from radio group. Thanks Engr.M.K Chowdhury
Started 3 days, 14 hours ago (2009-12-04 10:57:00)
by Colin_L
Yep, ActiveX checkboxes can have 3 values (True, False and Null). To allow a user to select all three values, the checkbox's TripleState property needs to be set to True. Even with the TripleState property set to False, the Null value can be assigned programmatically (as you will have seen when you tried Me.hcc.Value = ""). If you want to clear all the checkboxes then you need to loop ...
Started 1 week, 1 day ago (2009-11-29 19:33:00)
by r937
Quote: Originally Posted by vigneshr35 But the Query that you have suggested does not provide me the result that I require. the query he provided gives exactly the result set you said you wanted here, you may borrow this code and test it for yourself -- Code: CREATE TABLE table1 ( f1 INTEGER , f2...
Started 4 days, 19 hours ago (2009-12-03 05:32:00)
by sharepoint_techie
Thanks for your advice but this didn't made any difference. It seems strange but SSP seems to be running perfectly & SharePoint Logs are not displaying any specific error messages (other than generic error messages)...
Started 4 days, 3 hours ago (2009-12-03 21:38:00)
by broro183
Jrdnoland's response covers off your situation, but for interest sake - you can test for null in other situations by using Code: if isnull(RegionSelect.Value) then 'bypass everything...? else 'do something else? end if hth Rob
