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

  New Posts New Posts RSS Feed - Add/Update Access Database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Add/Update Access Database
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Topic: Add/Update Access Database
    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! www.mbd2.com -- Trade Show Presenter - video
Back to Top
Freon22 View Drop Down
Groupie
Groupie


Joined: 04 December 2005
Status: Offline
Points: 42 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Freon22 Quote  Post ReplyReply Direct Link To This Post 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>


Edited by Freon22 - 09 March 2007 at 7:35pm
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post 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! www.mbd2.com -- Trade Show Presenter - video
Back to Top
Freon22 View Drop Down
Groupie
Groupie


Joined: 04 December 2005
Status: Offline
Points: 42 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Freon22 Quote  Post ReplyReply Direct Link To This Post 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:    


 


 


 
 
 
 
 
 
 


Edited by Freon22 - 09 March 2007 at 9:50pm
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Posted: 09 March 2007 at 11:07pm
Thanks, Embarrassed I didn't see that. 

Dale
Balloon Entertainment at it's best! www.mbd2.com -- Trade Show Presenter - video
Back to Top
 Post Reply Post Reply

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.