Corporate Site | Register |

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.
 
Unanswered Active Topics Forums Search Members
Forums > Bi4ce.Modules.ListX > Blue Sky
Expose DB Metadata at runtime
Last Post 01 Jan 1900 05:00 AM by . 3 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
emaynardUser is Offline
Basic Member
Basic Member
Posts:182

--
11 Mar 2007 10:55 PM  
In addition to [Column.Name,System] and [Column.Index,System], can we also get access to more metadata information like the Column Data Type that is presented in Tables debug mode?

I know we have ISNUMERIC and ISDATE and perhaps there is a way to pull this from SQL, but I think more column metadata built into the engine would be a good thing for code generation capability.

thanks
-eric
emaynardUser is Offline
Basic Member
Basic Member
Posts:182

--
04 May 2007 10:15 PM  
Bump! Is this possible even?

I was thinking if one knew the DataType of a particular column, you could probably use a COLUMN template in combination with a few {IFFs} to generate a DatePicker control for Date/Time fields or CheckBox controls for Boolean fields.

Or is something like this planned for the QuickBuilder already?

-e
rgallaisUser is Offline
Basic Member
Basic Member
Posts:146

--
07 May 2007 02:53 PM  
Hi Eric,

This feature was introduced in listX version 1.9.7.1 with this following syntax:

<tr> {COLUMNS, "<th>[COLUMN.TYPE,SYSTEM]</th>", "", False} </tr>


Regards.
Romain Gallais<br>Business Intelligence Force, Inc. (bi4ce)
emaynardUser is Offline
Basic Member
Basic Member
Posts:182

--
08 May 2007 01:07 AM  
Awesome! I'll check it out soon.

Thanks,
-eric
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > Blue Sky
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
© 2010 R2integrated. All Rights Reserved.