Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Help with user profiles

Reply
Thread Tools

Help with user profiles

 
 
mark | r
Guest
Posts: n/a
 
      06-20-2005


Im creating a food site where registered users can set a long list of
'dislikes' from a menu that can be added to, with the aim of the site being
searchable for things that DONT MATCH the 'dislikes' of a user - dislikes
would be in categories i.e. Fruit / Tomatos / Diced (because i like tomato
sauce, but not tomatos so id be able to select everything but sauce and
puree)

BTW im doing it this way because fussy eaters like me can list loads of what
they dont like but not much of what we do - the idea is id be able to be
shown recipes for meals that i will like.

anyone suggest the best format for structuring the tables in the database
for this project, because every avenue i try gets overcomplex really
quickly, or becomes un expandable.

Mark




 
Reply With Quote
 
 
 
 
Evertjan.
Guest
Posts: n/a
 
      06-20-2005
mark | r wrote on 20 jun 2005 in
microsoft.public.inetserver.asp.general:

>
>
> Im creating a food site where registered users can set a long list of
> 'dislikes' from a menu that can be added to, with the aim of the site
> being searchable for things that DONT MATCH the 'dislikes' of a user -
> dislikes would be in categories i.e. Fruit / Tomatos / Diced (because
> i like tomato sauce, but not tomatos so id be able to select
> everything but sauce and puree)
>
> BTW im doing it this way because fussy eaters like me can list loads
> of what they dont like but not much of what we do - the idea is id be
> able to be shown recipes for meals that i will like.
>
> anyone suggest the best format for structuring the tables in the
> database for this project, because every avenue i try gets overcomplex
> really quickly, or becomes un expandable.


There is no "best" way, Mark.

It depends on the way of programming you are familiar or happy with.

============================

I would:

Make a new 2 column DislikeTbl table of all dislikes, be it group or
individual dislikes.
dislikeID*, dislikeName

All products are coded in the productTbl table with say a maximum of 3
productDislikes.
[3 fields additional]

Make a new 3 column UserDislikeTbl table with
UserDislikeID*, userID, dislikeID, weight
[eight: 2 heavy, 1 slight, -1 like, -2 love, 0 off]


So any user can have a unlimited number of dislikes, each with it's
weight. [I suppose most will have no dislikes at all, but others have, so
the last table won't grow too large]

No dislikes are stored in the userTbl itself.

Tomato sauce will have 3 productDislikes:
Tomatos general & Tomato sauce specific, vegetable conserve.
Fresh tomato's 3:
Tomatos general & fresh Tomato specific, fresh vegetables.


You could have:

+1 Tomatos general
-2 Tomato sauce specific
-1 Tomato Ketchup specific

the SQL string will test for entries in UserDislikeTbl and you compute
the resultingDislikeValue being positive or not.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

 
Reply With Quote
 
 
 
 
mark | r
Guest
Posts: n/a
 
      06-20-2005



"Evertjan." <(E-Mail Removed)> wrote in message
news:Xns967B9DCB6D474eejj99@194.109.133.242...
>
>
> mark | r wrote on 20 jun 2005 in
> microsoft.public.inetserver.asp.general:
>
> >
> >
> > Im creating a food site where registered users can set a long list of
> > 'dislikes' from a menu that can be added to, with the aim of the site
> > being searchable for things that DONT MATCH the 'dislikes' of a user -
> > dislikes would be in categories i.e. Fruit / Tomatos / Diced (because
> > i like tomato sauce, but not tomatos so id be able to select
> > everything but sauce and puree)
> >
> > BTW im doing it this way because fussy eaters like me can list loads
> > of what they dont like but not much of what we do - the idea is id be
> > able to be shown recipes for meals that i will like.
> >
> > anyone suggest the best format for structuring the tables in the
> > database for this project, because every avenue i try gets overcomplex
> > really quickly, or becomes un expandable.

>
> There is no "best" way, Mark.
>
> It depends on the way of programming you are familiar or happy with.
>
> ============================
>
> I would:
>
> Make a new 2 column DislikeTbl table of all dislikes, be it group or
> individual dislikes.
> dislikeID*, dislikeName
>
> All products are coded in the productTbl table with say a maximum of 3
> productDislikes.
> [3 fields additional]
>
> Make a new 3 column UserDislikeTbl table with
> UserDislikeID*, userID, dislikeID, weight
> [eight: 2 heavy, 1 slight, -1 like, -2 love, 0 off]
>
>
> So any user can have a unlimited number of dislikes, each with it's
> weight. [I suppose most will have no dislikes at all, but others have, so
> the last table won't grow too large]
>
> No dislikes are stored in the userTbl itself.
>
> Tomato sauce will have 3 productDislikes:
> Tomatos general & Tomato sauce specific, vegetable conserve.
> Fresh tomato's 3:
> Tomatos general & fresh Tomato specific, fresh vegetables.
>
>
> You could have:
>
> +1 Tomatos general
> -2 Tomato sauce specific
> -1 Tomato Ketchup specific
>
> the SQL string will test for entries in UserDislikeTbl and you compute
> the resultingDislikeValue being positive or not.
>
> --
> Evertjan.
> The Netherlands.
> (Replace all crosses with dots in my emailaddress)
>
>
>


thanks, ill wrap my head around this one and let you know if i cant figure
somethign out - thanks
mark




 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete User Profiles via ASP.net webform using VB.net =?Utf-8?B?Um9ja3k=?= ASP .Net 0 01-19-2006 05:50 PM
User Profiles and ASP 2.0 Alexandr Zverev ASP .Net 3 08-02-2005 12:37 PM
Moz1.7.5. Multiple profiles, profiles lacking email accts crash. oops Splibbilla Firefox 0 03-21-2005 02:58 AM
User profiles on NT4 Jo Computer Support 4 06-30-2004 10:27 PM
Win2k problems with multiple user profiles newsguy Computer Support 1 04-24-2004 08:34 AM



Advertisments