Register  Login  
  February 6, 2012  
Search_Blog Minimize
Print  

Blog_Archive Minimize
Print  

Blog    
View_Blog Minimize
Jul 6

Written by: host
Monday, July 06, 2009 3:34 PM 

I really got it wrong with "Display on All Pages" as noted by the Edit to my previous blog.  But isn't that part of the point in bloging what you found ... warts and all ...

Anyway, I have revised the select presented in the previous blog to restrict the modules listed to those who have the AllTabs bit set.

select 
    T.ModuleID, 
    Left(M.ModuleTitle, 30) as ModuleTitle,
    Count(T.TabID) as OnPages
from 
   
TabModules T
    join Modules M on M.ModuleID = T.ModuleID
where 
    M.AllTabs = 1

group by
    T.ModuleID,
    Left(M.ModuleTitle, 30)
having
    Count(T.TabID) > 1
order by
    OnPages desc

Here is the revised results

 

 

 

The orginal select is still valid, but will discover other modules spread over several pages.  More on that later.

Paul.

 

ModuleID    ModuleTitle                    OnPages
----------- ------------------------------ -----------
445         Google Add Panel               65
489         Google Add Panel               27

Tags:

1 comment(s) so far...

Re: Chinese Footware - and the removal of...

GameCoach Factory Outlet Onlineare usuallyCoach Factoryin By Coach Outlet Online on   Thursday, February 02, 2012 1:20 AM


Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment   Cancel 

Blog_List Maximize
Print  

  Home | Blog | Forum | Subscriptions | Free Modules | Videos   Page generated in 0.2034578 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement