Print Page | Close Window

Add/Update Access Database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22862
Printed Date: 29 March 2026 at 12:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Add/Update Access Database
Posted By: mbd2
Subject: Add/Update Access Database
Date Posted: 09 March 2007 at 5:39pm
I've tried and fail several times using this template.  I tried to use it in wwf and I received the same results. 

http://www.webwiz.net/asp/tutorials/add_to_database_pt2.asp

I create a forum - db and fields.

http://www.mbd2.com/guestbook_form.htm

I enter the data and noting is added/updated to the database...

Any ideas why I can not get this to work?





-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video



Replies:
Posted By: Freon22
Date Posted: 09 March 2007 at 7:30pm
Seem to work for me.
 
Edit: I did noitce that the comment field is not being added to the database. So are you adding this T6 field to your database?

<td width="100%" height="43"><font face="Comic Sans MS">Comments<br>
            &nbsp;</font>
              <input type="text" name="T6"  style="background-color: #FFFFCC" size="88"></td>
        </tr>


Posted By: mbd2
Date Posted: 09 March 2007 at 8:32pm
Freon22

So when you put the data in you saw your post?




-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video


Posted By: Freon22
Date Posted: 09 March 2007 at 9:48pm
Yelp, I am in it three times. Like I said the comments are not being added. Also after you are redirected to the guest book page, the page is not order right. You should add a ORDER BY in your query so that the newest records are the first displayed. As it is now I think the oldest records are displayed first.
 
You may also want to setup an admin page so that you can delete those old records to clean up the database after you get your scripting down. 

Guest Name:  Freon22
Location:  USA, USA
Website:  www.
Visits:  First Time
Likes:  Sculptures
Comments:

 

Date:       Time:   

 
Guest Name:  Freon22
Location:  somewhere, USA
Website:  www.
Visits:  First Time
Likes:  Sculptures
Comments:

 

Date:       Time:   

 
 
Guest Name:  Freon22
Location:  USA, USA
Website:  www.
Visits:  First Time
Likes:  Sculptures
Comments:

 

Date:       Time:   

 
 
 
 
 
 
 
 
 


Posted By: mbd2
Date Posted: 09 March 2007 at 11:07pm
Thanks, Embarrassed I didn't see that. 

Dale


-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net