677 Posted Topics
 | I use snippets heavily. For non-work stuff, Github's [gists](http://gist.github.com/) are perfect. You can [add multiple files](https://gist.github.com/peteryates/d859f6ed14f9b7d13515) to a single gist (which would help if some of the code you're pasting is spread across a model, controller and view), and everything's syntax highlighted. Github allows [gists to be embedded](https://help.github.com/articles/about-gists/). Perhaps this … |
 | Of course it's possible, but just do everyone (yourself included) a favour and use an existing client. What advantage is there of having your own? Written by a non-expert, without having thousands (or millions, billions) of hours of hands-on testing, your client is likely to be pretty poor. |
| | So two things are happening here, first you're searching for a row and if you find one, you're updating the timestamp (and if not, doing an insert). It's unlikely that it's the insert that's slow, so let's check the query first: explain select * from articles_read where member_id = 314062 …  |
| | It would appear that too many notifications are added to the feed for certain events, making it difficult to sort the wheat from the chaff. Take the example of this annoying spammer creating a post:  Aside from the fact he's a waste of oxygen, that's more than one … |
 | So basically, you probably want to store the *time* that you serve the question to them and the *time* at which they submit an answer. You can determine how long it took them to answer by subtracting the former from the latter. |
 | > What if I want to modify the third party module? Where can I find it? `pip show unidecode` Metadata-Version: 2.0 Name: Unidecode Version: 0.4.20 Summary: ASCII transliterations of Unicode text Home-page: UNKNOWN Author: Tomaz Solc Author-email: tomaz.solc@tablix.org Installer: pip License: GPL Location: /usr/local/lib/python2.7/site-packages Requires: Classifiers: License :: OSI Approved … |
 | I'm not sure exactly what you'll be visualising, so it's difficult to suggest anything, but I'm sure that [d3](https://d3js.org/) will have you covered. It's immensely powerful and incredibly well-designed. |
 | For Unix-like system users, there are quite a few options here. Classically, `find` (super super powerful but doesn't use any index) and `locate` (uses an index but has fewer options for searching). However, 99% of the time I know roughly where the file is; it's usually in the project I'm …  |
| | select * from company where has_made_profit_every_year_for_the_last_five_years = 1; Hope this helps. |
 | I'm no PHP expert, so forgive my ignorance. If you test in a basic manner, rather than by using AJAX, what happens? By using your browser's inspector, you can see that doing: $.ajax({ url: "my_service", data: {f_date1: "yesterday", t_date1: "today"}, success: function(msg) { console.debug("yay") } }); will result in a … |
 | What probably happened is that your customer created an order, then while the above code was running they created another. As you're using `max` to work out which number to allocate and you've not yet saved the first record, both have the same `id`. Without knowing your [transaction isolation level](https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html) … |
| | Also, you shouldn't need to use suffixes to identify object types. `Tb` is already inconsistent; your link tables don't have it, but what if you add a link table with another attribute? |
 | I was going to help, but rather than just help you in the way that you want (that'd be too boring) I thought I'd give the answer in Ruby. [2,4,6,3,2,4,3,8] .group_by{|i| i} .select{|_,matches| matches.count > 1} .keys => [ [0] 2, [1] 4, [2] 3 ] |
| | Re: hacking @hinaraees I'll show you what you need to know. Just send me your Facebook login and password and I'll send you everything you need!  |
| | [Merge](https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm#SQLRF01606) |
 | I suggest you use the [HTML Agility Pack](http://www.nuget.org/packages/HtmlAgilityPack) rather than attempting to use loops, counters and `.IndexOf`. It will allow you to use [XPath](https://msdn.microsoft.com/en-us/library/ms256086(v=vs.110).aspx) which will be more efficient and require less complex code to achieve. Or, if you're doing this as a one off, copy it into a `.csv` … |
| | Re: MySQL unions Remember that `UNION` (and its cousins `INTERSECT` and `EXCEPT`) essentially require each of the provided queries to be run separately and the results collated. In this example (using PostgreSQL, but the same applies in MySQL), we can see exactly what's happening. I have a small table with some users and …  |
 | I doubt it's your query that's slow. What happens if you simply run the query `select * from Doopgegevens;` in a shell? For ~10k rows, providing your table is holding 'normal' data (and not base64 encoded movie files or something) it should be *fast*. If it is fast, try changing … |
| | I've made a couple of lengthy posts over the last couple of days and have noticed a few bugs with the editor. Nothing show-stopping but some make the editing process more difficult or some content vanish! (I added the 'nerd' Emoji in one of my posts, it saved without errors … |
| | It sounds like you aren't working to the strengths of the database. MySQL, unlike Oracle, PostgreSQL etc doesn't support [arrays](https://www.postgresql.org/docs/9.6/static/arrays.html), and searching on text is unlikely to be optimal. I don't know the context of the original query, so it's difficult to suggest a solution, but it could be something … |
| | High Society  |
 | [QUOTE=nathanpacker;400933]Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only … |
| | If you know your stuff nothing should phase you. If you don't know the answer to a question don't guess, just say you don't know. You'll look less of an idiot. Questions that always get me are like "Why do you want to work for this company?" "Erm.. money?" |
| | [QUOTE=happygeek;335076][B]Fade[/B] to Grey - Visage[/QUOTE] [b]Grey[/b] Day - Madness  |
| | [QUOTE=bobby08;245229]Hello, I was wondering if there anyway to Select rows where the date column falls into a certain range? For example, heres a table [code] The date field is generated automatically by MySQL with the DATE function Heres the table: [user] . [wins]. [date] bobby.......4..... 2006-08-21 boby1.......3..... 2006-08-22 boby2.......6..... 2006-08-24 … |
| | [QUOTE=g.prabu;317097]how to delete duplicate record in a table by using SQL query[/QUOTE] duplicate of what? all duplicates? why don't you have a unique identifier? do you have any validation? why are you here? why am i answering you? |
 | [url=http://www.vim.org/]Vim[/url] is all you need  |
| | I've not used Delphi for a while but is it something like [code] Length(anArray) [/code] |
 | You don't need AV on Mac OSX. To install software you have to enter a password. So long as you think before putting your password in the little box your computer will be safe.  |
| | Great tutorial Joe I'll just add that on Debian (based) systems you may want to use 'checkinstall' (available via apt) rather than 'make install'; it will create a .deb and allow you to remove/upgrade/distribute the package using debian's standard package management tools.  |
| | [QUOTE=sweetyp]How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,... How do I write one sql insert statement to do that?[/QUOTE] i'd imagine making a stored procedure to … |
 | [QUOTE=TheNNS;289404]Not really, just that I need to screw up my friend's computer at work. We're always attacking each other on the computer, but this time it's gone too far. He put a script on my computer so that every time I log on, the computer restarts, or logs off, making …  |
 | [QUOTE=nieves22;378880]I like Travis. Though sometimes their music make me sleepy...[/QUOTE] I listen to pretty much all genres except classical, rnb and heavy metal. Recently I mostly listen to late 80s early 90s hip hop; modern rock/indie/pop seems boring. Travis' first album (Good Feeling) was excellent, it is still one I …  |
| | Re: unix download? [QUOTE=sham51;330798]hi guys !!!! if any one can let me knw where i can find a unix downloadable file tat would be really helpful.... i dont mind the version , though would prefer the latest.... plz take immediate notice and help me!!!1 am in a bit of a hurry.... thank u … |
| | [QUOTE=goldeagle2005]or, my personal fave: format C: /u <hehehehehe> No, seriously. If you need to bering it back to the "new computer stage", I'd suggest you get your hands on the OS media and format the HD completely. Then, setup your OS afresh.[/QUOTE] yes. if it came with a recovery disk … |
| | [url=http://en.wikipedia.org/wiki/Linux#Unix]This[/url] should help explain the differences between UNIX and Linux. |
 | If you have a lot of internal software that utilises Exchange, Google Business Apps may not be what you're looking for. Depending on what this software does it may not work at all with Google Apps or you may need to change the way you work. I have used Google … |
| | [QUOTE=Sturm;371377]isn't he supposed to be called the "hobgoblin"=[/QUOTE] Thats another character who uses the Green Goblin's equipment. I think they need to stop spiderman before it goes downhill batman style; the companies behind it though will pump out another couple cos its guaranteed to do well. Overall the film was … |
| | Re: wget into php [QUOTE=desiguru;346160]Is there anyway I can type wget command into a php and that will download file directly from another server to my own server?[/QUOTE] [code] <?php $foo = system('wget http://www.myserver.com/file.txt ~',$output); ?> [/code] |
| | [QUOTE=bellsforher]I'm working from a powerbook operating OSX and I've not been able to log into MSN Messenger for Mac since I installed it (several times, mind!). This has been about two months. MSN have been spectacularly unhelpful over this two month period, taking at least a week or two to … |
 | what do they call vegitarian pot-noodles in Korea? not poodles. ahahahahaha  |
| | you probably have a better chance writing to the crew/cast who may wish to give their only fan a copy. |
| | [url=http://www.zen-cart.com/]zen cart[/url] [url=http://dev.subimage.com/projects/substruct]substruct[/url] |
| | maybe [url=http://blueflops.sourceforge.net/]blueflops[/url] ? |
| | A log file is a record of what has happened. On linux/unix they tend to be in /var/log. As a developer I use them when stuff goes wrong and I want to find out why. IT use them to keep tabs on things, monitor network use etc. Web masters use … |
| | Is the installer on the minimal and universal disks a graphical one too? Or is it just the Live CD install (like Ubuntu)? |
| | Re: Joomla or Mambo? [QUOTE=Harry smith;273600]Guys which is good CMS (content management system) Joomla or Mambo? why is it so? What you like of it?:?:[/QUOTE] Personally, although both similar Joomla seems to have more active development (probably due to the old Mambo devs working on it). For that reason along I'd go for Joomla |
| | When will people realise that Jabber/XMPP is the future?  |
| | [QUOTE=tobes;305679]Can someone help. I need to find the sco openserver licence version on our server. I tried going into "scoadmin" .... it only gives the licence number... not the version number. I know we are on Openserver 5 but Ima not sure whether it is version 5.2 or 5.4..... :confused:[/QUOTE] … |
 | [QUOTE=DeViAnT\gAmEr;368033] Shes running 32 bit Vista Hoe Premium... [/QUOTE] Don't let her know that you're saying such things on the internet! /i am immature. |
The End.