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
Blue Sky
Want something added to the ListX engine, or just can't wait to see what is in store for the future? Check out this forum and let us know what you think.
Forums > Bi4ce.Modules.ListX > Blue Sky
Subject: SubQuery Variable Names

You are not authorized to post a reply.   
Author Messages
schafer_brad
Featherweight
Posts:14
02/23/2006 11:45 PM Alert 
It would be great if we could isolate SubQuery Columns from other Columns, I find that as I use Stored Procs, the field names match the main query field name alot of the time. This gives the wrong info, and forces me to use 'fake column names' or not use sprocs.

Perhaps a format like: [ColumnName,SubQueryName]

Main query columns are just : [ColumnName]

For instance:
{SUBQUERY, Name="qryLinks",
Query="EXEC MyStoredProcedure [UserID]",
Format="<option value='[ID,qryLinks]'>[MainQueryColumn]-[Label,qryLinks]</option>",
SelectedFormat="<option value='[ID,qryLinks]' SELECTED>[MainQueryColumn]-[Label,qryLinks]</option>", SelectedField="ID",
SelectedItems="[ddID]"}

In this manor the values would be from the SubQuery, but the option text could include columns from the main query.
Brad Schafer




Brand Building , Lead Generation, Web Design
kevinmschreiner
Please Wait...
Posts:749
02/25/2006 9:47 PM Alert 
Thats odd, I will have to double check the Sub query, it was in the original specification to work exactly like you just posted. It is supposed to simply piggyback the logic provided within the Execute Action logic.
Kevin M Schreiner

Business Intelligence Force, Inc. (bi4ce)
zingernet
Welterweight
Posts:48
09/10/2006 7:43 PM Alert 
I have been having trouble using any resulting columns at all from a stored procedure when i use it in a subquery. If my subquery is as follows:

{SUBQUERY,Name="qryRating",Query="Exec ProductRating [ProductID]",Format="[ProductRating]"}

and the last statement from the Stored procedure is "select AVG(Rating) as ProductRating from Products where ProductID = @ProductID

Then why does the resulting output just have the literal text, [ProductRating] ? Maybe I'm just doing something wrong ... can someone please help.

Thanks
zingernet
Welterweight
Posts:48
09/10/2006 7:51 PM Alert 
Nevermind ... I had to clear the web cache. After I did that it worked.
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > Blue Sky > SubQuery Variable Names


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