=== excid3|mbp is now known as Amazeballs [03:35] hello. === Amazeballs is now known as excid3|mbp [13:55] morning [14:20] morning [15:22] morninig [15:27] mornin [16:53] Good Afternoon Everyone [16:53] hah, I just got into work. funny time zones! [16:54] mhall119, man that script thing for MYSQL Kicks A$$! [16:55] crashsystems, really? cool...I just woke up from my power nap at the office [16:55] I love me them power naps, nothing better to refresh you [16:57] Its only 8:56 here in California, which unfortunately is a bit too early for power naps. [16:58] never too early for a power nap [16:58] :D [17:23] crashsystems1: How's the Loco there in the Bay area? [17:23] It seems nice, though I've not been involved with it much. [17:50] crashsystems, bah, you don't need any other Loco your good with us right? [18:01] hey guys [18:01] is there any way to go to your bookmarks from chrome w/o opening a new tab? [18:21] DammitJim: well there is the "other bookmarks" button, not sure if that's default or something I installed though [18:21] is that an extension? [18:21] doesn't look like it is [18:22] but perhaps you have to have a book mark bar up in order to see it. Trying to figure out where it came from now [18:22] there's also Bookmark Manager in the configuration menu [18:23] I'm running Natty Alpha, btu I don't think these are that new. I've just realized that I seldom use bookmarks any more [18:25] oh perhaps you're talking chrome OS [18:25] * rmcbride kicks self for not requesting one of those netbook thingies [18:33] DammitJim, I think you have to show your bookmarks bar and other bookmarks and that should show you what you want [18:34] I'm sorry... it's ChromeOS [18:34] lol [18:34] In my Chrome I have two places where I can bookmark, the Bookmarks bar and the Other Bookmarks [18:34] no, just chrome [18:34] not oS [18:34] where is other bookmarks? [18:34] OS, not the web browser? [18:34] the web browser, not os [18:35] right if you enable both it should give you what you are looking for [18:35] it works for me [18:37] can enable the bar under Tools in the config menu [21:13] hey how can I do a select statement in MySQL although the table I'm using will be empty? [21:20] reya276: You can still run a select against it, you just won't get any data. [21:20] Are you wanting to join to an empty table, but still get results? [21:20] reya276: ^^^ [21:22] no the issue is that although the query is coming back empty the piece of code within a certain report will not work unless something is populated, I have create a variable, parameters but none of it seems to work, so at this moment my only option is [21:23] to make sure the DB sets the default for the column [21:23] can you fix the report? seems that's there the actual bug lies [21:23] I agree. The code asking for the data should be able to handle an empty dataset coming back. [21:23] MySQL isn't going to return data that isn't there [21:23] ah ok I can set the default in the table schema [21:23] right [21:24] reya276: Out of curiosity, what are you using to generate the report? [21:24] you can do: SELECT 0 as id, "" as foo, "" as bar [21:24] to get 0,, [21:25] Coldfusion 8, why? [21:25] the syntax is very simple and there is nothing wrong with it, but the switch that I'm using does not like the fact that the result is NULL [21:27] bah...LOL....LOL the column name was wrong [21:30] Did I ever tell you guys how much I hate MS SQL SERVER(Any version). You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '100 PERCENT master_final.PayorCode, COUNT(DISTINCT master_final.MembNameNum) AS ' at line 1 [21:31] we are in the process of re-writing all of our SQL statements boy this is going to be awesome! [21:32] How would you do this in MySQL 'COUNT(DISTINCT master_final.MembNameNum) AS ' [21:33] bah, where is the manual.....LOL this crap is driving me nuts i tell yah [21:43] BAH.....LOL.... it does not like TOP 100 Percent, CAKE! [21:44] WOW the statment is taking for ever to execute, why would that happen [21:45] man it to fetch 48 records it took 125.295 sec. That is crazy [21:47] reya276: EXPLAIN $yoursql [21:47] will tell you about indexes and such it's using (or more likely, not using) [21:47] oh and that was from the actual query analyzer === excid3|mbp is now known as Amazeballs [21:49] I think you are 100% whomever wrote this query used the damn WisyWig wizard to create the SQL statement hence I had to clean out dbo. and top 100 percent and all kinds of extra nonsense [21:50] seriously if you don't like to write code then why work in the field, is like a cop that does not want to use his gun [22:19] wow this does not make sense why would this query take so long [22:19] 126.323 secs to execute way to long, I change the tables to myisam from innodb and nothing [22:24] Holy crap I moved one little thing from a having to where statement and the same query came back in 19.175 secs