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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
