Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Maximum ASP
  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Big SQL Statements
Previous Previous
 
Next Next
New Post 7/10/2008 11:56 AM
User is offline cathal connolly
2756 posts
www.cathal.co.uk
5th Ranked










Re: Big SQL Statements 

 SadisticRabbit wrote

 cathal connolly wrote

 

you might be better off using the reports module (http://www.dotnetnuke.com/tabid/125/default.aspx) for this kind of thing - http://www.dotnetnuke.com/Community/Blogs/tabid/825/BlogID/196/Default.aspx has a bunch of blog entries that might help give you an idea of the capabilities.

Cathal

 


sorry confused.. I AM using the reports module.. this is the reports module forum!??! Or did you mean something else ?

sorry, sorry, I misread the original post and thought you had written a custom module and were looking to store content in in. I'd recommend that you try using stored procedures then instead of the sql directly

Cathal
 
New Post 7/10/2008 12:06 PM
User is offline Charles Nurse
2915 posts
5th Ranked










Re: Big SQL Statements 

What you are trying to do here is a "CrossTab" Query.

IMO - the best approach is to create a View (or temporary Table) that crosstabs the UserProfile/ProfileDefinition Table - then use this temporary table in a Join with the other table(s).

This is quite a complex problem to solve - but if you investigate (google) Crosstab or Pivots this should take you in the right direction.

Alternatively - create a user function that evaluates the Select Sub Query for you - and returns the value - this will avoid all the subqueries (eg GetProfileProperty(UserID, PropertyName) ).

Charles Nurse
DotNetNuke Trustee,
Senior Architect, DotNetNuke Coporation
 MVP (ASP.NET) and
ASPInsiders Member
View my profile on LinkedIn
See my Blog for Articles on .NET, DNN and Module Development

View my Blog
 
New Post 7/10/2008 1:25 PM
User is offline Paul Scarlett
188 posts
www.tressleworks.ca
9th Ranked






Re: Big SQL Statements 

You may wany to check out SQLGridSelectedView from www.tressleworks.ca   The free version of this modules will support over 8000 characters in the SQL statement ...  should be enough.  

Paul.
 
New Post 7/16/2008 9:13 AM
User is offline Robert Wiseman
8 posts
10th Ranked


Re: Big SQL Statements 

Couldn't you use a stored procedure?  Or select from a view?
 
New Post 7/26/2008 3:47 PM
User is offline Alan Gore
7 posts
10th Ranked


Re: Big SQL Statements 
 cathal connolly wrote

you might be better off using the reports module

Cathal

I'm assuming he DID use the Reports module. I had the same problem with large queries. Apparently there is a dinky query size limit. My workaround was to go to stored procedures. This allows queries of any size, and multiple statements, but makes editing one leval more difficult.
 
 Page 2 of 2Previous12 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Big SQL Statements
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


Need Help with your DotNetNuke website?
Jango Studios offers exclusive DotNetNuke Skin Design, Module Development, Web Marketing and Web Hosting.
www.jangostudios.net 		Where Every Home is an Investment
Where Every Home is an Investment
www.nestbrokers.com 		Faculty of Graduate and Postdoctoral Studies
At the graduate level, the University of Ottawa offers more than 180 graduate certificates, master's degrees and PhDs, as well as interdisciplinary programs such as Women's Studies and Canadian Studies. Many postdoctoral opportunities are available in both the sciences and the humanities. For further information, please consult the site of the Faculty of Graduate and Postdoctoral Studies.
www.grad.uottawa.ca

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP