| === excid3|mbp is now known as Amazeballs | ||
| Disturbed1 | hello. | 03:35 |
|---|---|---|
| === Amazeballs is now known as excid3|mbp | ||
| DammitJim | morning | 13:55 |
| rmcbride | morning | 14:20 |
| mhall119 | morninig | 15:22 |
| munz_werk | mornin | 15:27 |
| reya276 | Good Afternoon Everyone | 16:53 |
| crashsystems | hah, I just got into work. funny time zones! | 16:53 |
| reya276 | mhall119, man that script thing for MYSQL Kicks A$$! | 16:54 |
| 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:55 |
| crashsystems | Its only 8:56 here in California, which unfortunately is a bit too early for power naps. | 16:57 |
| MichelleQ | never too early for a power nap | 16:58 |
| crashsystems | :D | 16:58 |
| 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:23 |
| reya276 | crashsystems, bah, you don't need any other Loco your good with us right? | 17:50 |
| DammitJim | hey guys | 18:01 |
| DammitJim | is there any way to go to your bookmarks from chrome w/o opening a new tab? | 18:01 |
| 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:21 |
| 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:22 |
| 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:23 |
| rmcbride | oh perhaps you're talking chrome OS | 18:25 |
| * rmcbride kicks self for not requesting one of those netbook thingies | 18:25 | |
| reya276 | DammitJim, I think you have to show your bookmarks bar and other bookmarks and that should show you what you want | 18:33 |
| 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:34 |
| reya276 | right if you enable both it should give you what you are looking for | 18:35 |
| reya276 | it works for me | 18:35 |
| rmcbride | can enable the bar under Tools in the config menu | 18:37 |
| reya276 | hey how can I do a select statement in MySQL although the table I'm using will be empty? | 21:13 |
| 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:20 |
| 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:22 |
| 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:23 |
| 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:24 |
| 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:25 |
| reya276 | bah...LOL....LOL the column name was wrong | 21:27 |
| 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:30 |
| reya276 | we are in the process of re-writing all of our SQL statements boy this is going to be awesome! | 21:31 |
| reya276 | How would you do this in MySQL 'COUNT(DISTINCT master_final.MembNameNum) AS ' | 21:32 |
| reya276 | bah, where is the manual.....LOL this crap is driving me nuts i tell yah | 21:33 |
| reya276 | BAH.....LOL.... it does not like TOP 100 Percent, CAKE! | 21:43 |
| reya276 | WOW the statment is taking for ever to execute, why would that happen | 21:44 |
| reya276 | man it to fetch 48 records it took 125.295 sec. That is crazy | 21:45 |
| 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:47 |
| === excid3|mbp is now known as Amazeballs | ||
| 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:49 |
| 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 | 21:50 |
| 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:19 |
| reya276 | Holy crap I moved one little thing from a having to where statement and the same query came back in 19.175 secs | 22:24 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!