| 01:41.10 | *** join/#uphpu drewbono (n=andrew@c-24-2-95-76.hsd1.ut.comcast.net) |
| 03:40.10 | *** join/#uphpu dataw0lf- (n=dataw0lf@c-24-10-173-249.hsd1.ut.comcast.net) |
| 05:04.35 | *** join/#uphpu tierra (n=tierra@c-24-10-173-249.hsd1.ut.comcast.net) |
| 05:09.14 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 06:29.23 | *** part/#uphpu niquil (n=niq@echoradio.org) |
| 13:23.41 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) |
| 13:23.45 | *** mode/#uphpu [+o macnewbold] by ChanServ |
| 13:37.46 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 13:57.21 | *** join/#uphpu xilch|w (n=zandork@66.239.17.226.ptr.us.xo.net) |
| 14:09.38 | macnewbold | ~yow |
| 14:09.52 | dataw0lf | morning |
| 14:16.21 | macnewbold | morning, dw |
| 14:18.07 | *** join/#uphpu wps (n=wade@66.237.80.85) |
| 14:18.09 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool139-115.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 14:18.10 | *** mode/#uphpu [+o wps] by ChanServ |
| 14:24.26 | RyanE_ | *Good* morning. First Day of School down here. Always a *good* morning. |
| 14:26.27 | dataw0lf | haha |
| 14:26.32 | dataw0lf | getting em out of your hair? |
| 14:28.02 | RyanE_ | well, out of the mamae's hair. I *go* to work these days, but the last few years while working from home, this day was always good. |
| 14:35.16 | macnewbold | so how do you feel about not working at home any more? |
| 14:35.32 | macnewbold | is the commute a plus or a minus, overall? |
| 14:35.55 | macnewbold | do you get more done now, or get to spend more quality time with your family? |
| 14:37.09 | *** join/#uphpu trogdorr (n=ksnyder@12.174.39.194) |
| 14:49.42 | RyanE_ | I think I was at least as productive at home as I am at work, and I prefer working from home, but I really like the new job |
| 14:50.10 | RyanE_ | but I'd better get going to work now... later. |
| 14:54.30 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 15:23.09 | *** join/#uphpu jsmith (n=jsmith@64.50.35.114.2O7.net) |
| 15:51.59 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool139-115.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 16:51.17 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool139-115.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 16:51.20 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool139-115.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 16:57.44 | *** join/#uphpu kryp71k|w (n=kryp71k@64.50.125.202) |
| 17:25.18 | mindjuju | sql normalization question: i have several surveys that are recording data from various questions. these question maybe fill in the blank, essay, checkbox, etc, so various things. I wondering what the database schema should look like. right now i'm thinking |fld_answerID|fld_questionID|fld_client|fld_date| |
| 17:25.33 | mindjuju | oops, left out the answer slot here it is again |
| 17:25.52 | mindjuju | |fld_answerID|fld_questionID|fld_client|fld_date|fld_clientanswer| |
| 17:26.11 | mindjuju | where the field, client answer is a varchar (1000) |
| 17:26.26 | mindjuju | that way it allows for sentence answers |
| 17:31.44 | *** join/#uphpu tierra (n=tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 17:40.51 | diskotec|w | Is there a site or documentation that explains on how to setup your database to store a collection of articles and or essays? Essays could be really long and articles could be a paragraph or two. I would like to know how to do this for mysql/pgsql as well as mssql. What keywords would I use to do a google search on this? (I'm still trying to get used to database terminology) |
| 17:41.37 | mindjuju | most databases have the datatype text |
| 17:42.04 | mindjuju | text |
| 17:42.04 | mindjuju | <PROTECTED> |
| 17:42.04 | mindjuju | Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes. |
| 17:42.08 | diskotec|w | how long is it possible for that datatype? |
| 17:42.52 | mindjuju | 1000 characters is like a 4 line paragraph |
| 17:43.38 | mindjuju | that description of the text datatype is from MSSQL |
| 17:43.46 | mindjuju | i think MySQL is comprobable |
| 17:47.44 | mindjuju | here is info for MySQL |
| 17:47.45 | mindjuju | http://dev.mysql.com/doc/mysql/en/blob.html |
| 17:49.20 | mindjuju | oh wait, this page tells you about half way down how many characters the fields store |
| 17:49.20 | mindjuju | http://dev.mysql.com/doc/mysql/en/storage-requirements.html |
| 17:49.30 | mindjuju | LONGBLOB, LONGTEXT L+4 bytes, where L < 232 |
| 17:49.43 | mindjuju | that should read 2 ^32 instead of 232 |
| 17:55.45 | mindjuju | so your database schema should look something like |fld_articleID|fld_article|fld_daterecorded| where fld_articleID is an autoincrementing int to uniquely identify each article, followed by the article itself in the text (mssql) or longtext(mysql) datatype, followed by the date recorded which is optional, but i've found always been important |
| 17:58.11 | cycokilr | you could even throw in a cool little javascript calendar/date picker and record the date the article or essay was written in another field.. |
| 17:58.29 | cycokilr | that is, in a web interface to your database.. |
| 18:17.00 | diskotec|w | Thanks mindjuju |
| 18:17.30 | mindjuju | no worries |
| 18:17.36 | mindjuju | hope it was helpful |
| 18:18.34 | diskotec|w | good suggestion cycokilr. I was thinking about doing something like that for the hospital but on my own I wanted to create my own web/..sql app that could accept any length essay's and articles. |
| 18:20.56 | mindjuju | macnewbold |
| 18:20.59 | diskotec|w | I'm new to this so I'll probably have more questions later |
| 18:21.21 | macnewbold | mindjuju: sup? |
| 18:21.58 | mindjuju | hey, what is better/faster? storing articles as text in sql, or storing info about the article in sql and storing the article as a text file? |
| 18:22.09 | macnewbold | not much difference |
| 18:22.20 | macnewbold | if you've already got it in the db, it makes it _really_ easy to search :) |
| 18:22.36 | macnewbold | plus mysql has "full text" search now, that gives results by their "relevance" |
| 18:22.44 | macnewbold | haven't tried it, but want to :) |
| 19:11.24 | *** join/#uphpu eco|w (n=eco@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 20:10.54 | jsmith | Kinda quiet in here... |
| 20:11.08 | mindjuju | yeah |
| 20:11.23 | mindjuju | was going to talk politics with d dub, but i'm behind on some projects |
| 20:11.32 | mindjuju | have to be good |
| 20:11.47 | jsmith | Oh boy... |
| 20:12.04 | mindjuju | :) |
| 20:14.44 | dataw0lf | and by talk politics with d dub he means get smacked around ideologically. |
| 20:15.11 | jsmith | dataw0lf: I don't imagine you'd get smaked around by anyone... |
| 20:15.16 | jsmith | s/smaked/smacked/ |
| 20:16.06 | dataw0lf | it doesn't happen often. |
| 20:16.18 | mindjuju | wha! |
| 20:19.53 | mindjuju | and nobody better be calling my place of employment to offer good ideas for additional projects, just so i won't talk politics! |
| 20:20.35 | dataw0lf | mindjuju: fyi, I was about to attend the antiwar protest @ Pioneer Park, but I unfortunately couldn't find all the elements of my Class As. |
| 20:21.34 | mindjuju | Tempt me Not! |
| 20:21.38 | mindjuju | ...focus... |
| 20:23.02 | mindjuju | yeah, if you'd shown up, i'm sure you'd be front cover of tomorrow's paper |
| 20:23.26 | mindjuju | Class As is full formal, isn't it? what color is it for Army? |
| 20:23.34 | dataw0lf | well, no, blues are full formal. |
| 20:23.55 | dataw0lf | but I was a soldier, not some hooah kid straight out of ROTC |
| 20:23.56 | mindjuju | Class As is the forest green suit |
| 20:24.00 | dataw0lf | correct. |
| 20:24.05 | mindjuju | k, i know the one |
| 20:24.22 | dataw0lf | if I had my actual Bronze Star medal, I would've thrown it at Bush's head! |
| 20:26.00 | mindjuju | i'm tossed between my civic duty and my employment duties |
| 20:26.27 | mindjuju | come thursday/friday, i should be caught up enough |
| 20:28.34 | dataw0lf | what's your civic duty? |
| 20:30.09 | mindjuju | civic duty to me means that the government is representative of the idea that I feel are correct, that if there is a difference between what I feel and what is taking place, I either try to change governement or try to understand why it is important for government to opreate the way it does |
| 20:31.09 | mindjuju | in this case, you present a well thought out liberal point of view, our debates help me to at least see what the liberals want and why |
| 20:31.45 | dataw0lf | huh. |
| 20:31.45 | mindjuju | remove the word liberal and substiture the word alternate |
| 20:31.51 | dataw0lf | never knew I was necessarily a liberal. |
| 20:31.52 | dataw0lf | ah, ok. |
| 20:31.59 | mindjuju | yeah, my bad |
| 20:33.21 | mindjuju | what I do want to discuss though is possible alternate motives for Iraq war, and how they play into world politics, IE oil, supremacy through oil |
| 20:34.04 | mindjuju | china's current focus to purchase as much oil for their country -- matched by india's desire to do likewise, IMF saying that global encomy isn't doing well in light of high crude prices... |
| 22:18.34 | *** join/#uphpu diskotec|w (n=virc@12.125.156.114) |
| 22:19.06 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) |
| 22:19.10 | *** mode/#uphpu [+o macnewbold] by ChanServ |
| 22:27.37 | *** join/#uphpu diskotec|w (n=virc@12.125.156.114) |
| 23:19.33 | macnewbold | Announcement: Tuesday Aug. 30 will be our next Phlyte meeting, at 7pm in the usual place. |
| 23:19.36 | macnewbold | everybody come |
| 23:19.50 | macnewbold | dataw0lf: when do you want to install the spiffy new server? |
| 23:24.14 | *** join/#uphpu Utah_Dave (n=boucha@0-3pool128-51.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 23:37.09 | mindjuju | mac, you'll never get d dub's attention that way. you have to say something politically charged like that you Love George Bush, or something along those lines. if he is around, he'll respond |
| 23:39.15 | macnewbold | dataw0lf: mindjuju says you Love George Bush... when can you come install the server? |
| 23:40.01 | mindjuju | ! |
| 23:40.07 | mindjuju | k, now your going to get my butt kicked! |
| 23:41.48 | macnewbold | dataw0lf: mindjuju threatened to kick your butt... when do you want to do that server install thing? |
| 23:52.39 | mindjuju | hey, does anybody know off hand if you have a webpage with an iframe can the parent window have a script that inserts information into an element in the webpage loaded on the iframe? i'm almost positive its not allowed for security reasons, but wanted to check before researching |
| 23:56.46 | macnewbold | The parent may be able to do something inside the iframe, but I'm pretty sure that the other way around would be evil, and is disallowed. But that's just an opinion, not a statement of fact or anything. I haven't checked what they really do or what the standard really says. |
| 23:57.47 | mindjuju | i'm in the process of updating some code with some quick functionality that is desired, i'm going to come back and fix it so that it is coded right, but this goofus first built a page that has 2 frames |
| 23:58.00 | mindjuju | and in the main frame, it calls a page that calls 2 more frames |
| 23:58.09 | mindjuju | it gets really dizzy after that |
| 23:58.57 | macnewbold | three cheers for recursion! |
| 23:59.02 | macnewbold | ~praise recursion |
| 23:59.02 | jbot | All hail recursion! |
| 23:59.32 | mindjuju | grrrr. three cheers for steel toed boots for kicking bad programmers in the jimmies |
| 23:59.53 | mindjuju | ~praise steel toed boots for kicking bad programmers in the jimmies |
| 23:59.53 | jbot | All hail steel toed boots for kicking bad programmers in the jimmies! |