...

View Full Version : Cannot be zero-length error message



SteveH
12-21-2007, 02:56 PM
Hello

I have a form which should insert data into an MS Access 2000 database, but I am getting the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Field 'users.fullname' cannot be a zero-length string.

/myFlash/welcomeFlash.asp, line 20

However, I have just ensured that all fields allow zero-length values, uploaded the database again and still get the error message. When I look at the database online, I see that all fields are 'nullable'.

The script above refers to line 20 of my welcomeFlash.asp file which is:

<% @ Language=VBScript %>

<%
' Declare variables

Dim fullname,email,subject,country,message

'Get form field values from flashEmailTest.asp file

'Open MS Access database, store form field values, and close

set conn=Server.CreateObject("ADODB.Connection")

conn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Flashform.mdb;"
set rs = Server.CreateObject("ADODB.recordset")

SQL="INSERT INTO users (fullname, email, subject,country, message) VALUES ('" & _
fullname & "', '" & email & "','" & subject & "', '" & country & "', '" & message & "')"

rs.Open SQL, conn

Set rs=Nothing

conn.Close
Set conn=Nothing
%>

The formFlashTest.asp file referred to in the script above (and which gives me the same error message) is simply this:

<%@LANGUAGE="VBSCRIPT"%>
<%
Option Explicit
Response.Buffer = True
%>
<%
Dim fullname,email,subject,country,message

fullname = Request.Form("name_txt")
email = Request.Form("email_txt")
subject = Request.Form("subject_txt")
country = Request.Form("country_txt")
message = Request.Form("message_txt")

Server.Transfer "welcomeFlash.asp"

%>

I would be grateful for any assistance.

Thanks.

Steve

SouthwaterDave
12-23-2007, 01:59 PM
A zero-length string is not NULL.

The field needs the "Allow zero length" attribute to be set to "Yes".



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum