macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

Re: INsert Into not working in query

Subject: Re: INsert Into not working in query
From: Azadi
Date: Wed, 23 Jan 2008 20:47:10 +0700
Newsgroups: macromedia.coldfusion.advanced_techniques


sorry, can't help you with that, really, as i have never used or even heard of the PDSeditor... i understand it is some sort of rich text/HTML/WYSIWYG editor replacement for textareas, but i have not used it. i prefer tinyMCE, and a long time ago i used to use SOeditor, and now will probably switch over to FCKeditor since CF8 has it built-in...

but... if your ADD PROJECT page (or other pages) works fine with this PDSeditor and saves the text you enter in the textarea into the db, then it should work on the edit project page, too...

the function you posted, though, seems to just return the text you type into this PDSeditor to the textarea... this js is called on form submit... there must be another js function (or maybe even a whole js library) that loads and initiates the PDSeditor instance(s) on the page... if you can't see anything like that in your edit page (either in-line js or included as external file) then maybe that is why it is not working... look in the source of a page where the PDSeditor does work to see how it is included/initialised and add same code to the edit page if it is missing there.

strange, though, that you only have NAME attribute and no ID attribute for the textarea - most js works with ID attribute to select an element in the DOM as it is a lot easier than using NAME attrib.... maybe you are missing a required ID attrib of the textarea and that's why the PDSeditor does not load as it does not see the element to take over?

as a last resort, i would try just removing that style='display:none' from your textarea to see if it matters at all or not...

on another issue, looking at the code for your SELECT form element (the CATEGORY drop-down select), it looks like on the EDIT PROJECT page it will display ONLY ONE category - the one that has been previously selected for the project. what if i want to change the project category? maybe you should populate the SELECT with all categories, but pre-select the one that is currently associated with the project.

also, in your projMan query you do not need the AND c.CategoryID = p.CategoryID in the WHERE clause - you already have that constraint in the INNER JOIN...

hth

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

<Prev in Thread] Current Thread [Next in Thread>