code logs -> 2006 -> Sun, 19 Nov 2006< code.20061118.log - code.20061120.log >
--- 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
code logs -> 2006 -> Sun, 19 Nov 2006< code.20061118.log - code.20061120.log >