<div>
For mySQL, you can keep your field null by explicitly inserting the NULL value..<br />
<br />
Just check your values first :<br />
<br />
dim queryPhone<br />
<br />
If Request(&quot;txt_Phone&quot;) &lt;&gt;&nbsp;&quot;&quot; Then<br />
&nbsp; queryPhone = &quot;&nbsp;' &quot;&nbsp;&amp; Request(&quot;txt_Phone&quot;) &amp;&nbsp;&quot; ' &quot;&nbsp;&lt;--added quotes around the value<br />
Else<br />
&nbsp; queryPhone = &quot;NULL&quot; &nbsp;&lt;-- no quotes around NULL<br />
End If<br />
<br />
<br />
mystring = &quot;INSERT INTO MyTable(Name, Address, Phone) Values ('Bob', NULL, &quot;&amp;&nbsp;queryPhone &amp;&quot;)&quot;<br />
<br />

</div>


For mySQL, you can keep your field null by explicitly inserting the NULL value..

Just check your values first :

dim queryPhone

If Request("txt_Phone") <> "" Then
  queryPhone = " ' " & Request("txt_Phone") & " ' " <--added quotes around the value
Else
  queryPhone = "NULL"  <-- no quotes around NULL
End If


mystring = "INSERT INTO MyTable(Name, Address, Phone) Values ('Bob', NULL, "& queryPhone &")"



<div>
woops - this is in ASP code, but you should get the general idea.<br />
<br />
insert NULL<br />
not &quot;NULL&quot;
</div>


woops - this is in ASP code, but you should get the general idea.

insert NULL
not "NULL"

<div>
Thanks, but I was thinking more of a configuration issue. Just prevent null from being converted to an empty string in the first place.<br />
<br />
Any ideas?
</div>


Thanks, but I was thinking more of a configuration issue. Just prevent null from being converted to an empty string in the first place.

Any ideas?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a web application based on struts framework. My database table has some required fields and some nullable. The problem I have is if I leave the field in my web form empty, the application inserts an empty string (varchar) instead of a null value.<br />
<br />
How can I prevent the web application from converting the empty form fields to and empty string? I really need the fields to stay &quot;NULL&quot;.<br />
<br />
I am using stuts &amp;&nbsp;validator, velocity and hibernate<br />
<br />
thanks.
</div>
</div>


Hi,

I have a web application based on struts framework. My database table has some required fields and some nullable. The problem I have is if I leave the field in my web form empty, the application inserts an empty string (varchar) instead of a null value.

How can I prevent the web application from converting the empty form fields to and empty string? I really need the fields to stay "NULL".

I am using stuts & validator, velocity and hibernate

thanks.

Form: Empty String instead of Null (Struts/Java)

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.