Ah, great, my complete explanation on modding the register.asp also took a great deal of time to pass moderator(s) censorship, that's why all the out of sync replies.

Glad it's working for you also.

oh no  it`s working fine, I posted my previous message before you post, The moderator did not accept it

its good and work fine thank you so much buddy

It shouldn't give any errors after my code has been properly inserted, my code caters for the fact that the SQL database in particular the tblAuthor is expecting some default values.

Note one of your errors: " Cannot insert the value NULL into column 'PM_notify', table 'forum03.dbo.tblAuthor'; column does not allow nulls. INSERT fails. "

My code adds the default value of '0' to PM_notify so it won't error out.

I have been using the simple reg form ever since you asked for it, and my users are happily reging, no errors, no problems.

Are you sure you have followed the instructions above to the letter?

Hi

thank you   theSCIENTIST   and thank you borg

its working but it has many problems and I can`t use this simple form it show me many errors like this:

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

Cannot insert the value NULL into column 'PM_notify', table 'forum03.dbo.tblAuthor'; column does not allow nulls. INSERT fails.

/forum 7.7 SQL/forum Full/register.asp, line 974

its show me many errors like above error with different columns

is there any way

in fact I want hide unnecessary fields some users will not register when see the big form

is there any way to hide some sections

thanks

moti, I'm sorry for the post above, I should've researched the matter thoroughly, you are right, just passing FPN=1 along to register.asp won't do it, the reason is that the new registration page will not include all data, and some of this data is expected by SQL server which has fields of the NOT NULL type.

So I set on to providing this fields with some default values, the fields in question are all in tblAuthor, and I gave the values that suited my case, should be alright for you, and the user can change them later, but you are free to change them:

.Fields("Show_email") = 0 .Fields("Attach_signature") = 0 .Fields("Time_offset") = "+" .Fields("Time_offset_hours") = 0 .Fields("Date_format") = "dd/mm/yy" .Fields("Rich_editor") = 0 .Fields("Reply_notify") = 0 .Fields("PM_notify") = 0

The next challenge was to find the proper place in register.asp to pass these default values, and I found it, it must be a place where only runs when it's a new registration and nothing else, so, open your file, under the (Update datbase) section (yes its mispelled in your file also), slighly under that, look for these lines:

If strMode = "new" Then .Fields("Username") = strUsername If strMode = "new" Then .Fields("Group_ID") = intForumStartingGroup

Replace those lines with:

'Removed by tSC and replaced below 'If strMode = "new" Then .Fields("Username") = strUsername 'If strMode = "new" Then .Fields("Group_ID") = intForumStartingGroup If strMode = "new" Then   .Fields("Username") = strUsername   .Fields("Group_ID") = intForumStartingGroup   'Added by tSC to allow simple reg FPN=1 (intUpdatePartNumber=1) populate not null fields   If intUpdatePartNumber = 1 Then     .Fields("Show_email") = 0     .Fields("Attach_signature") = 0     .Fields("Time_offset") = "+"     .Fields("Time_offset_hours") = 0     .Fields("Date_format") = "dd/mm/yy"     .Fields("Rich_editor") = 0     .Fields("Reply_notify") = 0     .Fields("PM_notify") = 0   End If End If

Note: this is all under (With rsCommon) and before ('If part number = 0 (all) or part 1) note the (1) not (2).

I always add a ('Added by tSC...) comment, so I always know what I have changed, and I could search files for tSC and get my changes easily, you can change that if you want. Also note, I created a (If intUpdatePartNumber = 1) condition, so the code only runs if you want a simple reg form, when you change registration_rules back to its original state (not passing FPN=1) to get a full reg form, my code won't cause any problems what so ever.

It was all tested, in many different ways.

Hope this could be useful for you, or anyone else trying to implement a simple reg form.