[thesite] didnt see this come through..
Daniel J. Cody
djc at starkmedia.com
Sat Mar 3 14:08:25 CST 2001
ok, here's what I got.. for testting purposes, we're using SQL server
here, not that it matters.. the datasource name in CF is 'thelist'
shouldnt hdr_inreplyto be a number?
anyways, whenever you get around to it, hve fun and lemm eknow if you
have problems ;) thanks again seth
CREATE TABLE [thelist] (
[listid] [int] NULL ,
[messageid] [int] NOT NULL ,
[hdr_messageid] [int] NOT NULL ,
[hdr_fromname] [varchar] (75) NOT NULL ,
[hdr_fromemail] [varchar] (100) NOT NULL ,
[hdr_toemail] [varchar] (100) NULL ,
[hdr_subject] [varchar] (100) NOT NULL ,
[hdr_date] [datetime] NOT NULL ,
[hdr_inreplyto] [varchar] (75) NULL ,
[bdy_content] [text] NOT NULL
Seth Bienek wrote:
> listid (fk to lookup table with list names) > messageid (pk) >
hdr_message-id (text-75char) > hdr_fromemail (text-100char) >
hdr_fromname (text-100char) > hdr_toemail (text-100char - optional may
be used instead of listid?) > hdr_subject (text-100char) > hdr_date
(date) > hdr_in-reply-to (text-75char) > bdy_content (long, memo,
whatever) >
More information about the thesite
mailing list