Hi, all

is there any way or mod to allow switch between simple and full registration form

Simple :  Username - Password - mail - Security Code

Full : Full form

thanks

Hi,

Thanks for you reply

but I tested it and it don`t work

and it tell me insufficient permission for this page

this work just when I am loged in

is there any way

thanks

hey borg where are you

please help me I need it

moti, yes it does work, maybe you have done something wrong, change it like this:

<form method="post" name="frmregister" action="register.asp?FPN=1&FID=<% = Server.HTMLEncode(intForumID) %>">

Note the FPN=1 and the (&) after it, that's all you have to insert, or just copy the whole line above and replace yours.

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

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

'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

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

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?

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

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.