Tuesday, 31 March 2009

Create and make Register Page work

Firstly, I make a page called "register.asp" then create a form which is set up with action to "login.asp" and method to "post"

so the layout will be like:



secondly, I make a function which can help customer register an account in my website

To start with, of course, I have to create database path for the page by recordset in "Binding Panel", then switch to "Server Behaviour Panel". I drop down the server behaviour menu to choose " Insert Record"



After clicking, a box pop up with more details to fill in


"Connection" to coursework
"Insert to table" to customer
"After inserting, go to" to login.asp
"get values from" to myform

then I will get all form elements in text area of Dreamweaver automatically



Finally, I preview and test the function that I made

I fill all my information into the form then "submit"



I got a clear error message saying
"
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/vhp0003/coursework2/register.asp, line 27"



I switch back to Code View in Dreamweaver to the cause.



However, I could not pick up any cause relevant so I post my question on different
forum.

http://www.aspfree.com





A day later , there is a reply for my question.
The cause is a permission of server so to solve it out, I follow the given link



and this is a solution to setup my permission on local host to do INSERT query in my Register Page.



Besides aspfree.com forum, I also post my query on ecommerce forum



And this is a reply I have got so far for my query.



I test my register page function

I fill "hung" in "full name" textfield
"pvhung1885@yahoo.com" in Email textfield
and my password in password textfield



After clicking "submit" button, it drives me to login page. the error page does not appear so that means the problem is solved.



However,it seems the function is not working at all, I log in with email and password that I inputted in register page but it drives me back to the same page.

So I check the database, I assume the INSERT QUERY is working, my register information will be inserted to database but as picture shown.



No data is inputted, that means the INSERT QUERY has some thing wrong

No comments:

Post a Comment