ooops
Forgot nQuestionID in the answers table See below:
create table answers(
nAnswerID int identity primary key not null,
cAnswer text,
nUserID int,
nQuestionID int,
dLastModified datetime
)
-----Original Message-----
From: Timothy Heald
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
