Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - RTE -> Access Q’s
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedRTE -> Access Q’s

 Post Reply Post Reply
Author
lowgenius View Drop Down
Newbie
Newbie


Joined: 02 August 2004
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote lowgenius Quote  Post ReplyReply Direct Link To This Post Topic: RTE -> Access Q’s
    Posted: 21 November 2004 at 2:18am
Greetings all.  After using the WWForums for a while and being very happy with how easy they are to use, I decided to try and use the RTE for some interactive areas on another site I'm designing.

The problem I'm having is that I want to insert the content of the RTE into an Access (2003) database.

I'm sure this has been covered here, but I've been beating my head against this for hours and I didn't turn up what I needed by searching the forums.

I'm designing with Dreamweaver MX and using the canned 'insert record' routine.  In order to try to make my page work with RTE, I made sure the name of my existing textarea was 'message' before I deleted it and replaced it with the include file.

When I use the form and push the 'Submit' button (on MY form, not on the RTE - there are other fields in the form that need to be send to the database as well), it sends everything BUT the contents of the RTE.

I realize I'm probably suffering from acute cranio-rectal insertion disorder at this point from having stared at this thing for too long, but is there a good tutorial or something that I can peruse to try and overcome this?  If someone needs me to I can post the vb code that DW autogenerates to create the insert query and so forth...but basically what it comes down to is that I'm not finding a textarea called 'message' anywhere - just an iframe with the ID 'message' - and the MM code doesn't appear to like treating an iframe as a form field.

Using RTE 2 beta 1, DW MX 2004, and Access 2003.  Thanks.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 21 November 2004 at 6:03am
To start with DON'T use Drteamweaver to write code for you, it's awful and 9 out of 10 times unless you are doing something basic it won't work.

The iframe isn't seen as a form element. When the submit button in the RTE is clicked the contents of the iframe is placed into a hidden form element called 'message'

Place the following onto your forms submit button:-

OnClick="document.frmAddMessage.message.value = document.getElementById('message').contentWindow.document.bo dy.innerHTML;"

Now when the submit button is clicked the values of the iframe will be placed into the hidden field called 'message' and can be read in from the file you submit to like any other form element.
Back to Top
lowgenius View Drop Down
Newbie
Newbie


Joined: 02 August 2004
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote lowgenius Quote  Post ReplyReply Direct Link To This Post Posted: 21 November 2004 at 10:22am
Wonderful  Thanks for your help - and for such a great sutie of tools!
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.