Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
ASPProtect Full 7.x Support (Info Locked Info Locked)
 CJWSoft Support Info : ASPProtect Full 7.x Support
Subject Info: Validated Field A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
afifm
New User
New User


Joined: August/27/2004
Location: United States
Online Status: Offline
Info: 15
Added: April/10/2007 at 8:20am | IP Logged Quote afifm

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
Back to Top View afifm's Profile Search for other info by afifm
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: April/10/2007 at 10:56am | IP Logged Quote cwilliams

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
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 
afifm
New User
New User


Joined: August/27/2004
Location: United States
Online Status: Offline
Info: 15
Added: April/10/2007 at 12:50pm | IP Logged Quote afifm

That worked. Thanks.Smile

__________________
Best regards,

Mo
Back to Top View afifm's Profile Search for other info by afifm
 

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

  A d d  -  P o s tAdd P o s t
Printable version 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


Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com