Eric - the end result I'm looking for is just to display the page headlines of all pages this one page is linked from...is there an easier way?
Stefan - what do you mean by "within publishing mode" - I have the login/session key RQL code included already - how is it incorrect? Thanks everyone for your help!! On Aug 29, 12:10 am, Eric Koleda <[email protected]> wrote: > Hi Mike, > > In general it is bad practice to run RQL in templates. It can be a > solution to tricky problems, but there are often other solutions that > are more stable and less server intensive. What are you actually > trying to accomplish with your script? > > That said, I have spotted a typo in your code: > > <!IoRangePreExecute><=pagename><!/IoRangePreExecute> > > should be: > > <!IoRangePreExecute><%=pagename><!/IoRangePreExecute> > > Best, > - Eric > > On Aug 28, 3:59 pm, Mike Searles - AtlRugger <[email protected]> > wrote: > > > > > We are using Reddot CMS 7.5.1.103 and am having trouble using RQL > > within an XML template - specifically assigning a variable and > > referencing that variable (pagename) within XML tags. > > The code I’m using (logging into the system, session key, etc.) all > > works perfectly in the ASP version of the template - but was wondering > > what/if anything needs to be changed with using that code within XML. > > Here's a snippet of the code I think is causing the problem: (with a > > slight modification made within the XML tag below for research > > purposes) > > > <!--RDExecute=asp--> > > > <!IoRangePreExecute> > > > <% dim objData > > dim rqlRequest > > dim rqlResponse > > dim sErrors > > dim cms > > dim strLogin_Guid %> > > > <!-- Function to create connection to CMS database --> > > <% function sendXML (rqlRequest) > > set objData = server.CreateObject("RDCMSASP.RdPageData") > > objData.XmlServerClassName="RDCMSServer.XmlServer" > > sendXML = objData.ServerExecuteXml(rqlRequest, sErrors) > > if sErrors <> "" then > > response.write "Errors occured: " & sErrors & chr(13) > > end if > > 'objData = NULL > > end function %> > > > <!-- Pulls specific article information using the above page GUID to > > get appearance schedule information --> > > <% rqlRequest = "<IODATA > > loginguid=""D5B26D60EA1F45E4A593985C2418A4D3"" sessionkey=""< > > %nfoSessionKey%>""><PAGE guid=""<%nfoPageGUID%>""><LINKSFROM > > action=""load"" /></PAGE></IODATA>" > > rqlResponse = sendXML(rqlRequest) > > > <!-- Generate a DOM Object to parse the response RQL statements --> > > Set xmlDoc = server.CreateObject("Msxml2.DOMDocument.4.0") > > > <!-- Import content of response RQL to the DOM object --> > > xmlDoc.loadXML(rqlResponse) > > > <!-- Creates an array of all connections within this specific article > > --> > > Set subRDxmlNodeList = xmlDoc.getElementsByTagName("LINK") > > > <!-- Loop over list of all structural elements and retrieve the > > appropriate "articles list" GUID --> > > For i=0 To (subRDxmlNodeList.length - 1) > > connectedpage = > > subRDxmlNodeList.item(i).getAttribute("ismainlink") > > pagename = > > subRDxmlNodeList.item(i).getAttribute("pageheadline") > > <!/IoRangePreExecute> > > > <connectedto> > > <!IoRangePreExecute><=pagename><!/IoRangePreExecute> > > </connectedto> > > > <!IoRangePreExecute> > > Next > > > <!-- Remove DOM object from memory --> > > set xmlDoc = nothing %> > > > <!/IoRangePreExecute> > > > Let me know if there are other parts of the code you need to see or > > have questions about. > > Any and all help would be greatly appreciated!- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
