I'll wade through and list the questions and if I miss one I hope the list will let me know. Patrick
>-----Original Message----- >From: Candace Cottrell [mailto:[EMAIL PROTECTED] >Sent: March 20, 2003 12:26 PM >To: CF-Community >Subject: Questionaire site (was RE: Bill's long download) > > >Tim, do you want me to do a layout mock-up once Patrick gets the >requirements? Or do you want me to wait until the end and add >the design >stuff? > >Candace K. Cottrell, Web Developer >The Children's Medical Center >One Children's Plaza >Dayton, OH 45404 >937-641-4293 >http://www.childrensdayton.org > > >[EMAIL PROTECTED] > >>>> [EMAIL PROTECTED] 3/20/2003 10:46:24 AM >>> >Looks like a good parent-child relationship to me ;) > > >Candace K. Cottrell, Web Developer >The Children's Medical Center >One Children's Plaza >Dayton, OH 45404 >937-641-4293 >http://www.childrensdayton.org > > >[EMAIL PROTECTED] > >>>> [EMAIL PROTECTED] 3/20/2003 10:27:49 AM >>> >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
