Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Making some fields required others not required

Status
Not open for further replies.

spencern

Programmer
Joined
Dec 20, 2001
Messages
78
Location
US
Just wondering if there is a way to make some fields that are being inserted into a database optional. Right now if i leave some fields blank with the site I'm making, it returns an error message.
Thanks
Spencer
 
If your database is returning an error on trying to INSERT a NULL value, then you need to set the field able to accept NULL values.

Needs to be done in your database.

If it's not your database returning the error, then post the error your page is returning.

:-)
paul
penny.gif
penny.gif
 
I'm using access 2000 for the db and all the fields accept username and password are set to not be required. Here is the message i'm recieving

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/registration.asp, line 116

Let me know how else I could fix this,
Thanks,
Spencer
 
Properties of your db field need to be set to "not required allow null values" from within access Live long and make your kids suffer..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top