Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-21 : 08:10:30
|
| TechApprentice writes "I need to learn how to let people update their original guest book entries without adding new ones. The database involved goes something likeDatabaseName: Guestbook, TableName: CommentsID Username Password Email Website Favorite Color Comments1 Rose r4fu7lk3kd rose@email.com http://www.rose.com/ Red This is great!2 Joe 4af8ridlk33 joe@email.com http://www.joe.com/ White Can I update this later?Everything is fine as far as reading the database values in the .asp page for my guest book, but I want those who sign it to be able to come back later and update their original entries without adding new entries.Tricks I've tried so far that failed:1. Send them to the original guest book form and have them type in their username and password, while the database ID was set to be "text" and was named "Username."Problem: It just added a new row to the database and didn't edit the row that I wanted it to.2. After resetting "ID" to "Autonumber", create an .asp page that shows the database results as textfields, then insert the whole thing into a form that is set to send the data to the original database.Problem: Again, it just added a new row to the database and didn't edit the row that I wanted it to.3. Do nothing and hope no one cares about updating their original guest book entry.Problem: Chances are, some weirdo out there does care! I know there have been times I've wanted to update my entry in someone else's guest book, but couldn't, because, well, it was just a guest book. My guest book is different though, since it is run by a true database, and it doesn't just send data to the end of a plain old text file or slightly formatted HTML page. Also, I enjoy programming, even though I'm really just a novice who merely customizes codes from JavaScripts.com type places! I'm really curious to know how to solve this problem, but after TONS of web research I have failed to come across just the right tutorial to help me learn how to solve this.Please help me figure this thing out. Thanks." |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-01-21 : 08:18:58
|
| I suggest that you leave the Internet and read a book first. There are lots of books out there on ASP programming. Take your time, don't waste it on discovering what is allready discovered. |
 |
|
|
|
|
|
|
|
ASP/Database Question