| 02:31.51 | *** join/#uphpu Utah_Dave (n=boucha@c-67-166-71-219.hsd1.ut.comcast.net) |
| 02:35.55 | *** join/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |
| 02:39.35 | mindjuju | woot! |
| 02:39.36 | mindjuju | Several American ninja movies starring Sho Kosugi were released in the 1980s as well. Kosugi is to be in the upcoming movie The Return of the Ninja, which is to be released in 2006. |
| 02:43.48 | *** join/#uphpu wps (n=wps@65.73.113.162) |
| 02:43.49 | *** mode/#uphpu [+o wps] by ChanServ |
| 03:30.25 | *** part/#uphpu Utah_Dave (n=boucha@c-67-166-71-219.hsd1.ut.comcast.net) |
| 04:02.36 | mindjuju | anybody around? |
| 04:10.03 | mindjuju | well, i'll post this in case anybody happens to look at their IRC and knows what this means, cause in my fatique, i can't even fathom a guess |
| 04:10.05 | mindjuju | elationship has cardinality other than either zero-or-one or exactly-one, yet the child columns form a key. |
| 04:10.20 | mindjuju | supposedly, it means this:The cardinality of the relationship must be either zero-or-one or exactly-one, because the child columns are constrained to be unique. The cardinality of the relationship permits duplicate children, so the cardinality might be incorrect. |
| 04:10.28 | mindjuju | though that's as clear as mud to me |
| 04:10.51 | *** join/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |
| 04:38.25 | *** join/#uphpu bigdog_ut (n=bigdog@207.135.132.13) |
| 04:38.26 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 04:54.43 | mindjuju | yo bigdog! |
| 04:55.05 | mindjuju | i have a sql question if you have a moment |
| 04:56.28 | mindjuju | dag, should have been paying more attention to the IRC, you around bigdog_ut? |
| 04:57.34 | bigdog_ut | yes |
| 04:57.53 | mindjuju | hey, what does this mean? |
| 04:58.01 | mindjuju | relationship has cardinality other than either zero-or-one or exactly-one, yet the child columns form a key. |
| 04:58.12 | mindjuju | the answer i found said this: |
| 04:58.12 | mindjuju | supposedly, it means this:The cardinality of the relationship must be either zero-or-one or exactly-one, because the child columns are constrained to be unique. The cardinality of the relationship permits duplicate children, so the cardinality might be incorrect. |
| 04:58.51 | mindjuju | but that didn't make any more sense. in my defense, i had like 5 hours sleep |
| 04:58.55 | bigdog_ut | where are you reading that? |
| 04:59.58 | mindjuju | well, i was trying out MS Visio to help design databases (as visio is free for me) i'd try to put in a PO for Erwin, but i doubt i'd be authorized to purchase |
| 05:00.41 | bigdog_ut | you are reading it where? |
| 05:01.54 | mindjuju | well, after i designed the database, i went to generate the sql script for it and i got it there as an error |
| 05:02.10 | bigdog_ut | do you understand cardinality? |
| 05:02.54 | mindjuju | isn't cardinality have to do with the sequence of record? |
| 05:03.03 | bigdog_ut | not exactly |
| 05:03.25 | bigdog_ut | cardinality represents the number of occurences between entities. |
| 05:03.44 | bigdog_ut | so what is an entity? |
| 05:04.15 | bigdog_ut | an entity is a person, place, thing, event, or concept about which the busines keeps data in a database |
| 05:04.33 | bigdog_ut | for example...employee, salary |
| 05:04.47 | bigdog_ut | book or author |
| 05:05.14 | bigdog_ut | this leads to a relationship |
| 05:05.15 | mindjuju | mulling |
| 05:05.37 | bigdog_ut | relationship is a logical link between two entities |
| 05:06.11 | bigdog_ut | in database terms they represent a business rule or constraint (my main complaint about mysql) |
| 05:06.26 | bigdog_ut | like a foreign key constraint |
| 05:06.39 | bigdog_ut | customer -> customer address |
| 05:06.44 | bigdog_ut | customer -> order |
| 05:06.57 | bigdog_ut | book -> author |
| 05:07.03 | bigdog_ut | employee -> salary |
| 05:07.14 | bigdog_ut | those are some examples of relationships |
| 05:08.01 | bigdog_ut | now a relationships' cardinality represents the number of occurrences between the entities |
| 05:08.25 | bigdog_ut | this is represented when database terms as: one to many, many to many, one to one |
| 05:08.36 | bigdog_ut | take one to many as an example |
| 05:09.11 | bigdog_ut | sorry back track some |
| 05:09.36 | bigdog_ut | entities that have a cardinality of are said to be a parent entity |
| 05:09.43 | mindjuju | i'm still here, i'm just really focusing on what your saying and looking at the table and looking at the explinations |
| 05:09.49 | bigdog_ut | no problem |
| 05:10.08 | bigdog_ut | entities with one or more is called a child entity |
| 05:10.42 | bigdog_ut | in the above example of customer -> order entity it means that customer is a parent entity and order is a child entity |
| 05:11.29 | bigdog_ut | meaning there is one and only one customer that is logically linked to one or more orders |
| 05:12.11 | bigdog_ut | this gives way to the following relationships or cardinality: one to many, many to many, and one to one |
| 05:12.58 | bigdog_ut | customer -> order relationship is of cardinality many to many |
| 05:13.17 | bigdog_ut | meaning that for each parent entity (customer) can have zero, one or many orders |
| 05:15.53 | bigdog_ut | so the error message is telling you that you have something messed up with your unique key and possibly a foreign key constraint |
| 05:17.06 | bigdog_ut | so you probably have a many-to-many relationship going on that should not be like that but perhaps a one-to-one or one-to-many |
| 05:17.30 | mindjuju | yeah, was going to say, i think i know what it is |
| 05:18.01 | mindjuju | what's happening in the table that i got an error is that i have a main table generating account IDs and another table that is storing people who want to receive our emails |
| 05:18.24 | mindjuju | where the key for the email list i initially put as the accountID (FK) |
| 05:19.04 | mindjuju | but it got pissed about that, so i generated a primary key for the emailList table and i got this error you see, but it at least allowed me to generate script |
| 05:19.09 | bigdog_ut | you might need to check that out |
| 05:19.27 | mindjuju | yeah, this at least is miles from where I was 30 minutes ago |
| 05:19.33 | mindjuju | thnx, this helps tons! |
| 05:20.34 | bigdog_ut | no problem |
| 05:21.53 | mindjuju | so quick question then, if it were you, and you had an account table with client info, and needed an emaillist of clients who wanted to be contacted, wouldn't you have used the accountID as FK in the email list? |
| 05:25.18 | bigdog_ut | nop |
| 05:25.20 | bigdog_ut | nope |
| 05:25.41 | bigdog_ut | i would have done a fk to a table that was set up for the email list |
| 05:25.58 | bigdog_ut | so if a person was on the list then they would be in mailing_list_table |
| 05:27.11 | bigdog_ut | or atleasted created a table that contained client_id and receive_flg in a table and sent out emails based on receive_flg |
| 05:27.26 | bigdog_ut | with client_id as fk back to the client table |
| 05:28.53 | bigdog_ut | alot of it depends on how your client table is set up |
| 05:33.15 | bigdog_ut | did that help out? |
| 05:33.54 | mindjuju | yeah it did, just moving some stuff around in visio |
| 05:33.59 | mindjuju | you use Erwin, right? |
| 05:34.05 | bigdog_ut | yep |
| 05:34.18 | bigdog_ut | not my favorite though |
| 05:34.21 | mindjuju | i have a demo for Erwin that expired a few days ago, it was nice |
| 05:34.24 | mindjuju | what's your fav? |
| 05:34.40 | bigdog_ut | i use toad alot...the professional version |
| 05:34.46 | bigdog_ut | with all the bells and whistles |
| 05:35.11 | mindjuju | mind if i ask what that ballparks at? |
| 05:36.28 | bigdog_ut | $4915/per person |
| 05:36.44 | bigdog_ut | its official name is Toad for Oracle Suite |
| 05:36.58 | bigdog_ut | i have also used the lesser versions too |
| 05:37.16 | bigdog_ut | like Toad for Oracle Xpert - $2275/perosn |
| 05:37.38 | bigdog_ut | and the professional - $1465/person |
| 05:38.01 | bigdog_ut | yeah it is expensive...but when using oracle...you need a powerful tool |
| 05:38.13 | bigdog_ut | they also have toad for mysql too which is good |
| 05:38.34 | bigdog_ut | that is like $1765/seat |
| 05:39.38 | bigdog_ut | if you have many different dbs that you use i recommend dbvisualizer |
| 05:39.50 | bigdog_ut | java based app that is killer for db development |
| 05:40.28 | mindjuju | i'll give that a try |
| 05:41.31 | bigdog_ut | the main guy that wrote toad also wrote a linux version that is opensource that is called tora which is nice too |
| 05:41.39 | bigdog_ut | not all the features of toad...but good enough |
| 12:22.39 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool149-237.nas31.salt-lake-city1.ut.us.da.qwest.net) |
| 13:28.41 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 13:42.01 | *** join/#uphpu RyanE (n=ryan@rberick.dsl.xmission.com) |
| 14:04.08 | *** join/#uphpu veruus (n=veruus@216.155.116.11) |
| 14:18.06 | *** join/#uphpu wps (n=wps@38.119.178.10) |
| 14:18.06 | *** mode/#uphpu [+o wps] by ChanServ |
| 14:28.05 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 14:32.42 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 15:06.11 | *** join/#uphpu dataw0lf (n=derelikt@70.103.239.58) |
| 16:27.32 | *** join/#uphpu alphahawk (n=alphahaw@71-35-212-54.slkc.qwest.net) |
| 16:31.40 | alphahawk | is there a way to see the http header that has been sent? I wold like to pull the ip address of the person access the page |
| 17:12.42 | mindjuju | alphahawk |
| 17:12.54 | mindjuju | there is, but i don't remember what it is, this is in PHP, right |
| 17:16.58 | mindjuju | searching... |
| 17:18.10 | mindjuju | oh, he left |
| 17:18.31 | wps | does Firefox have full screen mode in the Linux version? |
| 17:18.32 | mindjuju | well, here is the php code for the IP addy |
| 17:18.33 | mindjuju | $domain = GetHostByName($REMOTE_ADDR); |
| 17:21.53 | mindjuju | i think f11 does full screen mode in firefox |
| 18:27.53 | *** join/#uphpu fungus_ (n=fungus@firebat.aros.net) |
| 19:06.52 | *** join/#uphpu cycokilr (n=cycokilr@71-35-217-121.slkc.qwest.net) |
| 19:45.50 | *** join/#uphpu veruus (n=veruus@216.155.116.11) |
| 19:47.24 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool149-237.nas31.salt-lake-city1.ut.us.da.qwest.net) |
| 21:27.34 | *** join/#uphpu stderr (n=derelikt@70.103.239.58) |
| 21:28.05 | mindjuju | so like i was saying, that dataw0lf is sure a punk! |
| 21:28.20 | dataw0lf- | tell me about it, he bit me once. |
| 21:28.29 | dataw0lf- | I wonder if I stab this R |
| 21:28.32 | dataw0lf- | RAID |
| 21:28.35 | dataw0lf- | will it bleed? |
| 21:28.48 | dataw0lf- | let's find out! |
| 21:29.01 | mindjuju | i didn't see you in my list, but did see stderr |
| 21:29.19 | mindjuju | and now i see dataw0lf, but not stderr |
| 21:29.30 | mindjuju | oh, i see, the log now, you changed your name |
| 22:51.31 | mindjuju | i'm getting telepathic signals from somebody that they could really use a wedgie |
| 22:51.38 | mindjuju | ~melvin macnewbold |
| 22:51.41 | jbot | ACTION pulls macnewbold underwear up to the ceiling...and smiles |
| 22:51.52 | macnewbold | I'm awake, I'm awake |
| 22:51.58 | macnewbold | ~lart mindjuju |
| 22:52.08 | mindjuju | ~frenchtaunt macnewbold |
| 22:52.09 | jbot | ACTION summons the french taunter! macnewbold is an English bedwetting type! |
| 22:52.09 | macnewbold | ~frenchtaunt mindjuju |
| 22:52.11 | jbot | ACTION summons the french taunter! mindjuju, I burst my pimples at you... |
| 22:52.20 | macnewbold | ~insult mindjuju |
| 22:52.27 | mindjuju | ~macattack macnewbold |
| 22:52.30 | jbot | ACTION uses a paperclip to hotwire macnewbold's car! |
| 22:52.30 | macnewbold | ~shakespeare mindjuju |
| 22:52.31 | jbot | ACTION stands up and quotes Shakespeare: mindjuju - mindjuju's brain is as dry as the remainder biscuit after a voyage. |
| 22:52.42 | mindjuju | ~toejam macnewbold |
| 22:52.43 | jbot | ACTION wipes all the crud and macnewbold from out between his toes. Yuck! |
| 22:52.49 | macnewbold | ~clue mindjuju |
| 22:52.50 | jbot | ACTION fans out Vegas-style a stack of clues for mindjuju "Pick one, any one! ...and don't show it to me." |
| 22:52.58 | mindjuju | ~zombify macnewbold |
| 22:52.59 | jbot | ACTION summons Bill Gates who materializes in front of macnewbold and using a Windows 3.11 diskette zombifiez macnewbold! macnewbold wonders off in a daze slobering |
| 22:53.00 | macnewbold | ~whaleslap |
| 22:53.01 | jbot | from memory, whaleslap is your mom |
| 22:53.05 | macnewbold | ~fish mindjuju |
| 22:53.07 | jbot | ACTION slaps mindjuju around with a large trout |
| 22:53.12 | macnewbold | ~whaleslap mindjuju |
| 22:53.13 | jbot | ACTION beats mindjuju upside and over the head with a freakishly huge killer whale named Hugh |
| 22:53.18 | mindjuju | ~porkchop macnewbold |
| 22:53.19 | jbot | ACTION spits on a porkchop and feeds it to macnewbold Eat up! |
| 22:53.25 | macnewbold | argh |
| 22:53.33 | mindjuju | yeah, that is kinda gross |
| 22:53.40 | mindjuju | i'll have to make up some new ones |
| 22:54.25 | mindjuju | ~macarena fungus |
| 22:54.26 | jbot | ACTION pulls out 100 megawatt PA speakers and starts to play that wonderful Macarena song on eternal repeat. fungus is hypnotized and starts to dance uncontrollably! |
| 23:20.27 | fungus_ | Hey macarena! |
| 23:38.09 | mindjuju | you a big macarena fan fungus? |
| 23:38.20 | fungus | hell no |
| 23:38.29 | mindjuju | sure, sure... |
| 23:38.33 | mindjuju | you know you love it! |
| 23:39.49 | mindjuju | did you see they increased violation of the DMCA |
| 23:40.40 | fungus | yup. :( |