89 Topics

Member Avatar for
Member Avatar for JModak

All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu

Member Avatar for john_111
0
4K
Member Avatar for Reverend Jim

I have been using my HOSTS file for years to dummy out ad sites by adding entries like 127.0.0.1 www.ukbanners.com A while back I installed [Unchecky](https://unchecky.com/), a program which automatically unchecks all of those software extras that some installers like to enable by default (like McAfee). Today I noticed nthat …

Member Avatar for Reverend Jim
0
1K
Member Avatar for nitin1

Hi, I am facing an issue in string to const char pointer conversion. I am doing stuff in the fun() but here i am just giving my example. Here it the code: // Helper function string fun() { string abc = "Daniweb"; // print here #1 return abc; } // …

Member Avatar for AssertNull
0
3K
Member Avatar for enakta13

I have a char array which need to check each and every character untill there is no more character to check, so in C usually we write as: for(i=0;my_num_Array[i]!='\0';i++) { // some code here } But when i tried the same for java it isn't working! Any idea what should …

Member Avatar for Stungkuling
0
16K
Member Avatar for Amiet_1

Guys I want to insert a Null dateTime Value into SQL database connected to C# desktop application. I'm using following code. I can insert Null dateTime Value into database, but I am having problem with how to update dateTime picker value and saving it into database.. I'm posting my code …

Member Avatar for Amiet_1
0
6K
Member Avatar for Sutarusu

Ok, here is what I get when I run the query. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near newmessage`int(4) unsigned NOT NULL DEFAULT `0`,`companyi' at line 4 Here is what …

Member Avatar for Sutarusu
0
2K
Member Avatar for olegb

SQL Gurus, help !! I have a table with 3 fields, ID, Answer_5, Answer_6. Answer_5 & Answer_6 both hold a date value, but the fields are defined as string (for other reasons). In Answer_6 it is possible to have the string of 'Now'. I am trying to do a simple …

Member Avatar for AleMonteiro
0
350
Member Avatar for Papa_Don

I'm writing a routine where the user can populate up to 8 textboxes with numbers. Since there is potential for these numbers to be unsorted, I want to sort these prior to saving. However it's probable that all of the textboxes will not be used. My challenge then is how …

Member Avatar for Minimalist
0
678
Member Avatar for Tinnin

Hi All, I'm not sure if this is a technical issue, preference or a question about best form. I have a 'users' table and a 'contacts' table. 'users' and 'contacts' have no direct relation. Both contain an email address for each record in their own table. I want to send …

Member Avatar for Tinnin
0
335
Member Avatar for dippy78

Hi, Need help on exporting data to csv from oracle database when i export ... the field which has null values (in database) appear as 'null' word in the csv output. Is there a way to avoid it? thanks

Member Avatar for jwenting
0
300
Member Avatar for Sadaf_1

Salam... I have SQl Database...And i am using visual basic 2010 i have a problem with Null values.When in my database data have some null values then data not showing in my crystal report ...crystal report showing blank..I want '0' when data is null..for example my table name is (meetings …

Member Avatar for Reverend Jim
0
337
Member Avatar for burhanahmed92

I want to null or remove array at the end of each loop. I already tried unset() or $array=array(); but its not working foreach($array as $key=>$value){ $dates[$value][]= $key; unset($dates) } Just tell me php function to null all array

Member Avatar for diafol
0
337
Member Avatar for Lethugs

Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records …

Member Avatar for Lethugs
0
345
Member Avatar for blueguy777

The following code unable to insert null or blank value into table called custreg i.e. $sagentid and $sagentname. if(isset($_POST['Submit'])){ $reg_no=$_POST['reg_no']; $firstname=strtoupper(str_replace(',', '' , $_POST['firstname'])); $lastname=strtoupper(str_replace(',', '' , $_POST['lastname'])); $mobno1=$_POST['mobno1']; $mobno2=$_POST['mobno2']; $address=strtoupper($_POST['address']); $city=strtoupper($_POST['city']); $dateofjoin=$_POST['dateofjoin']; $regfee=$_POST['regfee']; $magentid=$_POST['magentid']; $sagentid=$_POST['sagentid']; $skimcity=$_POST['skimcity']; $skimyear=$_POST['skimyear']; $skimname=$_POST['skimname']; $cust_fullname = $firstname.' '.$lastname; $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = …

Member Avatar for jstfsklh211
0
6K
Member Avatar for Doogledude123

I created a custom 'text menu' that should print each String passed to it. This is the class: package com.github.geodox.areacalculator.menu; public class Menu { private static int index = 0; private static String[] menuItems; public void addItem(String menuItem) { menuItems = new String[index+1]; menuItems[index] = menuItem; index++; } public void …

Member Avatar for Doogledude123
0
253
Member Avatar for CoolAtt

Hi All, I got this code from a forum & tried it on g++/Linux. In the code below i put NULL to a pointer variable but didnt get any errors. #include <iostream> using namespace std; class A { private: int _dmember; public: void func() { cout<<"Inside A!! "<<endl; cout<<_dmember; // …

Member Avatar for CoolAtt
0
309
Member Avatar for simran_4

Hello all, I am stuck with a nullpointerException at line 41 and 60.Can someone please help me out.any kind of help will be appreciated. Thanks import javax.swing.*; import javax.swing.event.*; import java.awt.Color; import java.awt.*; class calenders extends JFrame { int i=0; int j=0; int k=0; JFrame jf; FlowLayout fl; JPanel jp[]; …

Member Avatar for simran_4
0
557
Member Avatar for Derek_4

I know I am probably over thinking this but I cannot seem to figure this out. I am trying to check if the value is null and if not to continue. /** * */ public Item getItem(String theItem) { Iterator iter = myItems.iterator(); while(iter.hasNext()) { Item anItem = (Item) iter.next(); …

Member Avatar for sebastianedu
0
294
Member Avatar for cereal

Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) …

Member Avatar for cereal
1
4K
Member Avatar for red_ruewei

Hi, I'm sorry if I had post duplicate post. I had join this 2 table (dt_dict_tbl - store dictionary, sdn5_5 - store accumulate value for reporting). Here the table structure **dt_dict_tbl** CREATE TABLE `dt_dict_tbl` ( `dtDictCode` VARCHAR (30), `dtDictDesc` VARCHAR (600), `rptCode` VARCHAR (30), `rptSubCode` VARCHAR (30), `dtCreatedDate` TIMESTAMP , …

Member Avatar for red_ruewei
0
458
Member Avatar for robgeek

Hey everyone, I was attempting to get the lastmodified file from a folder, and to do so I used File.listFiles() method which is returning a null pointer exception even though the folder is not empty. I had this piece of code working about two days ago and I am not …

Member Avatar for sirlink99
0
8K
Member Avatar for pradap.adwani

For me getting same result (all the text box are null value is filled) after move the textboxes after calling request.getParameter() also... What i need to change it? Where i need to edit? # **First Jsp Page** # <%@ page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%> <HTML> <HEAD> <TITLE>Fetching Data From a …

Member Avatar for peter_budo
0
2K
Member Avatar for STP_Captain_Slo

Hi I have a set of Checkboxes each with a Textbox next it to. I have the following code, which is meant to loop through each CheckBoxe and if checked if gets the text contained in the textbox, these are linked through the tag of the checkbox, i have used …

Member Avatar for rathideva
0
2K
Member Avatar for Black_Lion

Hi all. I have run into a problem with inserting values into table. I have 2 tables: PUBLISHER with fields: PUBLISHER_CODE (Primary Key) and PUBLISHER_NAME. BOOK table fields: PUBLISHER_CODE (Primary Key and Foreign key to PUBLISHER table) and TITLE. The user enters bookCode and publisherName into 2 textboxes Here is …

Member Avatar for JorgeM
0
247
Member Avatar for divin757

When I click the login button I never get any values posted to the server. I accept a AuthViewModel but it is always null. I have tried using @html.EditorFor but have not had any luck with it. **User Controller** [HttpGet] public ActionResult Password() { UserModel user = (UserModel)Session[Constants.SessionVars.Authenticate]; //error - …

Member Avatar for BMXDad
0
605
Member Avatar for ryan311

I always getting this error in my dropdownlistfor: Value cannot be null. Parameter name: items View code: @Html.DropDownListFor(model => model.SiteId, new SelectList(ViewBag.ListSiteClass, "SiteId", "SiteName"), "", new { @onchange = "GetSiteid(this.value);" }) Controller Code: [HttpPost] public ActionResult Create(ServiceDTO ms, FormCollection form) { if (ModelState.IsValid) { int sid = ms.SiteId; ServiceDAO.Insert(sid); } …

Member Avatar for ryan311
0
12K
Member Avatar for owenransen

Writing an upgrade to my program I'd like to start using the nullptr, a cleaner replacement to NULL. My question is can I use it everywhere, for example in checking the strstr return value? if (strstr(szLong,"tag") == nullptr) Presumably will work as well as if (strstr(szLong,"tag") == NULL) ?

Member Avatar for Tumlee
0
687
Member Avatar for Fiorentino01^

Hi I am running phpMyAdmin 5.6. I have created a table as described in a tutorial. This table is supposed to have a null value in a text field, I cannot do it, I tried everything.The examples on the web refer to older versions and I keep getting error.I even …

Member Avatar for Fiorentino01^
0
288
Member Avatar for chandub

hi. when a user request hits the ActionForm's validate method (struts)and bounces back, i'm loosing some request attributes that i had set for the page. In other words, if the user inputs some data that don't pass the validate method, the page comes back with a few request scope attributes …

Member Avatar for LastMitch
0
209
Member Avatar for sundog1

Hi guys... I have a radio button that one checked will connect to an ADO Connection. The following code being used is: private void radioButton3_CheckedChanged(object sender, EventArgs e) { //Fields Disabled until a new Account is created.// txtAccRef.Enabled = false; txtAccName.Enabled = false; txtAccAddr1.Enabled = false; txtAccAddr2.Enabled = false; txtAccTown.Enabled …

Member Avatar for sundog1
0
347

The End.