[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