simpy
simpy
Pulling your hair out because of errors like so: "ERROR 1248 (42000): Every derived table must have its own alias" ?
If you have several complicated unioned queries that you want to use in a sub query try encapsulating them like so:
SELECT col1,col2,col3 FROM
(
SELECT * FROM
(
SELECT col1,col2,col3 FROM myTable WHERE ... etc.
) AS DerivedTable1
UNION
SELECT * FROM
(
SELECT col1,col2,col3 FROM myTable WHERE ... etc.
) AS DerivedTable2
) AS MainTable GROUP BY... HAVING... ORDER BY... LIMIT... etc.
This method of aliasing will add years to your life by providing the unique distinction required of derived tables in sub queries without having to spend a bunch of time trying to alias every table and field while continuing to get "derived table" errors. Thanks goes to David Fells for helping me keep some of my hair over this one!
Have fun.
ITC.TN-RobertLaughlin-2008.10.29.mp3 4313 Stephanie Hannon - Why Should Y.mp3 4311 David Ewing Duncan - Evolution.mp3 4302 Larry Downes - The Laws of Disr.mp3 4288 Richard Whitt - Tinkering witho.mp3 4310 Ken Auletta - Googled_The End o.mp3
* http://twit.tv/floss97 about http://exist.sourceforge.net/
* example: http://history.state.gov/
* http://itc.conversationsnetwork.org/shows/detail4301.html
* http://www.amazon.com/Building-Social-Web-Applications-Establishing/dp/0596518757/
* interview with Jon Udell
* at ~22:30 - Jon: ~"an application" can be accomplished by a convention
* noticings (Flickr game) - Activity Stream - Oauth - OpenID
* http://itc.conversationsnetwork.org/shows/detail4289.html
* panel discussion of spectrum: cognitive radio, FCC, policy, lots of complicated stuff
from In the Beginning was the Command Line available at:...possible to glean certain patterns, and one that recurred as regularly as an urban legend was the one about how someone would move into a commune populated by sandal-wearing, peace-sign flashing flower children, and eventually discover that, underneath this facade, the guys who ran it were actually control freaks; and that, as living in a commune, where much lip service was paid to ideals of peace, love and harmony, had deprived them of normal, socially approved outlets for their control-freakdom, it tended to come out in other, invariably more sinister, ways.
Applying this to the case of Apple Computer will be left as an exercise for the reader, and not a very difficult exercise.
http://artlung.com/smorgasborg/C_R_Y_P_T_O_N_O_M_I_C_O_N.shtml and http://www.cryptonomicon.com/beginning.html
