Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Simple registration form
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Simple registration form
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
moti View Drop Down
Groupie
Groupie


Joined: 07 September 2004
Status: Offline
Points: 73 		Post Options Post Options   Thanks (0) Thanks(0)   Quote moti Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2004 at 6:17pm

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
Back to Top
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post Posted: 13 September 2004 at 4:23pm

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?
Back to Top
moti View Drop Down
Groupie
Groupie


Joined: 07 September 2004
Status: Offline
Points: 73 		Post Options Post Options   Thanks (0) Thanks(0)   Quote moti Quote  Post ReplyReply Direct Link To This Post Posted: 14 September 2004 at 5:39am

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

 
Back to Top
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440 		Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post Posted: 14 September 2004 at 11:15am

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.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.