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
NorthWind Sample
Questions and Answers about our "Soup to Nuts" NukeDK sample of the Northwind Database.
Forums > Bi4ce.Modules.ListX > NorthWind Sample
Subject: Totally lost

You are not authorized to post a reply.   
Author Messages
wcmason
Welterweight
Posts:32
08/01/2006 2:32 PM Alert 
I am really trying to work with the Northwind demo but I am feeling really stupid and I have been a full time programmer since 1984.

In another message, Kevin said:
<<It is calling a procedure which we created - you can download the entire set of procedures via the Northwind home page. See "Downloads" just below the login area.>>

I have been looking for an hour now and I cannot find any downloads for anything on your site.

Since I couldn't find the download, I figured I could do it piece by piece. I was trying to see how the product list example was constructed. I created a new toolbar and then brought up the Product list page on this site. I figured the first grey boxed area was a toolbar. I went all through the module and the documentation and I cannot find any areas called "Title" or "Filter" to import the XML into. These are the labels for the XML on the demo site but nowhere does it say where to import this code.

Thanks,
Bill Mason
kevinmschreiner
Please Wait...
Posts:749
08/01/2006 2:40 PM Alert 
Actually, that is some legacy information that is not utilized any more. Northwind originally called stored procedures for all the queries it contains, however, in the new version, everything is handled through queries within the ListX instances. Throughout the site, anywhere that the XML explicitly states "Toolbar" it is a Toolbar module. Any other configuration XML links are ListX configurations (it also states this whenever you click on the XML button). I am diligently trying to get the 5 demonstrations online that walk you through all aspects of ListX from Grids and details through forms, validations, file manipulation, image uploading, and csv import/export.

In any case, the XML configurations within Toolbar and ListX work primarily the same way. Clicking the XML link within Northwind will open a new window, which will allow you to copy the XML code from a provided text region. Then, you can open up a toolbar or ListX (View Options) on your local instance, and paste that XML in the XML text region provided within the administration. Once pasted, click the Load button to change your existing module to use the newly supplied configuration.
Kevin M Schreiner

Business Intelligence Force, Inc. (bi4ce)
wcmason
Welterweight
Posts:32
08/01/2006 3:02 PM Alert 
Kevin,

Thanks for the reply. I'm still not sure what you are telling me. You mean there is no download?

I was looking at the product list because I want to filter the records I am displaying in the listx module with several input boxes and several drop-down lists. I figured if I could look at how the product list page was done, I could go from there.

Thanks,
Bill
daflea
Middleweight
Posts:79
08/01/2006 3:41 PM Alert 
Bill,

What Kevin is saying is... The older release or ListX was using Stored Procedure to achive all of the Select statments that the Northwind site uses.

The way it is now with 1.7.6 release all of the Select Statments are now in the ListX module to achive all the query that are being used through out the examples. Just copy the XML and paste it into your site.

I assume this was done to help use the end users figure out how it all works togeather. Plus all of the message asking for the Stored Procedures.

Doug
wcmason
Welterweight
Posts:32
08/01/2006 3:53 PM Alert 
Doug,

Thanks for the reply. But I still do not know how or where to display my dropdown listboxes to gather information to be used in my query. I can see them in action on the product list page but the XML there is only for the Listx, not for the Toolbar.

Bill
daflea
Middleweight
Posts:79
08/01/2006 9:27 PM Alert 
Bill,

I am no where of being an expert in ListX and the toolbar but I do know enough that the toolbar has nothing to do with listboxes. I have used subquerys to populate my dropdowns or listboxes with the data I needed to access. This was preformed in the ListX area and not the toolbar tool.

For example:
Letting the user select a State I would use the DNN dbo.LIST Table in the database to filter just the states and not the countrys and other misc data that the dbo.LIST table contains then let the user selected the one they wanted in the input form.


This is the SubQuery located in the HTML I used. This calls up a Stored Procedure to populate the Combobox but can be easily adapted to use a view instead in SQL.

{SUBQUERY,Name="cboState",Query="Pine_State_LOOKUP",Format="<option value='[lu_EntryID]'>[lu_State]</option>",SelectedFormat="<option value='[lu_EntryID]' SELECTED>[lu_State]</option>",SelectedField="lu_EntryID",SelectedItems="[fld_State,Form],[State]"}


This is the Stored Procedure that filter out only the states in the dbo.LIST table in DNN


CREATE PROC Pine_State_LOOKUP
AS
SELECT -1 AS lu_EntryID, '' AS lu_State
UNION
SELECT [Lists].EntryID AS lu_EntryID, [Lists].Text AS lu_State
FROM PinelandDNN.dbo.Lists Lists
WHERE (ParentID = 221)
ORDER BY lu_State


GO

Think of the toolbar as a neat menu interface that allows you to pass information to other ListX modules on other pages in your DNN website.

I hope this puts some light on your topic and if Kevin has more to add please do.


Doug
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > NorthWind Sample > Totally lost


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