Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Friday, December 05, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
The ever-powerful ListX module forum. Post your questions, new configuration ideas and reviews.
Forums > Bi4ce.Modules.ListX > General
Subject: Query variable tokens not getting replaced

You are not authorized to post a reply.   
Author Messages
mc@meirz.com
Welterweight
Posts:34
07/12/2006 8:32 PM Alert 
Is there a way to replace the query variable target tokens as described in item #1 below. We believe it should work - maybe a bug?

We're using a code fragment repository to build single-module apps with listx - meaning not all the code is kept in the listx setting. Certain code parts, such as form html, are easily retrieved when needed and because they are separate from the setting do not affect the performance of listx until used. Hence the size of the setting is a fraction of what it would be if all the code were contained in its setting.

1.
The form html mentioned above, which is SELECTed in sql, (SELECT Content FROM Table1 WHERE ID = (some int)) has listx query variable target tokens throughout. We assumed these tokens would get replaced in the listx replacement recursion, but they don't - they happily come through to the screen.

2.
On the other hand, we applied this approach to the message actions and did achieve success. How we did it: An Execute Query produces a text result. A second Execute Query produces a text result, but with a reference to the prior query's result embedded. The composite result of the second query is assigned to a session for rendering.

Message Actions Example:
Execute Query [GetEmailBody]: Select Body From Table1 Where ID = (some int)

Execute Query[GetEmailForm]: Select Content From Table2 WHERE ID = (some int)

Assignment: Assign <Session> variable 'EmailForm' to '[Content,GetEmailForm]'.

The Execute Query[GetEmailForm] "Content" column data has this text
" ...<textarea name=txtEmailBody>[Body,GetEmailBody]</textarea>... "

It does replace the execute query reference, but we have to escape any listx brace with 5 backslashes to get it to get it to render properly through an sql SELECT.

Mike

You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > General > Query variable tokens not getting replaced


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation