We're adding some views to our entity framework model. Some fields in these views are nullable datetime2 datatypes in our sql server 2k8 db and the edmx is incorrectly showing these fields as being not null. Is this a known issue? When I try to change them to not null it still throws the same error - because it appears as if the ssdl is...
Hi, I want to validate the xml requests received in my WCF webservice. I created business classes by converting the xsd's to code with Xsd2Code.exe (Xsd2Code@Codeplex). Q: Why does the validator not fire when Element BrancheInfo is null? Validation functions: /// <summary> /// If a servicerequest enters our domain, we have to...
I have a string value read in from a CSV file. The CSV file contains 7 NULL bytes, I have confirmed this by opening it in a hex editor and sure enought there are 7 0x0 bytes in there. This string is causing me pain. In vb.net when I check the strlen of this string it returns a value of 7 and if i do a String.IsNullOrWhitespace it return...
Hi All, I'm getting an error when selecting from a rows.AsEnumerable(). I am using the following code... var rows = ds.Tables[0].AsEnumerable(); trafficData = rows.Select(row => new tdDataDC { CalculationCount = row.Field<Int64>("biCalculationCountSeqID") , Zone =...
An application I inherited tracks lab test results performed on material samples. Data is stored in a single table (tblSampleData) with a primary key of SampleID and 235 columns representing potential test results. The problem is that only a few tests are performed per sample, so each row contains over 200 nulls. Actually, there is a sec...
How to get control in ASP.NET PreInit event? Pointers are null and FindControl method returns null. I am using master and content pages. Markup of the content page looks like this: <asp:Content ID="Content2" ContentPlaceHolderID="ContentBody" runat="server"> <asp:Table ID="Table1" runat="server" Width="100%"> ..... </asp:Ta...
{ MESSAGE = LoginWelcomeBackMessage; SUCCESS = 1; USER = { AcceptAllFriendRequests = 0; CreateDate = "June, 07 2010 00:00:00"; DayOfBirth = "April, 24 1974 00:00:00"; UserName = "Erik Madsen"; }; } My CFC defines all the columns in my database table, but when a column is NULL, the field isn't returned as a property ...
Hi. I've got the following SQL table: CREATE TABLE [dbo].[Test]( [TestID] [int] NOT NULL, [TestNum] [int] NULL, [TestReason] [varchar](50) NULL ) So TestNum an INT which allows NULL values, and I've inserted a whole lot of data into the table, of which some of the rows contain a NULL value for TestNum If I then run the fo...
I am still learning SQL so this may seem a very odd question, but is this the best way to use CASE within a CASE to check for NULL? @FN_InputDt datetime) RETURNS varchar(3) as BEGIN DECLARE @Result varchar(3), @MonthNo int Set @MonthNo = datepart(m,@FN_InputDt) Set @Result = CASE WHEN @FN_InputDt IS NOT NUL...
What should I type (in both cases) in my app.config's applicationSettings section so that, when I read Settings, I can get the following: Settings.Default.FooString == null Settings.Default.FooString == string.Empty ? I guess there is no way to achieve both situations, or am I missing something? Diffrerenciating whether string valu...
Here's the relevant code: Public class User.cs: public void FindByID(int id) { Parser parser = new Parser(id); ID = parser.FindID(); Name = parser.FindName(); Rating = parser.FindRating(); Photo = parser.FindPhoto(); Reputation = parser.FindReputation(); ...
Array ( [sEcho] => 1 [iTotalRecords] => 7521 [iTotalDisplayRecords] => 1 [aaData] => Array ( [0] => Array ( [0] => Nordic Capital Buys SiC Processing [1] => 2010-06-21/nordic-capital-buys-sic-processing [2] => PEHub Media ...
I am trying to suma column in a table, while excluding certain records that have the paid field set to true. I am doing so like this: SELECT SUM( cost ) AS total FROM sales WHERE passport = 'xxxxx' AND paid <>1 The table is full of data, and I can display costs by themselves, or the entire total. Just adding on AND paid <>1 Is w...
I know a 3x3 matrix M, and I want to find a 1x3 matrix P. The given condition is: [p1 p2 p3]*[m11 m12 m13; m21 m22 m23; m31 m32 m33] = [0 0 0] Given is [m11 m12 m13; m21 m22 m23; m31 m32 m33] I have to find non trivial (non-zero) solution of [p1 p2 p3] using Matlab. I am wanting to be done in Matlab because its part of a code. If ne...
what does "delete from table where NULL = NULL" means ? ...
Hi, I've created a simple upload-form and got a little problem when submitting the data. The file is uploaded correctly, but my little description field stays null. Here's my form: class Upload_Form_Uploadvideo extends Zend_Form{ public function init() { $this->setName('video') ->setAction('interface/videoupload') ->setMet...
Hello, after the EndEdit I want to do some validation like is data entered null... if there is no endedit, the data I get could be the old/unchanged value... My BindingSource has a DataSet bound. What can I do? ...
I'm trying to select from XML that has a null as one of the attributes. Instead of returning a null, it returns a 0. What am I doing wrong? See code below to replicate: declare @a xml select @a = '<TestSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instace"> <Element> <Property1>1</Property1> <Property2>1</Property2> <...
I want a servlet to print the parameters from a html form but in the servlet the request has no parameters. <form method="post" action="LoginServlet" > <input type="text" name="username" id="username" /><br/> <input type="text" name="password" /><br/> <input type="submit" /> </form> and the servlet's doPost(): protected v...
I want to check if a reference type is null. I see two options (_settings is of reference type FooType): if (_settings == default(FooType)) { ... } and if (_settings == null) { ... } How do these two perform differently? ...