Simple SQL Usage - Simple SQL


Friday, November 21, 2008 Login \| Register

Please Read

FAQ

Forums

Licensing

Feature Requests

Are you listed in the DotNetNuke Directory?

To start or answer a thread you will need to login...

Forum Guidelines

Please ensure you follow the bug-raising guidelines (e.g. post the full error from your Event Viewer) if you are raising a support call. To request a feature in a module, please use Feature Requests (unless you want to discuss it here in more detail first). If you have an urgent feature that you would like to see in the product then you should consider a Sponsored Enhancement.

First Time User? Make sure you have read the Module Config Guide in the documents folder of each module. Also check out this handy Module Deployment Guide (written by a Smart-Thinker customer!)

Configuration issues and no time to read the Forums/Documentation? See our DotNetNuke Premium Support Service.

We need your opinion! Please read our proposed new CrowdSourcing development method and let us know if you would be interested and if it might work.

Forums DotNetNuke Simple SQL Simple SQL Usage

5/27/2005 3:16 AM

	Rodney Joyce
2904 posts
www.DNNDir.com

Simple SQL Usage (United Kingdom)

The aim of Simple SQL is to increase productivity and make the day-today use of DotNetNuke more effective by using Simple SQL.

A lot of people don't realise the power of SQL, and lot of people are not programmers or DBAs, which is why it is Simple SQL.

Please share the knowledge and copy and use the SQL freely - if you have any to share then please post it here for everyone's benefit.

Likewise, if you need a report on something and are battling with the SQL, let us know - we'll be glad to help!

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

Smart-Thinker DotNetNuke Development Blog

4/6/2006 10:14 AM

	rolando escobar
1 posts
www.interdata.cl

Re: Simple SQL Usage (Uruguay)

Good... Rodney .... look this sentence :

SELECT '<a HREF=/default.aspx?tabid=' + CAST(TP.TabID AS VARCHAR) + '>' + TP.TabName + '</a>' as Menu
FROM Tabs T inner join
Tabs TP on T.TabId = TP.ParentId inner Join
Portals P on T.PortalID = P.PortalID
where T.TabName = 'SQLDashboard' and T.PortalID = 0

a question : Don't work with friendly URL?

Thank Rolando

4/12/2006 2:03 AM

	Rodney Joyce
2904 posts
www.DNNDir.com

Re: Simple SQL Usage (United Kingdom)

Hi Rolando

I'm not an expert on friendlyURLs, but I was under the impression that it would (so that old links would be compatible).
Anyone else know more about FriendlyURL interpretation?

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

5/29/2006 12:52 PM

	Michael Gerholdt
16 posts

Re: Simple SQL Usage (United States)

Modified By Michael Gerholdt on 5/29/2006 1:58:28 PM)

Anyone have a script for re-indexing the DNN database from the host SQL box? Or is that not do-able / recommended? How do you folks re-index the database?

5/29/2006 2:53 PM

	Rodney Joyce
2904 posts
www.DNNDir.com

Re: Simple SQL Usage (N/A)

Hmmm - not sure to be honest, I've never tried it. Do you mean reindexing the physical files with the DNN Files table?

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

5/30/2006 1:36 PM

	Michael Gerholdt
16 posts

Re: Simple SQL Usage (United States)

any indexes on tables - which enable them to be accessed quickly but over time need to be re-calibrated so to speak as records are added and deleted - so the index is no longer compact, and performance suffers -

6/9/2006 1:27 AM

	Rodney Joyce
2904 posts
www.DNNDir.com

Re: Simple SQL Usage (N/A)

Oh I see, I thought you meant reindexing files and DB - no, I haven't had the need to do this yet - anyone else?

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

10/3/2008 1:55 PM

	Steve Day
6 posts

Re: Simple SQL Usage (N/A)

To be honest, I'm a bit new with DNN, but what module are we talking about here that allows you to enter SQL statements to hit the DB? And I assume it can only hit the dnn database and it will probably use the aspnet user right?

Thanks

-Steve

10/3/2008 7:48 PM

	Rodney Joyce
2904 posts
www.DNNDir.com

Re: Simple SQL Usage (N/A)

Hello Steve,

This is up to you - there are a couple of SQL modules out there to chose from - I personally use SQL View from DNNStuff (it's free and good). There is also a core one I think (Reporting module) but I have not used it.

Thanks
Rodney
See our modules in action on PokerDIY, a social network for home poker players

10/6/2008 9:04 AM

	Steve Day
6 posts

Re: Simple SQL Usage (N/A)

Thanks, I downloaded the one from DNNStuff, also bought their aggregator, good stuff.

-Steve

Page 1 of 1

Forums

DotNetNuke

Simple SQL

Simple SQL Usage

Top Threads

In the past 1 week, we have 29 new thread(s) and 70 new post(s)

The most popular thread has been Re: Multipaid Sponsored Enhancements

The most active thread has been Multipaid Sponsored Enhancements / Crowdsourcing to improve modules

Smart-Thinker is powered by DotNetNuke - please support us and DotNetNuke -