| 00:01.17 | spr | hey, if you accidently ^s in a terminal, what's the command to start input again? |
| 00:03.17 | Mecworks | ^q |
| 00:04.26 | Maquis | has anybody had the following problem with an sql statement (i had it at work today): |
| 00:04.54 | Maquis | select * from aTable where aCol is null: returns 272 rows |
| 00:05.10 | Maquis | select * from aTable where aCol <> 'C': returns 0 rows |
| 00:05.26 | Maquis | select * from aTable where not aCol = 'C': returns 0 rows |
| 00:06.23 | Maquis | select * from aTable where (aCol <> 'C' or aCol = 'C'): returns 0 rows |
| 00:06.58 | Maquis | (other such statements with similarly unusual results) |
| 00:07.42 | Newsome | I think that null is different than an empty string |
| 00:09.35 | Maquis | those statements have never given me these problems before... |
| 00:09.57 | Maquis | (actually, the last statement didn't return null... it returned about 25 rows with aCol = 'C' |
| 00:09.58 | Maquis | ) |
| 00:10.03 | Newsome | Not sure, then. Different version of sql? |
| 00:10.15 | Maquis | M$ Sql |
| 00:10.24 | Maquis | that's what we use at work |
| 00:10.40 | Newsome | you probably crashed the server by asking for something that is null :) |
| 00:10.54 | Maquis | haha |
| 00:11.19 | Maquis | my boss looked over my statements, couldn't find anythinggn wrong with them, and asked me how in the world i managed to crash the server like that... :) |
| 00:11.20 | Newsome | I'm not too familiar with MSSQL (been about 10 years since I even touched one). |
| 00:11.26 | Maquis | lucky |
| 00:11.38 | Maquis | i'm working on getting away from m$ after this summer. |
| 00:11.41 | Maquis | but money is good |
| 00:14.33 | Newsome | so I've heard |
| 00:15.26 | Maquis | :) |
| 00:15.41 | Newsome | http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_9rec.asp |
| 00:16.18 | Newsome | not sure if it's related |
| 00:18.19 | Newsome | looks like the behavior you're experiencing, though |
| 00:36.11 | Maquis | thanx newsome |
| 00:36.58 | Newsome | hope it helps |
| 00:37.36 | Maquis | that actually looks like it could very well be our problem... :) |
| 02:39.56 | hans | wtf |
| 02:40.05 | hans | why did my home filesystem just remount readonly? |
| 02:47.28 | *** join/#utah hans (fugalh@166.70.37.150) |
| 02:59.10 | *** join/#utah fozzmoo (~fozz@166.70.238.250) |
| 03:14.00 | *** join/#utah jakea (~jakea@128.187.246.108) |
| 03:16.33 | decriptor | does anyone have a good recommendation for a manual or how to on learn mysql |
| 03:18.46 | Maquis | i've just used help while logged in (it's either help or ?) |
| 03:19.13 | Maquis | but i don't know it all that well.. |
| 03:23.22 | decriptor | I'm not sure how a db works and the structure of it |
| 03:23.31 | decriptor | I'm a complete newbie |
| 03:42.24 | *** join/#utah RedHat (~al@c-24-10-194-77.client.comcast.net) |
| 04:00.01 | Maquis | decriptor, do you know any sql? (select statements, etc)? |
| 04:00.16 | Maquis | cuz that's the basis that you need...\ |
| 04:05.07 | *** join/#utah Newsome (~sorenson@byu-gw.customer.csolutions.net) |
| 04:47.12 | *** join/#utah wps (~wade@208.186.134.102) |
| 05:13.02 | decriptor | Maquis I don't |
| 05:13.07 | *** part/#utah wps (~wade@208.186.134.102) |
| 05:14.51 | *** join/#utah bonez39 (~sanchiro@mail.sanchiro.com) |
| 05:19.15 | decriptor | how do you make your name yellow |
| 05:19.19 | decriptor | ? |
| 05:19.39 | Maquis | if i say your name, then it goes yellow on your display |
| 05:20.22 | decriptor | oh |
| 05:22.53 | decriptor | Maquis do you know a lot about sql |
| 05:48.21 | Maquis | decriptor |
| 05:48.25 | Maquis | i know some |
| 05:48.39 | Maquis | it's actually not too hard... |
| 05:48.57 | Maquis | there are some good websites out there... the main things you need to know are select, update and delete statements... |
| 05:49.18 | Maquis | then, after you know those, it's useful to know joins and such... |
| 05:49.24 | Maquis | but the syntax is pretty easy... |
| 05:49.38 | Maquis | "select * from tablename where column = 'foo'" |
| 05:49.55 | Maquis | delete from tablename where column = 'foo' |
| 05:50.19 | Maquis | update tablename set column = 'bar' where acolumn = 'foo' |
| 05:50.28 | Maquis | that's the general syntax... |
| 05:50.43 | Maquis | google around, and you'll find some great resources though! |
| 05:51.12 | Maquis | anyway, i'm moving bedward... most people around here know SQL better than i do though... |
| 05:51.13 | Maquis | :) |
| 05:51.15 | Maquis | gnight |
| 06:03.55 | *** join/#utah Jayce^ (~Jayce^@65.218.37.130) [NETSPLIT VICTIM] |
| 06:03.55 | *** join/#utah hans (fugalh@166.70.37.150) [NETSPLIT VICTIM] |
| 06:03.55 | *** join/#utah bbeattie (~bbeattie@216.143.233.98) [NETSPLIT VICTIM] |
| 06:03.55 | *** join/#utah Mecworks (~marc@208.186.182.174) [NETSPLIT VICTIM] |
| 06:03.55 | *** join/#utah albino (albino@fslc.usu.edu) [NETSPLIT VICTIM] |
| 06:03.55 | *** mode/#utah [+o Jayce^] by irc.freenode.net |