You need to Register for free and Login to post a message in the forum.

Forum

Subject: Places to go for help/Questions
Prev Next
You are not authorized to post a reply.

Author Messages
quatrian
Nuke Newbie
Nuke Newbie
Posts:1

03 Sep 2007 4:32 PM  
Hi everyone.   I'm just starting out in the DNN world and was wondering if there were any good places to find quick answers to questions.

Is there an IRC chat channel that is sometimes populated? 

Is there a list of DNN tokens available anywhere?  I can't a help manual and google doesn't turn up anything.




One of my actual DNN questiosn is:
When I'm doing SQL statements in DNN, how do I make it so I can call SQL functions?  For me, this works:

INSERT INTO DateIndoo (date)
VALUES ('5/2/3402 13:00:00')

where

INSERT INTO DateIndoo (date)
VALUES (CURDATE())

does not.  However I found the CURDATE() statement listed here: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html


Any thoughts?



jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318


03 Sep 2007 8:09 PM  
For DotNetNuke, here are my favorites:

  • Here:  DNNCreative.com
  • DotNetNuke.com
  • Snapsis.com
  • MitchelSellers.com
For DotNetNuke skin tokens, I can't think of a better place to look than DotNetNuke Skinning
Reference Book
.

To answer your question about doing SQL in DotNetNuke, I would suggest that you take a look at Michael Washington's blog at the DotNetNuke site.  I'm not sure that I can answer your question about CURDATE() in MSSQL.  Try this:

Declare @today datetime
set @today = curdate()

Insert Into DateIndoo(date) Values( @today )





Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > Users Lounge > Everything Else > Places to go for help/Questions



ActiveForums 3.7

Latest Forum Posts

RE: EasyCGI help? by leesykes
You may want to ask them to reset the correct permissions on your DotNetNuke installation files, som...
RE: quick question by leesykes
Hello,It will be possible to a degree, but it depends on how both of the skins have been built. You ...
RE: EasyCGI help? by Dr Joe
I'll let you know how it works out. I think I opened up about 6 tickets with them so far. ...
RE: EasyCGI help? by derpir
Hi Joe amazing to say the least! I will change host to PowerDNN as soon as possible, seems to me t...
RE: EasyCGI help? by Dr Joe
Amazing - I'm going through this exact same thing with EasyCGI! I managed to successfully instal...
Running the local host installation after building the application by saintX
My localhost installation of DNN was running blameless. After I oppened the application with VWD it ...
RE: quick question by derpir
Hello Is it possible to buy two skins and combine them? for example put one skins visual attributes...
RE: Environment Variables by leesykes
Thanks for the info,
RE: How can i edit any module from front end by sanju_k1421
ok if i added an text html . now i want to fill into that have to log in ,but i want that an...
Module not working when logged off. by t.ramya85
Hi friends,I have created two modules which interact with each other and i have kept one module to b...
RE: Environment Variables by fandnet
There are many ways to use variables like what I was trying to use...But here is how I did it.DotNet...
RE: OpenForce '08 by mgordon
It was truly a great time.  I really feel this year was much better than last year.  I hope to ge th...
Environment Variables by fandnet
I am creating a simple module that registered users can use to send an email invitation to people wh...
RE: How can i edit any module from front end by leesykes
I'm not sure that I follow, could you provide an example?
RE: Development of modules by leesykes
Hello,Glad you find them useful, at the moment there are not any plans to go into Module Development...
RE: SQL Server 2008 Documents Module DotNetNuke by leesykes
Hello,Thanks for the tip. Yes both connection strings are in correctly and the user has full permiss...
RE: Now, portal creation problem by jncraig
Since you have other issues with installing modules, etc. I believe that you are correct that it's a...
RE: How do I display the current time by jncraig
The [CURRENTDATE] skin object has a DateFormat attribute. The examples give MMMM dd, yyyy as a typi...
RE: Now, portal creation problem by SupaHoopsa
Posted By jncraig on 18 Nov 2008 8:54 AMIf there are other errors related to the database, I would s...
RE: SQL Server 2008 Documents Module DotNetNuke by MobileNow
Make sure that both of the connection strings are the same in the web.config file. Also make sure t...
DotNetNuke Modules
RSS Feeds