If one creates a table including PortalID, ModuleID and UserID, and for some records, they are 'global', like 'all portals', 'all modules', or 'all users'...

Is there standard in DNN for a default number?  I know that UserID
of -1 is nono, because this means (I think) Host user, correct? 
And PortalID of 0 is default portal.  What is safe default number
to use in those records?  I searched through source code for DNN,
all are hardcoded numbers, no 'DEFAULT_ALLPORTALS As Integer = x' or
like that.  Does anyone have suggestion on what I use?  Is
only alternative for NULL (which make query more difficult)?  I
purchased the? book on DotNetNuke, and hope that some of these infos I
would find, but it is mild treatment of DotNetNuke.  Lots of 'you
should investigate this more'.  Meant more for users than
programmers which ok.  Hey, it's great there is documentations
over the issued, and payment is worth for to support the product!

But it is necessary I find a correct answer for this.  Any help I owe you for!  Perhaps point an example to I do not find?

8/5/2005 7:49:52 AM
asp.net.dotnetnuke 25171 articles. 0 followers. Follow

5 Replies

Similar Articles

[PageSpeed] 20

This is second time I ask question, yet never hear a response.  Do
I ask wrong?  I apologize for my English.  I will be
better!  Is there standard for this?
8/5/2005 3:08:12 PM
I think one thing you could do is make a flag that says they are global or you can create stored procs that ignore moduleid portalid etc etc - that seems easier
Dylan Barber
read my stupid blog http://codemypantsoff.com
Pants Optional!
8/5/2005 9:36:08 PM
Thank you CodeGalaxy.  I think this is my problem.  I think
there is hard-coded standard for ignore moduleid but it is not written
anywhere.  Core team not make seperat tables for table for one
module or all modules right?  It is one table.  I very much
appreciate you offer help though!
8/6/2005 6:27:36 AM
Well, this forum is mostly like crazy person talking to oneself. 
I find the solution my self.  I offer it to Codegalaxy, since he
is only one in 3 weeks to offer a solution, to what any member or
person that is programmer knows.  there is a /common/nulls.vb file
which contains all this this info.  So hard for people on this
board to actually help someone.  And search is for dogs.
8/20/2005 1:03:41 AM
The people on these forums are generally helpful. I just don't think there is an answer to your problems at this time. You will have to come up with a solution that fits your needs. I like the idea that -1,0, and 1 could have a consistent meaning throughout and normal portals, users, modules start numbering at 2. but this would require lots of changes.

-1 could be reserved (like the host account)
0 could mean all
1 could mean default or current

All day dreaming aside, generally I see some posts not get answered and its usually because of a few small reasons:
The topic is not within or too complex for the scope of this forum.
The question is not asked clearly.
So many new posts have been made, the topic falls to page 2 too quickly.


Free DotNetNuke News, Tips, Strategies and more.
8/20/2005 4:36:35 AM

Similar Artilces:

Name: haznen Email: haznenatyahoodotcom Product: Gran Paradiso Alpha 8 Summary: '''''''''''''''''''' Comments: '''''''''''''''''''''''''''''''''''' Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061204 UGES/ GranParadiso/3.0a1 From URL: http://www.mozilla.org/projects/granparadiso/ Note to readers: Hendrix gives...

Name: mario Email: ramar17atfastwebnetdotit Product: Gran Paradiso Alpha 2 Summary: ''''' Comments: K: Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2) Gecko/20070206 GranParadiso/3.0a2 ...

'do' won't 'do' if '/'
Greetings to All from Au, Have a NetWare Perl 5.8.4 and wanted to tweak File\Spec\NW.pm to try and standardise on '/' separators. If I run a test script (t/uni/lower.t) with an unmodified NW.pm, it calls t/uni/case.pl, that, in case.pl, (when the path separators are '\'), the $file is '..\lib\unicore\To\Lower.pl' and the following code portion works, with $simple getting a returned table: sub casetest { my ($base, $spec, $func) = @_; my $file = File::Spec->catfile(File::Spec->catdir(File::Spec->updir, "lib", &qu...

Name: L Lachowsky Email: e2brutus_10atyahoodotcom Product: Firefox Summary: ''' Comments: why duddn this surprise me... I change default server from IE to Mozilla, and then i get error messages. well, shud I decide to not get on my computer with Mozilla..or shud I risk security breeches with IE....hmmm at least i can get on the internet with IE Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv: Gecko/2008120122 Firefox/3.0.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this fee...

Cast from type ''''DBNull'''' to type ''''String'''' is not valid.
How do I avoid getting this error: Cast from type ''''DBNull'''' to type ''''String'''' is not valid. I am trying to get values from the database into a form for updating using a Datareader, SQL is set to allow nulls for certain fields as they are not required but the only way I can get the form to display is by adding a space in SQL. Is there another way around this? Check if it is equal to DBNull.Value first and if it is, don't do the cast.Stanley Tan theSpoke Blog Where in the code does it need to go? I am using the following and it's the profile that isn't always requi...

