Yes, one can get loginguid and session key from info placeholders.
And yes, running RQL via Ajax is preferred over preexecting RQL.
1. Preexecution adds additional complexity to the project and slows
page rendering and everything else down.
2. When preexecuting RQL WRITEs, CMS may run into a deadlock:
Preexecution is waiting for Pagebuilder to finish building page from
elements, Pagebuilder is waiting for element to finish updating caused
by Preexecution.
Best way to do RQL within CMS?
Any ASP invoked from within CMS (once the user is logged in), one can
get the loginguid and session key via session variables, IE:
session("loginguid")...
Then why not just construct the RQL using javascript and send it via
AJAX to an asp page that does nothing but execute RQL commands?
Best,
-Jian
On Jan 6, 3:47 pm, Luca Loguercio <[email protected]> wrote:
> not sure if it's changed in newer versions, but in 7.5 you can get
> both those as Info placeholders.
>
> a very crude example could be
>
> <!--RDExecute=ASP-->
> <%
> ' create RedDot and XML objects
> Set objIO = Server.CreateObject("RDCMSASP.RdPageData")
> objIO.XmlServerClassName = "RDCMSServer.XmlServer"
> Set objXMLDOM = Server.CreateObject("Microsoft.XMLDOM")
> objXMLDOM.async = False
> '********************************************************
> ' This part takes the value of subLevelHeadline
> ' and copies it into PageTitleMetaTag
> '********************************************************
>
> 'load elements belonging to current page
> strXML = "<IODATA loginguid=""<%LoginGUID%>""
> sessionkey=""<%SessionKey%>""><PAGE guid=""<%PageGUID%>""><ELEMENTS
> action=""load""/></PAGE></IODATA>"
> strXML = objIO.ServerExecuteXml(strXML, strError)
> ' load returned XML into object
> objXMLDOM.LoadXML(strXML)
> Set Elements = objXMLDOM.getElementsByTagName("ELEMENT")
> ' loop until we find 'PageTitleMetaTag'
> For Each Element In Elements
> If Element.getAttribute("name") = "stf_name" Then
> ' get its GUID
> stf_nameGUID = Element.getAttribute("guid")
> Exit For
> End if
> Next
> ' save the value of subLevelHeadline into the guid of PageTitleMetaTag
> strXML = "<IODATA loginguid=""<%LoginGUID%>""
> sessionkey=""<%SessionKey%>""><ELEMENTS action=""save""><ELT guid="""
> & stf_nameGUID & """
> value=""<%subLevelHeadline%>""></ELT></ELEMENTS></IODATA>"
> strXML = objIO.ServerExecuteXml(strXML, strError)
>
> %>
>
> On Thu, Jan 6, 2011 at 3:34 PM, Killingsworth, Chad A
>
> <[email protected]> wrote:
> > Pre-execution and RQL don't normally go together. During the pre-execution
> > phase, you don't have access to session key or login guid information.
> > You'll be required to log in a dummy account, make your change, and then
> > log them back out . It's not pretty.
>
> > Instead, you might consider running an ajax style call, set the value, then
> > reload the page if the value was changed. We've found this strategy to be
> > much more robust.
>
> > Chad Killingsworth
> > Assistant Director of Web & New Media
> > Missouri State University
>
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]] On Behalf Of Dave R
> > Sent: Thursday, January 06, 2011 11:24 AM
> > To: RedDot CMS Users
> > Subject: Using Asp/RQL to set content of a Standard Field
>
> > Hey,
> > I've got a standard field that I want to change the content of when a
> > pre-execute script runs. What is the easiest way to do that?
>
> > Example: Prior to the pre-exec script stf_name contains no content.
> > After the pre-exec, stf_name should contain "Set".
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "RedDot CMS Users" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group
> > athttp://groups.google.com/group/reddot-cms-users?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "RedDot CMS Users" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group
> > athttp://groups.google.com/group/reddot-cms-users?hl=en.
--
You received this message because you are subscribed to the Google Groups
"RedDot CMS Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/reddot-cms-users?hl=en.
