Add any comments or questions regarding the Personalization, Text Editor, Logging and Reporting in Open Web Studio - Part 4 of 6 tutorial from issue 46

Hello Lee,

Can you show me what is the configuration look like for the following query to receive parameter from the url?

http://www.mysite.com/OWS.aspx?frmsearch=1

SELECT *
FROM products
WHERE ProdID=@frmsearch

Thank you,
Dat

Here is a link to an example configuration you can import. Open an OWS administration window, click IMPORT, then copy, paste and save the contents of the txt file in the attached zip file link.

http://dnncreative.advologix.com/qu...search.zip

Running DNN 05.04.01, the default text editor is Telerik in place of FckEditor. When I try to implement the OWS TEXTEDITOR (as shown in the tutorial) in this DNN release, I see the tag painted on the page as I’ve created it such as {TEXTEDITOR,frmText,Description,,100%,200} rather than rendering an actual editor. When I try this in my earlier releases of DNN leveraging the FckEditor, the editor renders as expected.

Has this TEXTEDITOR OWS call been adapted to work with Telerik and if so what changes do I need to make to have it function as expected?

The complex union query to get the categories and checkbox value could probably be simplified with a left join, something like:

SELECT c.Category,
CASE WHEN tc.category IS NULL THEN 0 ELSE 1 END AS checkbox
FROM KBCategory c
LEFT JOIN KBArticleCategory tc ON tc.category = c.category
WHERE tc.KBArticleId = [KBArticleId]
ORDER BY 1

Or a scalar subquery, e.g.

select c.Category,
(select count(*) from KBArticleCategory tc
where tc.category = c.category and tc.KBArticleId = [KBArticleId]) as checkbox
from category c
order by 1

Warning: not tested...

I know this is an old topic but I am having the same problem with the {TEXTEDITOR...} Tag and would like to know what the solutions was as it is not posted here.

Interestingly even though I posted the question 2 years ago, this issue just came up for me again so its been on my mind...great timing. I haven't tried it yet but will be in the next week or two. My plan is to try to use TinyMCE as the editor for rich text fields in OWS. I implemented it in minutes in a test environment and it was really easy to use/configure...jquery based so you don't have to fiddle with installing a new DNN editor...I just haven't tried to implement within OWS yet but no reason it wouldn't work.(?) If you have a chance to try it out before I do, please post the result.

http://www.tinymce.com/download/download.php

Jeff, thanks for the reply. I also made an inquery at OWS and got a reply, http://openwebstudio.com/Community/...ault.aspx.

I guess if it's just jQuery I may make a stabe at it and one way or another I will also pass it back to you. Thanks again.