Almost. You forgot a link from answer to question. :-)
You might want a link from the question to the person who first posed it (if
we want to track that). Just an idea.
Also, I might shrink the size of the question field or turn it into a text.
It seems to me that if 500 or so isn't big enough, you really ought to just
make it of unlimited size.
Hmm. Other than that, it looks okay to my eyes. Of course, I'm just
looking at structure, not proofreading it.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
: Sent: Thursday, March 20, 2003 10:18 AM
: To: CF-Community
: Subject: RE: Bill's long download
:
:
: Hehe,
:
: I have been doing oracle at work and almost nothing at home on SQL
: Server. This look about right?
:
: <cfquery name="createQuestions" datasource="home">
: create table questions(
: nQuestionID int identity primary key not null,
: cQuestion varchar(2000),
: )
:
: create table users(
: nUserID int identity primary key not null,
: cUserName varchar(50),
: cPassword varchar(50),
: cFirstName varchar(50),
: cLastName varchar(50),
: cEmail varchar(200),
: accessLevel int
: )
:
: create table answers(
: nAnswerID int identity primary key not null,
: cAnswer text,
: nUserID int,
: dLastModified datetime
: )
: </cfquery>
:
: Tim
:
: -----Original Message-----
: From: Timothy Heald
: Sent: Thursday, March 20, 2003 10:00 AM
: To: CF-Community
: Subject: RE: Bill's long download
:
:
: Tell you what, someone else write up the requirements and I will
: do the DB,
: and write it. I need something fun to do.
: Tim
:
: -----Original Message-----
: From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
: Sent: Thursday, March 20, 2003 9:57 AM
: To: CF-Community
: Subject: Re: Bill's long download
:
:
: LOL i work 2 jobs to uhh pay for my loving wifes road trip from
: hell :) if i
: can find the time sure thing i'll work it up and host it on my servers.
:
: ----- Original Message -----
: From: "Larry C. Lyons" <[EMAIL PROTECTED]>
: To: "CF-Community" <[EMAIL PROTECTED]>
: Sent: Thursday, March 20, 2003 9:51 AM
: Subject: Re: Bill's long download
:
:
: I take it you're volunteering Bill?
:
: larry
:
: At 09:21 AM 3/20/2003 -0500, you wrote:
: >Hay i answered 99% of the questions so i dont want to hear any shit outta
: >you slackers!! :)
: >Someone should do up a cf app to goto and fill out questions and add new
: >questions. It will email you and let you fill out the new info so we dont
: >have 1000 emails but i was hoping we could break the 1000+
: message barrier
: >and put mikey's code to the test.
: >
: >----- Original Message -----
: >From: "Ben Doom" <[EMAIL PROTECTED]>
: >To: "CF-Community" <[EMAIL PROTECTED]>
: >Sent: Thursday, March 20, 2003 9:10 AM
: >Subject: Bill's long download
: >
: >
: >Today, AT&T cut a backbone fiber leading into KY, so everyone
: dependent on
: >them for internet (like all the Alltel customers) (including
: Moonbow) went
: >internetless. After lunch, we set up an Apple Airport to dial into
: >Earthlink (which apparently uses a different backbone).
: >
: >So I checked my mail.
: >
: >I was sure something was wrong. I mean, how many emails from
: Bill Wheatley
: >can there be regarding the question thread? That's got to be the same
: >message downloading multiple times, right?
: >
: >Dear god, Bill. You make me glad I'm usually on fast DSL.
: >
: >*sigh* Well, now that they're all downloaded, all that's left
: is for me to
: >read it all....
: >
: >:-)
: >
: >
: >-- Ben "creeping along the internet" Doom
: > Programmer & General Lackey
: > Moonbow Software, Inc
: >
: >
: >
: >
:
:
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
