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
