Bay 12 Games Forum

Please login or register.

Login with username, password and session length
Advanced search  

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - ILikePie

Pages: [1] 2 3 ... 127
1
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: March 20, 2012, 01:55:39 pm »
How do I show the results of two queries side by side? I have two separate queries that look like this:
Code: [Select]
SELECT Teacher.[Last Name] & ", " & Teacher.[First Name] AS [Too Old], DateDiff("yyyy", Teacher.[Birth Date], Date()) AS Age
FROM Teacher
WHERE DateDiff("yyyy", Teacher.[Birth Date], Date()) > 70;
and this:
Code: [Select]
SELECT Teacher.[Last Name] & ", " & Teacher.[First Name] AS [Too Young], DateDiff("yyyy", Teacher.[Birth Date], Date()) AS Age
FROM Teacher
WHERE DateDiff("yyyy", Teacher.[Birth Date], Date()) < 20;

And I want them to show side by side (i.e. Too Old, Age, Too Young, Age). A simple union doesn't do the trick.

2
Life Advice / Re: Need a distraction.
« on: March 01, 2012, 03:33:05 am »
Grab your iPod/MP3 player and go to the gym. I find pushing some weights around as a great way to clear the head.

3
Life Advice / Re: Linux if you fail me I swear to the dark gods...
« on: February 13, 2012, 10:32:05 am »
Yes it is. x86_64 is 64 bit, and i386 is 32 bit.

4
Life Advice / Re: Linux if you fail me I swear to the dark gods...
« on: February 13, 2012, 10:00:08 am »
Debian uses extremely outdated software. I'd stick with Ubuntu if I were you. If you'd like to learn more about Linux's deep dark secrets, you can always take a look at some of the more "DIY" distros (Gentoo, Slackware, etc.), though, they can take a while to set up.

Also, 32 bit CPUs can't run 64 bit software, though, if you're computer was purchased in 2007 you can assume it is 64 bit.

For a screenshot app, take a look at scrot.

5
Life Advice / Re: Linux if you fail me I swear to the dark gods...
« on: February 12, 2012, 01:57:43 pm »
To answer your questions:

A) Most hardware has drivers for the Linux kernel, so I guess not much. The lack of MS Office is annoying though.

B) You don't have to compile everything on Linux. Some distributions have binary packages ready for download (Ubuntu, Debian, Archlinux, etc.). If you do want to compile stuff for some odd reason, there are distributions with package managers that automate that for you (specifically, Gentoo). As for the actual compilation, it can take a while, and depending on your computer it really slow things down. My 10-year-old P4 can't be used while it's compiling new software.

Also note that live CDs are generally really slow because the filesystem runs in your RAM.

By the way, what distro do you have on the CD?

6
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 25, 2012, 02:46:52 am »
Quote from: RulerOfNothing on January 25, 2012, 02:38:38 am
I'm pretty sure having an array name followed by [] isn't legal C either.
IIRC it's just like writing "*g_Out", though it's been a while since I used the array notation in C. I'm more of a pointer person.

7
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 25, 2012, 02:34:17 am »
I thought C was compatible with C++.

8
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 25, 2012, 02:14:49 am »
The return line should be:
Code: [Select]
   return g_Out[];

9
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 24, 2012, 12:32:59 pm »
Microsoft decided their wildcards should be * and ? for some reason. Anyway, I got it, it should be:
Code: [Select]
SELECT Student.[Student Name]
FROM Student
WHERE Student.[Student Name] Like '*' & Query & '*';

10
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 24, 2012, 11:47:52 am »
Some more Access, this time, wildcards:
Code: [Select]
SELECT Student.[Student Name]
FROM Student
WHERE Query LIKE '*[Student].[Student Name]*';
I'd like this to work as sort of a search function, where the user enters a part of a name, and the query displays all names matching it. Access seems to be parsing "*[Student].[Student Name]*" literally, and not as Student.[Student Name] with two wildcards around it. I've tried single quotes and no quotes too, but they don't work either.

11
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 23, 2012, 02:40:40 pm »
The left join did it, thanks.
Code: [Select]
SELECT City.[City], Count(Student.ID) AS [Count]
FROM City
LEFT JOIN Student ON City.ID = Student.[Home Town ID]
GROUP BY City.[City];

12
Creative Projects / Re: Programming Help Thread (For Dummies)
« on: January 23, 2012, 12:19:42 pm »
Not sure if SQL should go here, but whatever.
Code: [Select]
SELECT City.[City], Count(Student.ID) AS [Count]
FROM City, Student
WHERE (((City.ID)=[Student].[Home Town ID]))
GROUP BY City.[City];
This query counts the amount of students in a table called "Student" which live in a certain city (Home Town ID). The result is a table with one column for the cities and another for the amount of students, but cities without students don't show up. How do I show cities with 0  students in them?

In short, I get this:
Code: [Select]
City          | Count
----------------------
Jacksonville  | 2
Washington    | 3
But I want this:
Code: [Select]
City          | Count
----------------------
Jacksonville  | 2
Washington    | 3
New York      | 0
San Francisco | 0
 e, This is MS Access by the way.

13
General Discussion / Re: if self.isCoder(): post() #Programming Thread
« on: January 13, 2012, 02:05:03 pm »
Quote from: Max White on January 13, 2012, 05:04:12 am
I'm fucking slamming code... If only every language has a half decent IDE.
Emacs is the answer to all your problems.

Does anyone know of an algorithm to generate side scrolling cave like shapes? My map generator is missing caves.

14
General Discussion / Re: if self.isCoder(): post() #Programming Thread
« on: January 06, 2012, 10:49:36 am »
The GBA has a C compiler? That's cool.

15
General Discussion / Re: American Election Megathread
« on: January 05, 2012, 04:36:00 pm »
Quote from: Nadaka on January 05, 2012, 04:07:01 pm
Gingrich only really supports Israel because he is an evangelical christian and the state of Israel with Jerusalem as its capital is a prerequisite for the apocalypse that he prays for.
Well support is support, and besides, Bush is an evangelical christian and we (Israel) loved him as a president.

e, Honestly I don't care if it's him, Romney or any other pro-Israel republican. Romney sounds less radical, which is a Good Thing.

Pages: [1] 2 3 ... 127