R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
I need help!!!!
Last Post 01 Jan 1900 05:00 AM by . 1 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
pauldesUser is Offline
Veteran Member
Veteran Member
Posts:1392

--
23 Oct 2005 08:12 PM  

I've tried and tried and can't get a listX going and I'm getting frustrated.. I'm pretty sure I have a basic understanding of everything but List Format. I have no clue what to put in the List Item Detail or any new List Group. I've tried the examples, they won't load, the XML I paste in just disappears after I press LOAD. This is just a simple query of a first and last name field from and employee name table. The only error in my debug mode is:

sortActionList4111Error

My returned sql is displayed in one continuous text string for as much as will fit on the page so i'm sure I'm pretty close. I'm not sure if non-developers where considered in your documentation and module development, but that's what I am. Maybe I'm in over my head but I can not do this with the documentation provided. I believe it assumes that I know more than I do. I won't even go into ToolbarX at this point but anyway.....

Here is my ListX XML:


http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  10
  true
  true
  true
  false
  false
  false
  false
 
   
      0
      First Name
      First_Name
   

   
      1
      Last Name
      Last_Name
   

 

 
 
  Select productioned.dbo.employee.first_name, productioned.dbo.employee.last_name
from productioned.dbo.employee where productioned.dbo.employee.active = 1

 
  [First_Name][Last_Name]
 

ListX....makes you look brilliant, even though you're not.
kevinmschreinerUser is Offline
Advanced Member
Advanced Member
Posts:729

--
24 Oct 2005 02:40 PM  

The error you are recieving in debug mode is actually not a runtime error, but a limitation in the workings of the debugger. The current version of listx will display only information that is stored as an integer or string representation. The sortAction is actually stored as a physical object which cannot be converted to one of those types. What is important is that you are getting the data back, but it appears your data would be coming out as something like:

firstlastfirstlastfirstlastfirstlastfirstlastfirstlast...

This is occuring because ListX is not a grid or preformatted component. It was not given any instructions as to how to format the actual data. Meaning, it replaces the column values into the declarations within your item which is formatted precisely like you identified.

So - all you need to do is add a little formatting. Add a Group formatter, and set the Header and Footer as follows:

Header -

<table><tr><td>First Name< /td><td>Last Name< /td>tr>


Footer -
< /table>

Then, instead of your existing item format, use this:
<tr><td>[First_Name]< /td><td>[Last_Name]< /td>< /tr>

What this will do it write the header as the beginning of a table structure, column headings included. Then each item will be generated as a seperator row in your table. And the footer will append the table footer.

Or, for that matter, lets say you wanted this to be generated as a Bullet item list - you could do virtually the same thing, only change the formatting a little:

Header -
<OL>
Footer -
< /OL>
Item -
<LI>[First_Name] [Last_Name]< /LI>

As you can see, this is a fairly simplistic ListX requirement, and just the barest example of what you could do easily with a ListX control.

Let me know if that helps out, and feel free to post more questions -
Happy Nuking!

You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share