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...