[03:35] <Disturbed1> hello.
[13:55] <DammitJim> morning
[14:20] <rmcbride> morning
[15:22] <mhall119> morninig
[15:27] <munz_werk> mornin
[16:53] <reya276> Good Afternoon Everyone
[16:53] <crashsystems> hah, I just got into work. funny time zones!
[16:54] <reya276> mhall119, man that script thing for MYSQL Kicks A$$!
[16:55] <reya276> crashsystems, really? cool...I just woke up from my power nap at the office
[16:55] <reya276> I love me them power naps, nothing better to refresh you
[16:57] <crashsystems> Its only 8:56 here in California, which unfortunately is a bit too early for power naps.
[16:58] <MichelleQ> never too early for a power nap
[16:58] <crashsystems> :D
[17:23] <maxolasersquad> crashsystems1: How's the Loco there in the Bay area?
[17:23] <crashsystems> It seems nice, though I've not been involved with it much.
[17:50] <reya276> crashsystems, bah, you don't need any other Loco your good with us right?
[18:01] <DammitJim> hey guys
[18:01] <DammitJim> is there any way to go to your bookmarks from chrome w/o opening a new tab?
[18:21] <rmcbride> DammitJim: well there is the "other bookmarks" button, not sure if that's default or something I installed though
[18:21] <DammitJim> is that an extension?
[18:21] <rmcbride> doesn't look like it is
[18:22] <rmcbride> 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] <rmcbride> there's also Bookmark Manager in the configuration menu
[18:23] <rmcbride> 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] <rmcbride> oh perhaps you're talking chrome OS
[18:25]  * rmcbride kicks self for not requesting one of those netbook thingies
[18:33] <reya276> DammitJim, I think you have to show your bookmarks bar and other bookmarks and that should show you what you want
[18:34] <DammitJim> I'm sorry... it's ChromeOS
[18:34] <DammitJim> lol
[18:34] <reya276> In my Chrome I have two places where I can bookmark, the Bookmarks bar and the Other Bookmarks
[18:34] <DammitJim> no, just chrome
[18:34] <DammitJim> not oS
[18:34] <DammitJim> where is other bookmarks?
[18:34] <reya276> OS, not the web browser?
[18:34] <DammitJim> the web browser, not os
[18:35] <reya276> right if you enable both it should give you what you are looking for
[18:35] <reya276> it works for me
[18:37] <rmcbride> can enable the bar under Tools in the config menu
[21:13] <reya276> hey how can I do a select statement in MySQL although the table I'm using will be empty?
[21:20] <maxolasersquad> reya276: You can still run a select against it, you just won't get any data.
[21:20] <maxolasersquad> Are you wanting to join to an empty table, but still get results?
[21:20] <maxolasersquad> reya276: ^^^
[21:22] <reya276> 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] <reya276> to make sure the DB sets the default for the column
[21:23] <mhall119> can you fix the report? seems that's there the actual bug lies
[21:23] <maxolasersquad> I agree.  The code asking for the data should be able to handle an empty dataset coming back.
[21:23] <mhall119> MySQL isn't going to return data that isn't there
[21:23] <reya276> ah ok I can set the default in the table schema
[21:23] <reya276> right
[21:24] <maxolasersquad> reya276: Out of curiosity, what are you using to generate the report?
[21:24] <mhall119> you can do: SELECT 0 as id, "" as foo, "" as bar
[21:24] <mhall119> to get 0,,
[21:25] <reya276> Coldfusion 8, why?
[21:25] <reya276> 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] <reya276> bah...LOL....LOL the column name was wrong
[21:30] <reya276> 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] <reya276> we are in the process of re-writing all of our SQL statements boy this is going to be awesome!
[21:32] <reya276> How would you do this in MySQL 'COUNT(DISTINCT master_final.MembNameNum) AS ' 
[21:33] <reya276> bah, where is the manual.....LOL this crap is driving me nuts i tell yah
[21:43] <reya276> BAH.....LOL.... it does not like TOP 100 Percent, CAKE!
[21:44] <reya276> WOW the statment is taking for ever to execute, why would that happen
[21:45] <reya276> man it to fetch 48 records it took 125.295 sec. That is crazy
[21:47] <mhall119> reya276: EXPLAIN $yoursql
[21:47] <mhall119> will tell you about indexes and such it's using (or more likely, not using)
[21:47] <reya276> oh and that was from the actual query analyzer
[21:49] <reya276> 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] <reya276> 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] <reya276> wow this does not make sense why would this query take so long
[22:19] <reya276> 126.323 secs to execute way to long, I change the tables to myisam from innodb and nothing
[22:24] <reya276> Holy crap I moved one little thing from a having to where statement and the same query came back in 19.175 secs