Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityCommunity Membe...Community Membe...New Module tkSqlViewerNew Module tkSqlViewer
Previous
 
Next
New Post
5/23/2006 12:15 PM
 

Create your query and template and show the result as you wish

What's new in SqlViewer 1.2.0
-----------------------------

Added Search

  You can select one or more field in witch you want to search.
  Search in a range date
  Search each word with OR or AND method
  

i.e.

<Search Type="Combo|Check" CheckListColumns="2" cssClass="" AllText="Tutti" TextSize="" WordCheck="AND|OR|NONE" IfSearchTextEmpty="Normal|All|None">
   <Fields>
      <Field>
      <Name></Name>
      <Title></Title>
      <Operator>IsInText|TextStartWith|TextEndWith|EQ|NE|LT|LTEQ|GT|GTEQ|DATERANGE</Operator>
      <LogicOperator>AND|OR|AND NOT|OR NOT</LogicOperator>
      <Type>Date|Numeric|Text</Type>
      <DateFormat>ddMMyyyy</DateFormat>
      <Forced>True</Forced>
   </Field>
</Fields>
<Submit Type="Normal|Button|Link|Image|OnReturn" cssClass="" Title="" >
<SearchAll Type="Normal|Button|Link|Image" cssClass="" Title="" >
</Search>

         
Added security check over sql

What's new in SqlViewer 1.1.0
-----------------------------

Added FriendlyUrl Support
Added new functions for pager:
 - CSSClass - Specify a set of css class name.
  i.e.
  
  <Pager cssclass="sqlv" />
  
  .sqlv_border   /* External pager table css*/
  {
   background: #bbbbbb;
   color: #000000;
   border: 1px solid #336699;
  }
  .sqlv_ns   /* not selected cell css*/
  {
   background: #cccccc;
      font: 11px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; COLOR: #336699; TEXT-DECORATION: none;
  }
   A.sqlv_ns:link, visited {COLOR: #336699; TEXT-DECORATION: none};
   A.sqlv_ns:hover  {COLOR: #6699CC; TEXT-DECORATION: none};
  .sqlv  /* other cells css*/
  {
   background: #336699;
   font: 11px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; COLOR: #FFFFFF; TEXT-DECORATION: none;
  }
   A.sqlv:link, visited {COLOR: #336699; TEXT-DECORATION: none};
   A.sqlv:hover  {COLOR: #6699CC; TEXT-DECORATION: none};
  .sqlv_s  /* selected cell css*/
  {
   background: #cccccc;
      font: 11px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; COLOR: #336699; TEXT-DECORATION: none;
  }
   A.sqlv_s:link, visited {COLOR: #336699; TEXT-DECORATION: none};
   A.sqlv_s:hover  {COLOR: #6699CC; TEXT-DECORATION: none};
  
  


        - NoPageOf - disable the "Page n of m" display when is true
        - PrevPageImage - image url of the previous page link
        - NextPageImage - image url of the next page link
        - PrevPageSetImage - image url of the previous page set link
        - NextPageSetImage - image url of the next page set link
       
        Syntax: <Pager nopageof="true"
         prevpageimage="http://dotnetnuke/Portals/0/pp.gif"
         nextpageimage="http://dotnetnuke/Portals/0/np.gif"
         prevpagesetimage="http://dotnetnuke/Portals/0/pps.gif"
         nextpagesetimage="http://dotnetnuke/Portals/0/nps.gif"
         cssClass="sqlv"
         MaxPagDisplay="1" />

 

Features:
Display records in a table structure

User and Portal Macro support
Functions support to format a value or thumbnail an image
Conditional condition to display records
URL Parameters support
Display records in Random mode
Date, time and week functions

Installation
The installation zip file is configured as a DotNetNuke Private Assembly. To install SqlViewer to your DNN portal, log in as the DNN host user "host" and use the DNN Module Definitions page to upload the module.

Compatibility
This module works with DNN version 3.2.x, 4.0.x or higher.


 
New Post
5/23/2006 2:30 PM
 
Where and how people can get it will be useful.

Do you know the truth when you hear it?
Néstor Sánchez
The Dúnadan Raptor -->Follow Me on Twitter Now!
 
New Post
5/24/2006 5:29 AM
 

You can view it on dnn.talkho.it . Here there is also an help on how to use it.To buy you can find it on www.snowcovered.com !

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityCommunity Membe...Community Membe...New Module tkSqlViewerNew Module tkSqlViewer


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out