Making some fields required others not required

[spencern]

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

 

[link9]

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

 

[spencern]

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

 

[Cheech]

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..