CJWSoft Support Info: Validated Field

Active Info

Memberlist

Help

ASPProtect Full 7.x Support ( Info Locked)
CJWSoft Support Info : ASPProtect Full 7.x Support

Info: Validated Field

Author

Message

<< Prev Info | Next Info >>

afifm
New User

Joined: August/27/2004
Location: United States
Online Status: Offline
Info: 15

Added: April/10/2007 at 8:20am \| IP Logged

I am trying to add new members from this page http://www.MyDomain.com/auth/password_admin/edit.asp?Action= New_User

and receiving this error:

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Validated', table 'PegaWorld.dbo.ASPP_Users'; column does not allow nulls. INSERT fails.

/auth/password_admin/save.asp, line 385

Ideas?

__________________
Best regards,

Mo

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: April/10/2007 at 10:56am \| IP Logged

go into the sql database and change the "validated" field to have a default value of 0

It is supposed to be set that way.. if it is not that tells me you may have not have created the sql database using the provided sql script which set a ton of specific values on certain fields in the sql database

__________________

Best Regards, Christopher Williams www.CJWSoft.com

afifm
New User

Joined: August/27/2004
Location: United States
Online Status: Offline
Info: 15

Added: April/10/2007 at 12:50pm \| IP Logged

That worked. Thanks. Smile

__________________
Best regards,

Mo

Sorry, you can NOT post info.
This info has been locked by a info administrator.

Printable version

Info Jump

You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area