$query = "SELECT *, if(CAST(pw_1 as DECIMAL) > 85320, 'TRUE', 'FALSE') as PAYDAY FROM lca2015 WHERE left(LCA_CASE_8,7) = '15-1121'";
$85,320 is what an American Computer Systems Analyst supposedly gets paid according to the dept of labor. I am preparing a map that has a blue marker for anybody making more than that, and a red marker for anybody paying less. I originally thought I had it working without the cast() routine Pw_1 is the amount they get paid But last night I noticed in midland texas a marker that should have been blue that was red, which is what led me to this email. Not really sure how to tell why this appears to work in most cases, but not in a few (at this point I don't know how many are correct and how many aren't) http://keepamericaatwork.com/2015_xml_15_1121.php The link above will pull up the xml http://keepamericaatwork.com/2015_map_15_1121.html The link above will pull up the map and most appear to be correct. I'm moving out of my shed this weekend so it's probably something simple, but right this second it has me puzzled. Thanks, Virgil Bierschwale America has only created 400,000 jobs >From 1999 - 2014 https://www.youtube.com/watch?v=DvUiDax2Ka4 How about we do more to Keep America At Work By Hiring Americans in America? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
