If you are mugged, you can't go to the nearest payphone (or use your cellphone if you have one) to call 911 immediately (or the non-emergency number)? Right after that I would call the credit card company and cancel the card. Hopefully it'll be hard to use your credit card number that fast.
I'm sure that $100 bills have the same markings, but refusing to accept them is perfectly acceptable. What "this note is LEGAL TENDER for all debts public and private" (emphasis mine) means is that the money is "real" since it's not backed by any gold bullion but rather is fiat money and is money because the gubment says so.
Actually video poker has the best odds to win if you want to learn perfect strategy and find a machine with a good payout (you can find ones with higher than 100% payback) If you just want a simple game, then craps is a good idea for good odds. Personally my favourite game is Pai gow poker since it's relatively "slow" to lose or win money.
Perhaps this isn't obvious, but wouldn't something like this "get around the patent"?
Record live audio into a stream of some sort. As each song finishes (live), push a button and make a marker into a cue file. *After* the songs are finished playing, simply convert the stream into a sound format and cut the song into tracks (possibly editing the times. Note that this is not accessible as it is being formed, so it invalidates (i).
Except, with Mozilla you cannot click the "Open" button when an EXE is downloaded. You have save it to disk, then open the download manager and double click on the file.
It's c# as in chess notation, i.e. C-pawn forward, checkmate. So it's pronounced checkmate. Just what microsoft wants to do to all the other languages that try to compete with it.
Actually, your query is wrong for what I said. It should be:
select user, task, priority, requestdate
from foo join bar on foo.tasktype = bar.tasktype
group by user
order by priority desc, requestdate asc
I wanted every user, and just the single task with the lowest priority. Sorry. I didn't realize you could do group bys and select non-aggregated data. MSSQL forbids this. You aren't allowed to select task, priority or requestdate in that query, only aggregate data like max(task), but not task with min(priority). In essence this is the subquery:
select cage, parrot, aliveness
from petstore p
where parrot in (select max(p2.aliveness) from petstore p2 where p.cage = p2.cage)
I guess my point is shown wrong. It's not really my homework though -- the query I have works well enough and I'm not looking to replace it, and this is a discussion about the deficiencies of sql systems. My being unable to come up with a single SQL query shows a deficiency somewhere. Admittedly, it's because I've been using MSSQL lately and not knowing MySQL as well as I should, but subqueries do make things easier if you think that way. Maybe it's a deficiency in MSSQL that's forced me to. I think I remember myself trying to do something similar to this using group by in the manner you did but couldn't get MSSQL to do what I want that way and having to use subqueries. However, subqueries also tend to slow things down a lot because joins can be optimized a lot better. I've spend a bit of time fixing my coworker's queries because he used subqueries and some of his reports got really slow (minutes when the joins were sub-second). However, for simple one-time tasks, subqueries can be useful because the implications of joins don't have to be thought of.
select username, email
from users
where username in (select username from userstospam where lastspammed < '4/1/2004')
versus
select username, email
from users join userstospam on userstospam.username = users.username
where userstospam.lastspammed < '4/1/2004'
Do I need to make sure that some fields are not null? which fields should be null or not null? These questions usually not as easy to answer as just typing the first query out, especially when you get 3-4 joins deep.
Ultimately, I've never seen a query that used a sub-query that didn't actually need to be optimized through judicious uses of de-normalization
Can you help me solve this problem that I easily solved with a subquery?
Given a table consisting of user, tasktype, priority; a table of tasks, tasktypes, and requestdate; return a list of users and the associated task with the lowest (highest) priority and earliest date. Currently I'm implementing this by doing a join on the two tables and filtering out the duplicates in php. The task list has an upper bound of around 10-15 rows, so this isn't that great of a problem but it hopefully illustrates my point. If you have a better way to do this, then please explain. I'm not trying to bash mysql. I use it, but it certainly isn't quite as sophisticated as Postgres or other databases that support more features than it.
Even if they are sandboxed properly, they can still have some bad privacy concerns. Imagine something like the ad nuker extension replacing the ad images with another ad instead of a blank image placeholder. Or maybe even keeping track of open windows (history) and sending them off to wherever. Or janking off passwords you type in (the password manager can get at them, so XUL should be able to). Combined with creating popups of its own, they could still be almost as bad as Spyware that infects IE.
That is false. He doesn't cease making $100 if he has to pick up the $100. He will have gained $200 in the 1.24 seconds if he picks it up, hence he will still have made the $100 off the ground, and hence worth picking up.
In another post, they said it was photolythic and would only survive a few days in UV light. Maybe just shine everything with flourescent tubes for a while?
*almost* ok for games? Clearly you haven't used a Hitachi CML175B. The best purchase I've ever made for my computer, and I'm a gamer. The picture is crisp, and there is less strain on my eyes than with a CRT. More expensive than a CRT, but well worth it.
Anyone else get reminded of the Pizza Matrix after seeing this? Maybe I'm seeing too many of those mushrooms, but they do sound like good pizza toppings, for pizza pizza pies.
As far as I know, ROM's are given that name because they are ROM dumps. Cartriges are ROM, and the contents of them are dumped into a file for use by the emulator (or for ahem, backup). Just like people say ATM Machines, people will shorten the ROM dump files to ROM's.
Slashdot Mirror
If you are mugged, you can't go to the nearest payphone (or use your cellphone if you have one) to call 911 immediately (or the non-emergency number)? Right after that I would call the credit card company and cancel the card. Hopefully it'll be hard to use your credit card number that fast.
"We do not accept bills larger than $20"
I'm sure that $100 bills have the same markings, but refusing to accept them is perfectly acceptable. What "this note is LEGAL TENDER for all debts public and private" (emphasis mine) means is that the money is "real" since it's not backed by any gold bullion but rather is fiat money and is money because the gubment says so.
Fry-Guy's still exist :)
badger badger badger badger badger badger badger badger MUSHROOM MUSHROOM!...
Actually video poker has the best odds to win if you want to learn perfect strategy and find a machine with a good payout (you can find ones with higher than 100% payback) If you just want a simple game, then craps is a good idea for good odds. Personally my favourite game is Pai gow poker since it's relatively "slow" to lose or win money.
Perhaps this isn't obvious, but wouldn't something like this "get around the patent"?
Record live audio into a stream of some sort. As each song finishes (live), push a button and make a marker into a cue file. *After* the songs are finished playing, simply convert the stream into a sound format and cut the song into tracks (possibly editing the times. Note that this is not accessible as it is being formed, so it invalidates (i).
In my town, I periodically get advertisements to have my street number painted on the sidewalk curb for the same purpose.
Except, with Mozilla you cannot click the "Open" button when an EXE is downloaded. You have save it to disk, then open the download manager and double click on the file.
Stargate is being cancelled. There is only one season left, to be replaced by Stargate: Atlantis (premiering in July AFAIK).
I prefer zipgenius. It supports 7zip archives too.
It was a joke.. in flavour of the parent. Lighten up.
No no no you've got it all wrong!
It's c# as in chess notation, i.e. C-pawn forward, checkmate. So it's pronounced checkmate. Just what microsoft wants to do to all the other languages that try to compete with it.
uncheck the raise windows on events and install the tray icon plugin then. I still like Trillian's UI better though.
Ultimately, I've never seen a query that used a sub-query that didn't actually need to be optimized through judicious uses of de-normalization
Can you help me solve this problem that I easily solved with a subquery?
Given a table consisting of user, tasktype, priority; a table of tasks, tasktypes, and requestdate; return a list of users and the associated task with the lowest (highest) priority and earliest date. Currently I'm implementing this by doing a join on the two tables and filtering out the duplicates in php. The task list has an upper bound of around 10-15 rows, so this isn't that great of a problem but it hopefully illustrates my point. If you have a better way to do this, then please explain. I'm not trying to bash mysql. I use it, but it certainly isn't quite as sophisticated as Postgres or other databases that support more features than it.
Even if they are sandboxed properly, they can still have some bad privacy concerns. Imagine something like the ad nuker extension replacing the ad images with another ad instead of a blank image placeholder. Or maybe even keeping track of open windows (history) and sending them off to wherever. Or janking off passwords you type in (the password manager can get at them, so XUL should be able to). Combined with creating popups of its own, they could still be almost as bad as Spyware that infects IE.
Except (from one of the threads I read), all the program does is install an exe that hijacks internet explorer. How ironic.
http://www.musicsonglyrics.com/T/Thursday/Thursday %20-%20Division%20St%20lyrics.htm
8 86 9&highlight=xpi
http://forums.mozillazine.org/viewtopic.php?t=6
for more detail + links to other posts.
Firefly already exists.
That is false. He doesn't cease making $100 if he has to pick up the $100. He will have gained $200 in the 1.24 seconds if he picks it up, hence he will still have made the $100 off the ground, and hence worth picking up.
In another post, they said it was photolythic and would only survive a few days in UV light. Maybe just shine everything with flourescent tubes for a while?
*almost* ok for games? Clearly you haven't used a Hitachi CML175B. The best purchase I've ever made for my computer, and I'm a gamer. The picture is crisp, and there is less strain on my eyes than with a CRT. More expensive than a CRT, but well worth it.
Anyone else get reminded of the Pizza Matrix after seeing this? Maybe I'm seeing too many of those mushrooms, but they do sound like good pizza toppings, for pizza pizza pies.
As far as I know, ROM's are given that name because they are ROM dumps. Cartriges are ROM, and the contents of them are dumped into a file for use by the emulator (or for ahem, backup). Just like people say ATM Machines, people will shorten the ROM dump files to ROM's.
http://www.robolympics.net/videos.shtml
Yes.