| 00:04.43 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool139-24.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 00:07.13 | bigdog_ut | ~wake mindjuju |
| 00:07.14 | jbot | mindjuju: GOOD MORNING!!! |
| 00:07.20 | bigdog_ut | you hear what im sayin |
| 00:08.01 | mindjuju | yup |
| 00:08.27 | mindjuju | well i've got some great news about IE 7 |
| 00:09.01 | mindjuju | the computer seems to have patched itself, and i can now make it to about 10% of the web pages I go to |
| 00:09.20 | mindjuju | but on the pages that have CSS, only about 20% of the page comes up |
| 00:09.33 | mindjuju | divs that have background images though, don't seem to be coming up |
| 00:10.04 | bigdog_ut | ~shot ie 7 |
| 00:11.58 | mindjuju | i hope they fix it before it launches |
| 00:12.17 | bigdog_ut | why even us it |
| 00:12.21 | bigdog_ut | ie sucks? |
| 00:12.58 | mindjuju | 98% of our clients use it, have to be ready for the new IE |
| 00:13.07 | mindjuju | it would suck for me if my site didn't work in IE 7 |
| 00:13.25 | bigdog_ut | so would 98% of all other sites |
| 00:13.55 | mindjuju | yup. i've been studying / implementing a lot of CSS into the new corporate site |
| 00:14.13 | mindjuju | so lots of it aren't working |
| 00:30.30 | *** part/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 01:12.33 | mindjuju | c ya'll |
| 05:25.22 | *** join/#uphpu cycoslut (i=cycokilr@c-67-166-121-149.hsd1.ut.comcast.net) |
| 11:41.09 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 14:24.41 | *** join/#uphpu synic (n=synic@c-67-177-16-249.hsd1.ut.comcast.net) |
| 17:49.08 | *** join/#uphpu cycokilr (n=cycokilr@c-67-166-121-149.hsd1.ut.comcast.net) |
| 17:52.06 | *** part/#uphpu cycokilr (n=cycokilr@c-67-166-121-149.hsd1.ut.comcast.net) |
| 17:52.16 | *** join/#uphpu cycokilr (i=cycokilr@c-67-166-121-149.hsd1.ut.comcast.net) |
| 19:26.25 | bigdog_ut | afternoon all |
| 19:26.31 | mindjuju | yo |
| 19:26.45 | bigdog_ut | hows it going mindjuju |
| 19:27.05 | mindjuju | not bad, just writing some tables, how's the projects coming? |
| 19:27.11 | bigdog_ut | good |
| 19:30.43 | bigdog_ut | you watching movies mindjuju? |
| 19:32.15 | mindjuju | nope, listening to dj buddha |
| 19:36.13 | mindjuju | what about u? |
| 19:36.29 | bigdog_ut | doing a price quote for some work |
| 19:38.31 | mindjuju | i noticed that you play a lot of seether, what up with that? |
| 19:38.44 | bigdog_ut | they are killer |
| 19:39.11 | bigdog_ut | depeche mode has a new album coming out |
| 19:39.23 | bigdog_ut | i heard precious yesterday that was killer |
| 19:40.12 | mindjuju | did it sound 80's ish or what was it like, haven't heard about the new album |
| 19:40.31 | bigdog_ut | it sounded like there old stuff |
| 19:47.23 | mindjuju | can't seem to find it online (their website or yahoo music) did you hear it on the radio? |
| 19:51.08 | mindjuju | fld_transactionID |
| 19:51.16 | bigdog_ut | http://www.depechemode.com/ |
| 19:51.24 | bigdog_ut | check out news section |
| 19:52.01 | bigdog_ut | http://www.depechemode.com/news/index.html#081105_pta_cover |
| 19:52.39 | bigdog_ut | it is called "Playing the Angel" |
| 19:52.54 | mindjuju | way cool! |
| 19:53.38 | bigdog_ut | i heard precious the other day and it is really good |
| 19:55.31 | bigdog_ut | ill see if i can get a copy of it |
| 19:57.18 | mindjuju | that would be awesome |
| 19:59.20 | bigdog_ut | i got a remix of it |
| 19:59.35 | mindjuju | where did you find it? |
| 20:16.16 | bigdog_ut | man makes me anxious to hear the new album |
| 20:16.41 | mindjuju | it would be nice to hear something new from them |
| 20:16.46 | mindjuju | always loved their stuff |
| 20:21.07 | bigdog_ut | yeah exciter was the last one in 2001 |
| 20:21.12 | bigdog_ut | man 4 years ago |
| 20:39.31 | *** join/#uphpu wps_ (n=wade@65.73.113.199) |
| 21:08.26 | mindjuju | bigdog, if you working going to make an app that allowed you to create questionairres for clients, would you create 3 tables, one to store all the questions and possible answers (possible answers would be stored as HTML strings), one table for the questionaire to mark which questions should be asked, and one table to store the answers given? |
| 21:22.31 | *** join/#uphpu RyanE (n=ryan@rberick.dsl.xmission.com) |
| 21:25.29 | mindjuju | man, i keep on getting confused on the many to many relationship between the questions table and the questionaire's table |
| 21:26.50 | mindjuju | seems wrong to create a table where 1 questionaire is 1 record with all the questions belonging to the questionaire in 1 field |
| 21:28.02 | mindjuju | i'm thinking that the questionaire table should be soemthing like questionaireID, questionID, datecreated, and some enumerating string to use as a key |
| 21:44.12 | mindjuju | bigdog, you around? |
| 21:51.21 | bigdog_ut | sorry grabbed lunch |
| 21:51.31 | mindjuju | no worries, gave me more time to think about it |
| 21:51.33 | bigdog_ut | i would do something liek this |
| 21:51.42 | bigdog_ut | questionaire table |
| 21:51.46 | bigdog_ut | question table |
| 21:51.53 | bigdog_ut | answers table |
| 21:52.54 | bigdog_ut | i have even done question_multi-choice tables |
| 21:53.31 | mindjuju | so, in the questionaire table, it one record = one questionaire with all questions in that questionaire in a field? |
| 21:54.28 | mindjuju | like |questionaireID|questions|questionaireName|datecreated| ? |
| 21:54.38 | bigdog_ut | not questions |
| 21:54.57 | bigdog_ut | just the information related to a questionaire |
| 21:55.10 | bigdog_ut | then you have a questionaire_questions join table |
| 21:55.25 | mindjuju | i was just headed that way, a 4th table |
| 21:55.34 | mindjuju | but then I thought I was getting anal |
| 21:55.54 | bigdog_ut | that woudl be like: questionaireId | question_type | question_id |
| 21:56.32 | bigdog_ut | and you would do something similar for multichoice questions |
| 21:56.46 | bigdog_ut | true/false you dont need anything |
| 21:56.54 | bigdog_ut | free text you dont need anything |
| 21:57.08 | bigdog_ut | multichoice and select you need a answer assigned |
| 21:57.37 | bigdog_ut | so multi and select work the same just that you can have more than one for a answer |
| 22:01.16 | bigdog_ut | did that make sense |
| 22:02.29 | mindjuju | yup |
| 22:02.45 | mindjuju | 3 main tables with a join table linking questions to questionairres |
| 22:03.43 | bigdog_ut | and then you want a join table between question and answer too |
| 22:03.51 | bigdog_ut | for question_answer table |
| 22:04.03 | bigdog_ut | that is for your select and multiselect questions |
| 22:04.53 | mindjuju | ...thinking/rereading.... |
| 22:07.15 | mindjuju | ok, i'm cool |
| 22:07.28 | bigdog_ut | did that make sense |
| 22:07.39 | bigdog_ut | that is how i implemented it for a customer |
| 22:07.51 | bigdog_ut | so that they could create questionaires easily |
| 22:19.07 | bigdog_ut | if you like i can big up some db schema if you like |
| 22:20.37 | mindjuju | if you have them handy, that would be awesome. |
| 22:20.50 | bigdog_ut | let me see |
| 22:29.35 | bigdog_ut | mindjuju, it is in mysql |
| 22:30.08 | mindjuju | that's ok, i've got a mysql database running |
| 22:32.34 | bigdog_ut | sent it...in mine i we call them surveys |
| 22:32.42 | bigdog_ut | the concept is all the same though |