Asp Forum - michael kors factory outlet bcV - microsoft.public.inetserver.asp.db

Katadedajab

12/29/2013 12:35:00 AM

<a href=http://www.tlmmarin.org><b&... kors outlet</a>Now society, English become a good deal more and a good deal more an absolute must have But managing learn English if that is so a resource box is the fact have been at a loss people's problems. Listening, speaking, reading and writing,is the fact in lots of ways used. So going to be the language environment usually really an absolute must have.<a href=http://www.thomasbayhydro.com>&l... outlet store</a>This bag's design and style and going to be the color is this : really bright. Give a person shine at the afternoon I began for additional details on trying to find profession for instance designer, want for more information regarding know in that case it will be the developed.<a href=http://www.nysolidarity.org><... outlet</a>you do nothing more than shift your attention.going to be the question is not at all disapear.you get pleasure from the boy and going to be the lad get pleasure from all your family members but take heart your family worry about not at all stay allowing an individual each various last year an along the lines of my own personal colleague met going to be the same things slightly like all your family members after she coming back both to and from Xizang,yunnan,chongqing, she thought herself has forgotten going to be the ex-boyfriend.most of these months later,for those times when she wanted accepted another man's take into account.the ex-boyfriend called her and begged another chance. although a number of us always say need to hardly ever rent it out our lovers be the case hurted.significantly more in several ways than just do not we make all of our sweetlove shriek.for that reason there if you find that be a good amount of communication and forgiving between going to be the more than one hearts.on the basis of going to be the way going to be the girl can be bought back to understand more about her ex-boyfriend. and this weekend a number of us will have a multi function dinner together.<a href=http://www.nysolidarity.org><... for cheap</a>Now a lot more and significantly more it is certainly plausible in your discussion, ability or at least degree£¬what is because important £¿ I think,spend time researching history renewed commitment really can provide evidence that the person is the fact able. So, don't forget to understand more about enrich your one of a kind.<a href=http://www.tlmmarin.org><b&... kors outlet</a>Finish visit this terms,an all in one mountain and rivers have things you can do scene appeared on the front similar to me Like that feeling very much in the way hope to understand more about have the amount of time can go for more information regarding really do not think going to be the relaxing pleasure along the lines of body and mind.<a href=http://www.tlmmarin.org><b&... kors outlet store</a>

5 Answers

Cor Ligthert [MVP]

12/27/2007 5:42:00 PM

David,

Normally I and probably most of us would solve this by creating a table with
the users (companies), then the properties used and add those properties to
the tables to select the rows which are available for the users (companies).
Why is this approach not taken?

Cor

"David Thielen" <thielen@nospam.nospam> schreef in bericht
news:1CAD6992-DCB6-48EF-806A-B61D936C406F@microsoft.com...
> Hi;
>
> They are both the same thing. The problem is we will have multiple
> different
> Application User's with data in the DB.
>
> Let me ask a different question as I may be under a false assumption. Lets
> say we have 10,000 different Application Users. Can we then create 10,000
> databases on a single Sql Server system? Or will that kill it? I've been
> assuming that that would be bad (just like events are better than threads
> and
> threads are better than processes and 10,000 processes will kill Windows).
>
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardr...
>
> Cubicle Wars - http://www.windwardr.../film.htm
>
>
>
>
> "Cor Ligthert[MVP]" wrote:
>
>> David,
>>
>> Proabably don't I understand your question.
>>
>> What is in this case the difference between the Application User and a
>> Application User Company?
>>
>> Cor
>>

David Thielen

12/27/2007 5:51:00 PM

It's a much more complicated schema than that. We have about 20 tables. One
example is the invoice table - which does have a column for the user. But
there is a table of invoice items and it's only foreign key is the PK to the
row in the invoice table.

If we control all of the selects, no problem (assuming we don't make any
mistakes). But we want to let our users have the abaility to pull any of
their data out and so we want to give them the ability to make their own
selects, but then insure they get only their data.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm

"Cor Ligthert[MVP]" wrote:

> David,
>
> Normally I and probably most of us would solve this by creating a table with
> the users (companies), then the properties used and add those properties to
> the tables to select the rows which are available for the users (companies).
> Why is this approach not taken?
>
> Cor
>
> "David Thielen" <thielen@nospam.nospam> schreef in bericht
> news:1CAD6992-DCB6-48EF-806A-B61D936C406F@microsoft.com...
> > Hi;
> >
> > They are both the same thing. The problem is we will have multiple
> > different
> > Application User's with data in the DB.
> >
> > Let me ask a different question as I may be under a false assumption. Lets
> > say we have 10,000 different Application Users. Can we then create 10,000
> > databases on a single Sql Server system? Or will that kill it? I've been
> > assuming that that would be bad (just like events are better than threads
> > and
> > threads are better than processes and 10,000 processes will kill Windows).
> >
> > --
> > thanks - dave
> > david_at_windward_dot_net
> > http://www.windwardr...
> >
> > Cubicle Wars - http://www.windwardr.../film.htm
> >
> >
> >
> >
> > "Cor Ligthert[MVP]" wrote:
> >
> >> David,
> >>
> >> Proabably don't I understand your question.
> >>
> >> What is in this case the difference between the Application User and a
> >> Application User Company?
> >>
> >> Cor
> >>
>

Cor Ligthert [MVP]

12/27/2007 9:01:00 PM

David,

Then why no helper tables to add the information that is needed to the rows?

Cor

