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  |  

DotNetNuke Marketplace
  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Webhost4life, specialists in DNN hosting
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
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Max size for SQL statement?
Previous Previous
 
Next Next
New Post 3/4/2008 7:28 AM
User is offline jason
1 posts
10th Ranked


Re: Max size for SQL statement? 
No luck. I changed the length to nvarchar(4000) on the SettingValue column and it still cuts my query short. Help Please.
 
New Post 3/4/2008 1:44 PM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Max size for SQL statement? 

The next major version of the Reports Module will probably move away from the Module Settings table to add a few other enhancements (such as the ability to display multiple reports in one module) so hopefully this will be fixed. In the meantime, I may investigate stop-gap solutions (such as referring to a SQL script file on the server), or you can use a third-party module such as the one Paul suggested .

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
New Post 3/4/2008 2:02 PM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Max size for SQL statement? 

 jason wrote
No luck. I changed the length to nvarchar(4000) on the SettingValue column and it still cuts my query short. Help Please.

I must recommend AGAINST changing the structure of the DotNetNuke database as you run a VERY HIGH risk of losing data during upgrades (if, for example, a future upgrade increased the SettingValue column to an nvarchar(3000), all of your queries would be truncated to 3000 characters).

As long as you understand these risks and maintain frequent backups, changing the size of this column would also require updating the AddModuleSetting and UpdateModuleSetting stored procedures to accept this larger parameter.

If it satisfies your needs, I strongly recommend you use the SQLGridSelectedView module rather than attempt to "hack" this support into the Reports Module.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
New Post 3/4/2008 2:28 PM
User is offline ErikVB
3073 posts
www.apollo-software.nl
4th Ranked










Re: Max size for SQL statement? 

it seems an other obvious workaround would be to put the long SQL in a sproc, and call that sproc from report viewer....

Erik van Ballegoij,
a view from my attic, my personal blog

The personal blog of Erik van Ballegoij
 
 Page 2 of 2Previous12 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Max size for SQL statement?
 


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.
 


ZLDNN.COM
We provide commercial DotNetNuke modules.
www.zldnn.com 		DNNhost Scandinavia
SUPER fast QuadCore DELL servers, MSSQL servers, DotNetPanel, daily backup, Check out our customers websites
DNNhost.dk 		Personify Design, Inc.
Seattle-based Personify Design has developed customized DotNetNuke websites for a wide range of customers to meet many different types of needs, including distributed authorship across thousands of pages to integrated Verisign e-commerce capabilities.
www.personifydesign.com

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