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  |  

The best choice for your web site host, email hosting, and domain registration.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

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.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  CreatedDate edited by module??
Previous Previous
 
Next Next
New Post 2/28/2008 8:39 AM
User is offline David Leininger
3 posts
www.SolutionAvenue.com
10th Ranked


CreatedDate edited by module?? 

The following query fails in 4.8

select
us.firstname as [First Name],
us.lastname as [Last Name],
us.email as [Email],
up.createddate as [Entry Date]
from users us
inner join userportals up on us.userid=up.userid
where up.portalid=16

The module replaces the letters create with a space, leaving ...up. ddate as [Entry Date]...

Why isn't this module read-only? What other SQL commands are being replaced?
 
New Post 3/2/2008 6:26 PM
User is offline Andrew Nurse
353 posts
8th Ranked






Re: CreatedDate edited by module?? 

Which version of the Reports module are you using? There was a security feature in the early versions of the module that removed CREATE, DROP, and certain other SQL commands from your query. However, this was removed a few versions ago.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  CreatedDate edited by module??
 


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.
 


DNNSpired.com
Inspired to extend DotNetNuke®, everyday.
www.DNNSpired.com 		TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com 		DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk

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