[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Submission form handling



Here is the current implementation I am working on for the simple submission
forms.  Let me know if there is anything I am missing or if I translated the
tables wrong.  The simple submission is done except for error checking and
user handling, which should be done in a few hours, the rest is still in 
progress.

Simple submission stuff:

  Table Articles:

  Title - insert as text, check ! empty
  ProblemDesc - insert as text, check ! empty
  Resolution - insert as text, check ! empty (question submission forms should 
     be used for cases where this is empty)
  Keywords - insert as text, space-delimited list of single words
  Causes - insert as text, may be left empty

  Table ArticleUserXref:

  ArticleID - sucked from ID created from Articles insert
  UserID - sucked from user handling in scripts

Advanced submission (links to change it after submitting simple):

  Related Links:
  
  RelatedLinks Table:
  Href - insert as text, strip any http:// the user may add
  LinkName - insert as text, check ! empty
  LinkDesc - insert as text, may be empty
  ArticleLinkXref Table:
  ArticleID - int inserted based on article
  LinkID - id pulled from RelatedLinks table on link just created
  
  Article Categories:

  ArticleCatXref Table:
  ArticleID - int inserted based on article
  CategoryID - int inserted based on pull-down from Categories
  
-- 
-------------------
Daniel E. Markle
syntax@ashtech.net
-------------------