'or' or 'union'
Hello I was just wondering, in general what is better to use, an 'or' clause in a select or a 'union' to join two selects together. Do both statements create work tables? Many thanks Alex I think OR will be better than union. because suppose u have 3 tables and using OR u can join table a and table b and table c so each table will have only one read. but using union you will join table a and table b and in another query of union u will use table (a or b) and table c so ur one read is more in union . Ramdas Alex Cheung wrote: > Hello > >...

'IN' Clause or 'OR'
Hello, [1]: select * from TABLEA where COL1 IN('value1','value2''valu3'....) [2]:select * from TABLEA where COL1 = 'value1' OR COL1= 'value2' OR COL1='valu3'. TABLEA is a huge table and it has non-clustered index on COL1. Among the above 2 queries, which query will give me the better performance or fast response and WHY? What is the difference between 'IN' and 'OR' clauses as for as Sybase Optimization is concerned. Which is the better one to be used on huge tables. Thanks. Mac An IN list is treated ...

Hello. I'm using defferent 5.6.0's for Win32. I wonder wheter following behaviour is intentional or not: d:\>perl -e "print 'b'..'c'" bc d:\>perl -e "print 'b'..'a'" bcdefghijklmnopqrstuvwxyz I expected empty list in latter case, like in perl -e "print 'bb'..'a'" <!ENTITY Vadim REALLIFE "Vadim V.Konovalov, St.Petersburg, Russia"> &Vadim; On Wed, Sep 20, 2000 at 03:14:41PM +0400, Konovalov, Vadim wrote: > Hello. > > I'm using defferent 5.6.0'...

'To', 'CC', & 'BCC'
Name: Dick Tracy Email: philipdottracyatoptusnetdotcomdotau Product: Thunderbird Summary: 'To', 'CC', & 'BCC' Comments: I have just started using Thunderbird and while I find it quite excellent- I suggest having a button to add addressees to 'BCC' as well. Currently each 'BCC' addressee has to be selected manually. I send e-mail to quite a number of people at a time and I do not wish to readily spread others addresses easily. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/20070725 Firefox/2.0....

EXEC sp_msforeachtable 'sp_spaceused ''?'''
What does the following SQL code mean?  EXEC sp_msforeachtable 'sp_spaceused ''?'''Johan TheunissenMCPD, MCSE, MCTS BizTalk 2006==============================Please mark the most helpful reply/replies as "Answer". JohanNL:sp_msforeachtable This is the name of the SP that resides in the master database.  This SP executes one or more commands for a table. JohanNL:sp_spaceused This is the command that you want to run for each of the tables residing in your current database.  As you might have understood so far, that this is again a...

'Value' should be between 'minimum' and 'maximum'.
I'm attempting to invoke with parameters:  Dim thing2 As New mydelsubPBStep(AddressOf pbStep) Me.Invoke(thing2, "setMax", dt.Rows.Count)      <---- this is where the error occurs   the delegate looks like this: Private Delegate Sub mydelsubPBStep(ByVal mode As String, ByVal value As Integer)   the function it's calling looks like this:Private Sub pbStep(ByVal mode As String, ByVal value As Integer) Select Case mode.ToLower Case "clear" ProgressBar1.Value = 0 Case "step" ProgressBar1.PerformStep() L...

[PATCH] 'all ::' for one and one for 'all ::'
This patch causes core extensions to build explicitly the C<all> target on VMS. Otherwise sneaky extensions that insert dependencies before the C<top_targets> section get those dependencies built but nothing else when using the native make utilities MMS and MMK. --- vms/descrip_mms.template;-0 Mon Mar 4 19:10:42 2002 +++ vms/descrip_mms.template Wed Mar 13 00:36:56 2002 @@ -488,7 +488,7 @@ @ Rename/Log xsloader.pm [.ext.dynaloader] dynext : $(LIBPREREQ) $(DBG)perlshr$(E) preplibrary - @make_ext "$(MINIPERL_EXE)" "$(MMS)" + ...

Dynamic 'Includes' (which themselves have 'Includes')
Dynamic Header/Footer 'Includes' Hi Everybody. I have an old generic email script written in ColdFusion that sites with many designs use for their formmail. There are hidden form variables that allow the designer (not me) to pass which files should be used as the header/footer wrapper for the "Thanks for Sending Email" results page. Cleverly, the designer also uses includes within the files that are included as the header/footer files. Because ColdFusion reads and executes the file 'top to bottom', he can do that. I'm now trying to convert the script to ASP.NET. I i...

Parameterprefix ('@', ':', '?') with MySQL (lite) over odbc
Hi! I cant get my gridview to work with a deletecommand with a parameterprefix. I use a mysql lite installation. If a change my deletecommand to a specific id that exists in the DB everything works properly but not with @original_id (or @id). Been stuck on this for ages so I really apprechiate help. Code: asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="5" DataSourceID="SqlDataSource1" EmptyDataText="Det finns för närvarande inga kurser att boka." ForeColor="#333333" GridLines="None" Font-Size="Small" Width="688px" Horizon...

Web resources about - If one creates a table including PortalID, ModuleID and UserID, and for some records, they are 'global', like 'all portals', 'all modules', or 'all users'... - asp.net.dotnetnuke

Resources last updated: 11/27/2015 9:18:16 AM