Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-31 : 19:59:18
|
Joe writes "I have a form that I am having my users fill out. I want to know how they want to be contacted. So I have 4 checkboxes. If they leave a checkbox blank i get a server error stating:
Microsoft JET Database engine error '80004005'
Field 'contact.chkEmail' cannot be a zero length string.
here is my SQL statement.
set adoconn=server.createobject("adodb.connection")
adoconn.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\contact\contact.mdb;Persist Security Info=False")
ssql="insert into contact (fname,lname,email,title,cname,address,city,state,zip,dphone,fax,chkEmail,chkPhone,chkMail,chkFax,comments)"& _
"values('" & request("fname") & "', '" & request("lname") & "', '" & _
request("email") & "', '" & request("title") & "', '" & request("cname") & "', '" & request("address") & "', '" & _
request("city") & "', '" & request("state") & "', '" & request("zip") & "', '" & request("dphone") & "', '" & _
request("fax") & "', '" & request("chkEmail") & "', '" & request("chkPhone") & "', '" & request("chkMail") & "', '" & _ request("chkFax") & "', '" & request("comments") & "')"
if request ("SEND") <> "" then
adoconn.execute(ssql)
I have the database properties set to allow a blank field and is not required. what can i do?"
|
|
|
|
|
|
|
|
Blank field in Insert string