--- Log opened Sun Nov 19 00:00:12 2006 |
00:08 | | MyCatGames [~mycatownz@Nightstar-379.dsl.in-addr.zen.co.uk] has quit [Quit: Rebooting for to videogame.] |
00:25 | | ReivZzz is now known as Reiver |
01:31 | | Martivir is now known as EvilDarkLord |
01:31 | | Saurivir is now known as AnnoDomini |
01:57 | | AnnoDomini [~fark.off@Nightstar-29288.neoplus.adsl.tpnet.pl] has quit [Quit: Some people find sanity a little confining.] |
03:04 | | You're now known as TheWatcher[zZzZ] |
03:06 | | Janus is now known as Jan[bathipoo] |
03:30 | | Thaqui [~Thaqui@124.197.36.ns-12825] has joined #code |
04:04 | | Jan[bathipoo] is now known as Janus |
04:43 | | Vornotron [~vorn@Nightstar-18307.slkc.qwest.net] has joined #code |
04:44 | < Vornotron> | Does anyone here know how to mount an LVM volume? |
04:47 | <@Reiver> | Dinner and drinks beforehand? |
04:59 | | * Janus meanders about with the head of Dev-Cpp on a pike. |
04:59 | < Vornotron> | ah, here we are. |
05:07 | <@ToxicFrog> | It should just be /dev/<vgname>/<lvname> |
05:07 | <@ToxicFrog> | And you mount it like any other block device. |
05:14 | < Vornotron> | mmm, knoppix did not do that for me |
05:15 | <@ToxicFrog> | You may need to actually enable it using the lvmtools first, if Knoppix doesn't do so automatically on booty. |
05:15 | <@ToxicFrog> | *boot. |
05:15 | <@ToxicFrog> | Or if it attempts to, but can't find the VGs. |
05:16 | <@ToxicFrog> | Why am I awake? |
05:16 | | * ToxicFrog slwwp |
06:00 | | Janus [~Cerulean@Nightstar-10302.columbus.res.rr.com] has quit [Quit: Le Seigneur a trahi Son monde, création travaillée, née, le chagrin, pour elle... jeune fille gentille.] |
06:16 | < Vornotron> | ...this wouldn't be so bad if it weren't taking 20 minutes to boot an OS every time |
06:57 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has joined #code |
06:57 | | mode/#code [+o Chalcedon] by ChanServ |
07:10 | | Vornotron [~vorn@Nightstar-18307.slkc.qwest.net] has quit [Quit: ] |
07:39 | | * Vornicus returns to his apartment. |
08:12 | | Vornicus is now known as Vornicus-Latens |
10:00 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has quit [Ping Timeout] |
10:12 | | AnnoDomini [~fark.off@Nightstar-29288.neoplus.adsl.tpnet.pl] has joined #Code |
10:55 | | * jerith ponders. |
10:55 | <@jerith> | Monkeyness! |
10:56 | <@jerith> | Any Solaris gurus in here? |
12:00 | | Thaqui [~Thaqui@124.197.36.ns-12825] has quit [Quit: Leaving] |
12:04 | | EvilDarkLord is now known as EvilBirthdayLord |
12:19 | | * GeoTube wonders where the guru of lameis |
12:20 | | You're now known as TheWatcher |
12:46 | | AnnoDomini [~fark.off@Nightstar-29288.neoplus.adsl.tpnet.pl] has quit [Ping Timeout] |
12:53 | | AnnoDomini [~fark.off@Nightstar-29052.neoplus.adsl.tpnet.pl] has joined #Code |
13:32 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Ping Timeout] |
14:22 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code |
14:22 | | mode/#code [+o ToxicFrog] by ChanServ |
14:31 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Connection reset by peer] |
14:32 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code |
14:32 | | mode/#code [+o ToxicFrog] by ChanServ |
15:26 | | Reiver is now known as ReivZzz |
16:48 | | EvilBirthdayLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has quit [Ping Timeout] |
16:59 | | EvilBirthdayLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has joined #code |
17:03 | | aoanla [~sam@Nightstar-25591.range81-156.btcentralplus.com] has joined #code |
17:10 | | You're now known as TheWatcher[afk] |
17:29 | | Takyoji [~Takyoji@Nightstar-25280.dhcp.roch.mn.charter.com] has joined #code |
17:29 | < Takyoji> | What is the purpose of constants? |
17:30 | < Takyoji> | I know they don't change, but whats the actual reason for using constants? |
17:30 | < Takyoji> | Of which variables can't do |
17:31 | < Takyoji> | Are they accessible from inside a function or what? |
17:31 | <@Vornicus-Latens> | Constants are useful when you have a "magic number" that you need to use all over the plac |
17:31 | <@Vornicus-Latens> | or even in one place. |
17:33 | < Takyoji> | Also, how would I be able to get data from a Microsoft Excel spreadsheet onto MySQL? |
17:34 | < Takyoji> | would I have to convert it to CSV or XML or something? |
17:34 | <@Vornicus-Latens> | Save the Excel sheet as a CSV; most SQL systems have a method of reading CSVs |
17:34 | < Takyoji> | oh alright |
17:34 | < aoanla> | Definitely not XML, which is verbose and horrible. |
17:34 | < Takyoji> | I forgot about that |
17:34 | < aoanla> | (Says the person working in a field where everything uses XML...) |
17:34 | <@Vornicus-Latens> | XML isn't that bad |
17:34 | < aoanla> | It's very... low density. |
17:34 | <@Vornicus-Latens> | but it's useless for talking to relational databases |
17:36 | < Takyoji> | otherwise, constants can be declare, then be accessed from anywhere in a script, even inside a function correct? |
17:36 | < Takyoji> | declared* |
17:36 | < aoanla> | Depends on if they're global or not / the programming language you're using. |
17:36 | < Takyoji> | php |
17:36 | < Takyoji> | I believe they are global |
17:37 | < aoanla> | Yes, I think they are, in PHP. |
17:37 | < Takyoji> | k |
17:39 | <@Vornicus-Latens> | Constants are used for a lot of things |
17:39 | < Takyoji> | true |
17:40 | <@Vornicus-Latens> | Generally they're used whenever you throw around a number that isn't small and obvious like 1 or 2 |
17:40 | < Takyoji> | ah |
17:40 | <@ToxicFrog> | And - as a general rule, though PHP may do things differently - any global variable can be accessed from inside functions, not just constants. |
17:40 | <@ToxicFrog> | Otherwise what's the point? |
17:43 | < Takyoji> | Because, for example.. I'm working on an online store, and within the parameters for the functions I have a variable for the color scheme. So in example, to make a table the command would have to be written out like table("mysql_query","#002200","#3300FF",and so on) |
17:43 | <@Vornicus-Latens> | So I'd have PI = 3.1415926... and G = 6.673...E-11, and ETHERNET_FRAME_SIZE = 1500, and GREEN = 0x00FF00 |
17:46 | <@Vornicus-Latens> | though G would probably be in a "units" type, and GREEN would probably be an actual Color |
17:47 | <@ToxicFrog> | Assuming the language you're working in has such things. |
17:47 | <@Vornicus-Latens> | indeed |
17:47 | | * ToxicFrog has a sudden postscript-related thought |
17:48 | <@ToxicFrog> | Hmm. |
17:48 | | aoanla is now known as caps|phone |
18:03 | < Takyoji> | crap.. ms excel isn't creating the csv documents properly |
18:05 | < Takyoji> | or... I have x as y, when y should be x |
18:08 | < Takyoji> | grr.. how am I going to rotate it |
18:23 | | Janus [~Cerulean@Nightstar-10302.columbus.res.rr.com] has joined #Code |
18:30 | | Vornicus [~vorn@Nightstar-18307.slkc.qwest.net] has joined #code |
18:30 | | mode/#code [+o Vornicus] by ChanServ |
18:33 | | You're now known as TheWatcher |
18:41 | <@ToxicFrog> | Takyoji: with awk? |
18:41 | < Takyoji> | hmm? |
18:42 | < Takyoji> | I'm still trying to transfer data over to mysql |
18:42 | < Takyoji> | and I think I have it the wrong way |
18:42 | <@ToxicFrog> | Yes, you mentioned. |
18:42 | < Takyoji> | Where the columns should actually be rows |
18:42 | < Takyoji> | I believe |
18:42 | <@ToxicFrog> | There's no fast operation in excel to fix this? |
18:42 | < Takyoji> | since it isn't inserting in MySQL properly |
18:42 | <@Vornicus> | what's youre data look like? |
18:43 | <@Vornicus> | There /is/ a fast operation in Excel to fix data direction - copy, edit->paste special, turn on "transpose" |
18:44 | < Takyoji> | Oh thanks |
18:47 | < Takyoji> | no, I suppose it made it worse.. |
18:47 | <@Vornicus> | ? |
18:47 | <@Vornicus> | what's your data look like? |
18:47 | < Takyoji> | I suppose I had the original way correct |
18:47 | < Takyoji> | it also isn't delimiting properly |
18:48 | <@Vornicus> | show us |
18:48 | < Takyoji> | holdon |
18:49 | < Takyoji> | in the name column of row 1 it says "name,Keite Davis,Linda Hanson,Rob Rainey,Jim Dietz,Stan Gilman,Mitchell Rhodes,Kelly Ellis,Tom Ohnstad,Lisa Froseth,Steve VanNatta?,Loren Malling,Mike & Jane Swanson,Dave & Kathy Jensen,Tom & Karen Miller,Scott Schaible,Shelli & Brent Nelson" |
18:50 | < Takyoji> | holdon, I'll just get a pic |
18:51 | <@ToxicFrog> | ...why not just pastebin the csv? |
18:52 | < Takyoji> | http://aquaeden.com/screenshot.jpg |
18:52 | <@ToxicFrog> | ... |
18:52 | < Takyoji> | whats the link for the paste website? |
18:52 | | * ToxicFrog points at the topic |
18:53 | <@Vornicus> | Okay, you need to open your data in Excel, paste special->transpose it, and then you'll have it in the right order |
18:57 | < Takyoji> | then its screwed up the other way |
18:57 | <@Vornicus> | "the other way"? |
18:58 | < Takyoji> | one second |
18:58 | <@Vornicus> | ...show us the thing you're using to import the CSV data |
18:59 | < Takyoji> | you mean my csv file? |
18:59 | <@Vornicus> | no |
18:59 | < Takyoji> | erm.. for importing it I'm using phpmyadmin |
18:59 | <@Vornicus> | aha |
18:59 | < Takyoji> | and this is what I mean by 'the other way': http://aquaeden.com/screenshot.jpg |
19:00 | < Takyoji> | And I have to use the "CSV using LOAD DATA" option because the "CSV" version doesn't work |
19:01 | < Takyoji> | because it gives me an error |
19:01 | <@Vornicus> | what error? |
19:02 | < Takyoji> | Invalid field count in CSV input on line 1. |
19:02 | < Takyoji> | line 1 is "name,city,email,existing_pond,pond_tour,equipment_newsletter,plants_newsletter, notes" |
19:02 | <@Vornicus> | Show me your table schema, and a full line of data in the pastebin |
19:03 | < Takyoji> | what is the link for pastebin? |
19:03 | <@Vornicus> | it's in the topic |
19:03 | < Takyoji> | oh god I'm blind |
19:06 | < Takyoji> | http://pastie.caboo.se/23535 |
19:06 | | AnnoDomini is now known as Kiers |
19:06 | < Takyoji> | its only delimiting by commas |
19:06 | < Takyoji> | and I think myswl wants commas and semicolons |
19:06 | < Takyoji> | mysql* |
19:07 | <@Vornicus> | Show me a the create table statement for the table you're dumping it into. |
19:09 | < Takyoji> | I'm using phpMyAdmin, and its not telling me the query since its errorous |
19:09 | <@Vornicus> | NOt the select statement |
19:09 | <@Vornicus> | the create statement |
19:09 | <@Vornicus> | or, equivalently, what phpMyAdmin says the names of the columns are |
19:09 | < Takyoji> | oh the table? |
19:09 | <@Vornicus> | yes |
19:10 | < Takyoji> | http://pastie.caboo.se/23536 |
19:12 | <@Vornicus> | ...hm |
19:12 | < Takyoji> | I still believe its a problem with the CSV |
19:14 | <@Vornicus> | It appears to want you to fill in the index column as well for some reason |
19:15 | < Takyoji> | its just auto-incremental.. |
19:15 | <@Vornicus> | I know |
20:15 | | MyCatOwnz [~mycatownz@Nightstar-379.dsl.in-addr.zen.co.uk] has joined #code |
20:25 | | Takyoji [~Takyoji@Nightstar-25280.dhcp.roch.mn.charter.com] has quit [Connection reset by peer] |
20:44 | | caps|phone is now known as aoanla |
20:48 | | MyCatOwnz is now known as MyCatEats |
21:00 | | EvilBirthdayLord is now known as Thokk |
21:16 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has joined #code |
21:16 | | mode/#code [+o Chalcedon] by ChanServ |
21:37 | | Vornicus [~vorn@Nightstar-18307.slkc.qwest.net] has quit [Quit: ] |
21:41 | | MyCatEats is now known as MyCatOwnz |
21:44 | | aoanla [~sam@Nightstar-25591.range81-156.btcentralplus.com] has quit [Quit: Leaving] |
21:57 | | Chalcedon is now known as ChalcyAFK |
22:02 | | Thokk is now known as EvilDarkLord |
22:02 | | Kiers is now known as AnnoDomini |
22:08 | | Vornicus-Latens is now known as Vornicus |
22:18 | | Thaqui [~Thaqui@124.197.36.ns-12825] has joined #code |
22:56 | | AnnoDomini [~fark.off@Nightstar-29052.neoplus.adsl.tpnet.pl] has quit [Quit: Some people find sanity a little confining.] |
23:19 | | EvilDarkLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has quit [Operation timed out] |
23:22 | | EvilDarkLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has joined #code |
23:27 | | You're now known as TheWatcher[T-2] |
23:29 | | You're now known as TheWatcher[zZzZ] |
23:45 | < Janus> | ... I think I broke it. |
23:46 | < GeoTube> | No, that was TheWatcher falling asleep on it. |
23:46 | < GeoTube> | and when did you appear? |
23:46 | < GeoTube> | ahh, 5 hours ago.. |
23:47 | < Janus> | --? |
23:49 | < Janus> | Anywho, I was attempting to switch to Eclipse from Dev-Cpp... but couldn't figure out how to get it out of Java mode... then I made a leap to Visual C++, which complains about some "No : before {" in the cstdin header. |
23:50 | < MyCatOwnz> | ...three IDEs all running simultaneously on one machine. |
23:50 | < Janus> | Now, I have /no/ IDE at all... |
23:50 | < Janus> | They weren't running at the same time... though I doubt they enjoy eachother's company. |
23:51 | < MyCatOwnz> | What the Hell you runnin' there, Janus? An eight-way Opteron box with thirty two gigs of RAM? |
23:51 | <@ToxicFrog> | Umm. |
23:51 | <@ToxicFrog> | Does Eclipse /have/ a non-Java mode? |
23:51 | < MyCatOwnz> | ToxicFrog: yes. It's called CDT. |
23:51 | < Janus> | It sounds like such an afterthought though... |
23:52 | < MyCatOwnz> | From what I've heard and seen (from IBM's own people, no less), it's pretty painful. |
23:52 | <@McMartin> | Well, it is an afterthought. |
23:52 | <@ToxicFrog> | And visual C++, AFAIK, will only use the MS build tools. |
23:52 | <@McMartin> | I believe that's not actually true, but you need some wizardry to get around it. |
23:53 | <@McMartin> | Most of Eclipse's power hinges on the ability to do on-the-fly parsing of the target language, etc., which is Work (tm) and which was already done for Java, so. |
23:53 | <@McMartin> | But there are plugins for, like, Yacc equivalents and stuff. |
23:54 | < Janus> | Visual C++ seemed like such a nice, pretty IDE with plenty of nifty toys. It allows, supposed, one to use Ming32, but I'll be darned if I know the command line whatevers to make it happen. |
23:54 | <@ToxicFrog> | Now that would be cool. An editor that allows you feed it syntactical as well as lexical definitions. |
23:55 | <@McMartin> | TF: That's what Eclipse has, though it's more of a "DOM based on the Source Code", as I understand it |
23:55 | <@McMartin> | That's how it can do all the refactoring thingies. |
23:55 | <@ToxicFrog> | Yes, but can you add to it without, eg, rebuilding the entire editor? |
23:55 | <@McMartin> | Janus: Earlier versions of MSDev let you set the beginning of the compile command to anything you wanted. |
23:55 | <@ToxicFrog> | Or does it only work with its builtin ones? |
23:55 | <@McMartin> | Plugins ftw, sir. |
23:56 | <@McMartin> | It's Java, remember? Linking a dynamic library in is a matter of saying "This class is named foo.bar.baz, and it implements your Plugin Interface" |
23:56 | <@ToxicFrog> | Aah, point. |
23:56 | <@McMartin> | And even that latter part is optional. |
23:56 | <@ToxicFrog> | This is still <<<<<< writing the regexes and CFG and going "here is your language spec, go forth and colorize" |
23:57 | <@McMartin> | The regexes part should be eminently doable in just about anything, I'd think. |
23:57 | <@McMartin> | Or at least, "here is your regexes, write me a plugin" |
23:58 | <@ToxicFrog> | Mainly, I am thinking of like NEdit, where you can add new languages by describing the lexis with regexes, only with support for CFG-defined syntax as well as regex-defined lexis. |
23:58 | <@McMartin> | Yeah. The regexes part is fairly easy, I'd think. |
23:58 | <@McMartin> | And you could probably do classloader jackassery in Eclipse to do the same thing. |
23:58 | | * ToxicFrog nods |
23:59 | <@ToxicFrog> | Although I've pretty much abandoned my efforts to do the regex thing in SciTE. |
23:59 | <@McMartin> | But it would be classloader jackassery, and when all is said and done, it would be nicer to actually just have a "Here's your Jarfile for a plugin for editing Spellcast logs" or whatever. |
23:59 | <@McMartin> | How that file is made is just an implementation detail |
23:59 | | * Janus opens wikipedia. |
--- Log closed Mon Nov 20 00:00:01 2006 |