Re: Design question (Database etc)

2006-11-25 Thread Doug Brown
Do you know of a site that is using auctionBuilder? I tried looking for a demo, but I guess they do not have one. Doug B. - Original Message - From: "Snake" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Saturday, November 25, 2006 5:42 AM Subject: RE: Design quest

RE: Design question (Database etc)

2006-11-25 Thread Snake
Btw there are apps already out there both of these, auctionbuilder and classifieds) Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 25 November 2006 04:37 To: CF-Talk Subject: Re: Design question (Database etc) Thanks for the insight Patrick. What I am

RE: Design question (Database etc)

2006-11-25 Thread Snake
, formfieldID, answer) Then you can build your form dynamically from this data. Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 25 November 2006 02:02 To: CF-Talk Subject: Re: Design question (Database etc) Jon, I think I may have confused the subject. In

Re: Design question (Database etc)

2006-11-24 Thread Doug Brown
general in nature. Maybe that will help me in my task at hand. Regards, Doug B. - Original Message - From: "Patrick McElhaney" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, November 24, 2006 7:44 PM Subject: Re: Design question (Database etc) > Now tha

Re: Design question (Database etc)

2006-11-24 Thread Patrick McElhaney
Now that I've answered your question, let me throw in an opinion. If you're building a generic classified system, you might be better off with category, description and maybe a couple fields for contact information. That seems to have worked for craigslist. Patrick On 11/24/06, Doug Brown <[EMAI

Re: Design question (Database etc)

2006-11-24 Thread Patrick McElhaney
You should be able to pull it off with three tables. The first one defines the categories. Categories --- CategoryID (PK) Name Description etc. The next one defines what fields are associated with each category. CategoryFields -- FieldID (PK) CategoryID (FK ->

RE: Design question (Database etc)

2006-11-24 Thread Bobby Hartsfield
tegoriesDetails with 'DetailID' ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Friday, November 24, 2006 7:18 PM To: CF-Talk Subject: Design question (Database etc) I am in the process of re-desig

Re: Design question (Database etc)

2006-11-24 Thread Doug Brown
- Original Message - From: "Jon Clausen" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, November 24, 2006 6:06 PM Subject: Re: Design question (Database etc) > Doug, > > Just a suggestion, but, if you need have multiple categories per > item, maybe

RE: Design question (Database etc)

2006-11-24 Thread Snake
I think you just need a category lookup table. advertID CategoryID Russ -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 25 November 2006 00:18 To: CF-Talk Subject: Design question (Database etc) I am in the process of re-designing a classifieds system and was just

Re: Design question (Database etc)

2006-11-24 Thread Jon Clausen
thinking right. Too much turkey...Makes > you brain > dead. > > > > - Original Message - > From: "Doug Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Friday, November 24, 2006 5:17 PM > Subject: Design question (Database etc) > &g

Re: Design question (Database etc)

2006-11-24 Thread Doug Brown
brain dead. - Original Message - From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, November 24, 2006 5:17 PM Subject: Design question (Database etc) > I am in the process of re-designing a classifieds system and was just wondering a few th

Design question (Database etc)

2006-11-24 Thread Doug Brown
I am in the process of re-designing a classifieds system and was just wondering a few things. Currently there is just one standard for to fill out for the ads. I am thinking of designing it to where it is more useful. I would like to make the form as dynamic as possible by having different input