Looks good to me Tim!
Patrick
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: March 20, 2003 10:28 AM
>To: CF-Community
>Subject: RE: Bill's long download
>
>
>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
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