"David Thielen" <thielen@nospam.nospam> schreef in bericht
news:91764E3B-8C1A-4183-9B73-E90C82F3336F@microsoft.com...
> It's a much more complicated schema than that. We have about 20 tables.
> One
> example is the invoice table - which does have a column for the user. But
> there is a table of invoice items and it's only foreign key is the PK to
> the
> row in the invoice table.
>
> If we control all of the selects, no problem (assuming we don't make any
> mistakes). But we want to let our users have the abaility to pull any of
> their data out and so we want to give them the ability to make their own
> selects, but then insure they get only their data.
>
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardr...
>
> Cubicle Wars - http://www.windwardr.../film.htm
>
>
>
>
> "Cor Ligthert[MVP]" wrote:
>
>> David,
>>
>> Normally I and probably most of us would solve this by creating a table
>> with
>> the users (companies), then the properties used and add those properties
>> to
>> the tables to select the rows which are available for the users
>> (companies).
>> Why is this approach not taken?
>>
>> Cor
>>
>> "David Thielen" <thielen@nospam.nospam> schreef in bericht
>> news:1CAD6992-DCB6-48EF-806A-B61D936C406F@microsoft.com...
>> > Hi;
>> >
>> > They are both the same thing. The problem is we will have multiple
>> > different
>> > Application User's with data in the DB.
>> >
>> > Let me ask a different question as I may be under a false assumption.
>> > Lets
>> > say we have 10,000 different Application Users. Can we then create
>> > 10,000
>> > databases on a single Sql Server system? Or will that kill it? I've
>> > been
>> > assuming that that would be bad (just like events are better than
>> > threads
>> > and
>> > threads are better than processes and 10,000 processes will kill
>> > Windows).
>> >
>> > --
>> > thanks - dave
>> > david_at_windward_dot_net
>> > http://www.windwardr...
>> >
>> > Cubicle Wars - http://www.windwardr.../film.htm
>> >
>> >
>> >
>> >
>> > "Cor Ligthert[MVP]" wrote:
>> >
>> >> David,
>> >>
>> >> Proabably don't I understand your question.
>> >>
>> >> What is in this case the difference between the Application User and a
>> >> Application User Company?
>> >>
>> >> Cor
>> >>
>>

David Thielen

12/28/2007 6:53:00 PM

Hi;

I tried to find what you meant by helper tables but googling that got me all
kinds of different things. What do you mean by helper tables?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm

"Cor Ligthert[MVP]" wrote:

> David,
>
> Then why no helper tables to add the information that is needed to the rows?
>
> Cor
>
> "David Thielen" <thielen@nospam.nospam> schreef in bericht
> news:91764E3B-8C1A-4183-9B73-E90C82F3336F@microsoft.com...
> > It's a much more complicated schema than that. We have about 20 tables.
> > One
> > example is the invoice table - which does have a column for the user. But
> > there is a table of invoice items and it's only foreign key is the PK to
> > the
> > row in the invoice table.
> >
> > If we control all of the selects, no problem (assuming we don't make any
> > mistakes). But we want to let our users have the abaility to pull any of
> > their data out and so we want to give them the ability to make their own
> > selects, but then insure they get only their data.
> >
> > --
> > thanks - dave
> > david_at_windward_dot_net
> > http://www.windwardr...
> >
> > Cubicle Wars - http://www.windwardr.../film.htm
> >
> >
> >
> >
> > "Cor Ligthert[MVP]" wrote:
> >
> >> David,
> >>
> >> Normally I and probably most of us would solve this by creating a table
> >> with
> >> the users (companies), then the properties used and add those properties
> >> to
> >> the tables to select the rows which are available for the users
> >> (companies).
> >> Why is this approach not taken?
> >>
> >> Cor
> >>
> >> "David Thielen" <thielen@nospam.nospam> schreef in bericht
> >> news:1CAD6992-DCB6-48EF-806A-B61D936C406F@microsoft.com...
> >> > Hi;
> >> >
> >> > They are both the same thing. The problem is we will have multiple
> >> > different
> >> > Application User's with data in the DB.
> >> >
> >> > Let me ask a different question as I may be under a false assumption.
> >> > Lets
> >> > say we have 10,000 different Application Users. Can we then create
> >> > 10,000
> >> > databases on a single Sql Server system? Or will that kill it? I've
> >> > been
> >> > assuming that that would be bad (just like events are better than
> >> > threads
> >> > and
> >> > threads are better than processes and 10,000 processes will kill
> >> > Windows).
> >> >
> >> > --
> >> > thanks - dave
> >> > david_at_windward_dot_net
> >> > http://www.windwardr...
> >> >
> >> > Cubicle Wars - http://www.windwardr.../film.htm
> >> >
> >> >
> >> >
> >> >
> >> > "Cor Ligthert[MVP]" wrote:
> >> >
> >> >> David,
> >> >>
> >> >> Proabably don't I understand your question.
> >> >>
> >> >> What is in this case the difference between the Application User and a
> >> >> Application User Company?
> >> >>
> >> >> Cor
> >> >>
> >>
>
>

Cor Ligthert [MVP]

12/28/2007 7:37:00 PM

It can be all kind of tables,

However you have your existing data and want to keep that seperated from
your data to find information.

Then you can add another table(s) with references to your data which hold
the properties to specify the row as a special row for a special company.

I don't know if the name of that is a helper table, it is just the name I
call it like that.

Cor

microsoft.public.inetserver.asp.db

michael kors factory outlet bcV

Katadedajab

Cor Ligthert [MVP]

David Thielen

Cor Ligthert [MVP]

David Thielen

Cor Ligthert [MVP]

x Login to ForumsZone