struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sudheshna aaa" <sudhes...@hotmail.com>
Subject RE: how to insert null using sql query in java code
Date Tue, 27 Apr 2004 17:18:46 GMT
Try checking the variables for null and if null put emtpy string

Something like this:
(webpurchased == null)?"":webpurchased


>From: Jignesh Patel <jpatel@bangracing.com>
>Reply-To: "Struts Users Mailing List" <user@struts.apache.org>
>To: "Struts Users Mailing List" <user@struts.apache.org>
>Subject: how to insert null using sql query in java code
>Date: Sun, 25 Apr 2004 14:33:05 +0530
>
>Hi All,
>I am following query to insert value in databse now suppose value of
>"webpurchased","targetadvt" and 'trial" is null then how can I can insert
>same null value in database.
>Because my parameter is like String webpurchased=null --In this case value 
>of
>webpurchase will be replaced by string 'null' while insering, which is
>meaning less. I want to insert real null.
>
>MY query:
>    		stmt.executeQuery("INSERT INTO advt_spns_soln VALUES "+
>		 "(advt_spns_soln_id.nextval,'"+firstName+"','"+lastName+"','"+title+ 
>"','"+
>company+"','"+companyAddress+"','"+city+"','"+stateId+"',"+postalcode+",'"+
>country+"','"+email+"',"+phone+",'"+url+"','"+campaign+"','"+webpurchased+"','"+
>targetAdvt+"','"+trial+"','"+budget+"','"+marketobjective+"','"+emailupdate+"')");
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>For additional commands, e-mail: user-help@struts.apache.org
>

_________________________________________________________________
>From must-see cities to the best beaches, plan a getaway with the Spring 
Travel Guide! http://special.msn.com/local/springtravel.armx


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Mime
View raw message