677 Posted Topics
 | As a SQL contractor who comes across computer-generated messes like this rather frequently, I'd like to make a suggestion. Break this up into manageable chunks. Here's your query with syntax highlighting:  Attempting to do the `case` statements alongside aggregate functions with a load of joins and criteria is … |
 | I guess the beauty of markdown is that they can introduce it without it really affecting people who don't know or care about it. The only markdown directives that might get in the way are, as you said, asterisks. I guess FB chat doesn't allow hyperlinks, headings or lists? Anything …  |
| | Re: Insomnia I don't really suffer from insomnia but on occasions when I can't get to sleep listening to an audiobook for a few minutes usually makes me drop off. I think it's because it takes my mind off whatever it was on and, depending on the book, can be quite relaxing.  |
 | I'd start by getting someone who speaks native English to proof-read your text. I'd also drop the name Microsoft from your company name, it's likely to make potential customers think you're a scam outfit. Get rid of the obviously fake customer reviews and dodgy stock photos. Think about what you …  |
 | If you want to record customers without coding anything I'd just embed a Google form which would be linked to a spreadsheet on Google Drive. Yes, it's not an `.xslx` file and it doesn't react differently depending on whether the record already exists, but without building a proper website and … |
 | > Because, when I mentioned my browser somewhere (that revolves around my big ideas), one of the major international advertising company (from where the money would be coming from to the browser users) read the concept and told me not to go ahead publicising it anymore unless they get back … |
 | I'm no PHP expert but shouldn't you be using [`SERVER_NAME`](http://php.net/manual/en/reserved.variables.server.php), which is set in your webserver config? |
 | Re: Watermark Quite an easy process. Just create a semitransparent watermark, find an image, add the watermark to your image and voila, you're done!  |
 | Re: Table design > Should I turn those into an extra column or should they become seperate tables? They should definitely be stored in a separate table (say, `food_category`) and you should add an appropriately-named foreign key to the table you posted (let's called that `food`). In SQL, you'd use a statement like … |
| | > Back in 2012, I once built a .exe bot that finds you WP blogs that still have their commenting section open and then posts your comment. Well done, your posting bot has obviously evolved to posting to forums and ever since you added the `Rambling::Bullshit` module and pointed it …  |
 | Python is a solid first choice, it's really easy to get up and running, it's very sensibly designed and has plenty of libraries to choose from when you start doing more advanced things. |
| | I think Social Bookmarking services are a niche trend at best. They were very popular in the early-mid 2000's but the need for them was erroded from multiple angles. Chrome came along with its excellent browser syncing, which in turn forced Firefox to up its game and follow suit. This …  |
 | I'd start by learning Java. Then SQL. When you've learned Java and SQL, then learn HTML. Now you've mastered those relatively simple subjects, just learn all of the glue that connects them together. Once you've done that, it's quite simple: Your attendence is probably represented by a join table; a … |
 | You can't create a table if a something with the same name already exists. If you have created it in error and it doesn't contain any important data, drop it. drop table PO; Now your `create table PO ...` command should work. |
 | Nope, `FINDSTR` only returns whole matching lines. You're best creating something in Powershell to return only what you want. |
 | Unfortunately, MySQL doesn't support [Window Functions](https://www.postgresql.org/docs/9.6/static/tutorial-window.html), which make this type of query much simpler: select rank(), pos, performance, wind, athlete over ( partition by athlete, wind order by pos, performance ) |
 | So you're building an OS *and* an IDE but the contents of a project file are confusing? Just do yourself a favour and use something built by experts until you see a shortfall that you'd like to address. Note, I'm not saying don't build an OS, an IDE or a …  |
| | I don't envy the task ahead of you Dani. There just isn't the enthusiasm there once was. Tech support has largely been supplanted by stackoverflow, the social/discussion aspect by Reddit, Facebook, etc. Maybe putting DW on ice and concentrating on Dazah making inroads into its intended market is best. The … |
 | The problem looks like it's the quote symbol on your require line, `require ‘watir’`. In Ruby, this *needs* to be either a standard `'` or `"` pairing. If you really want to you can use [percent string syntax](https://ruby-doc.org/core-2.4.0/doc/syntax/literals_rdoc.html#label-Percent+Strings), in the`require %q{watir}` style, but in more than 14 years of Ruby … |
| | Using tables for borders like that is no longer required, it's very brittle (as you've found out) and unnecessarily fiddly. Drop shadows can be implemented with a single line of CSS: .card.login-form { margin-top: 8rem; box-shadow: 6px 6px 66px 6px rgba(0,0,0,0.39); } Here's how your login form would look using … |
 | You could always switch to a language where indexing starts at `1`. FORTRAN, Lua, Pascal and Smalltalk to name a few. |
 | There are browser addons that [do this automatically](https://chrome.google.com/webstore/detail/lazarus-form-recovery/loljledaigphbcpfhfmgopdkppkifgno). Not the perfect answer, I know, but might come in handy. |
 | What's `APACHE_RUN_DIR` set to? It will be defined elsewhere in your config  |
| | Or, add a [`fulltext`](https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html) index to your table (across all the columns you care about) and use `match (cols...) against` syntax. |
| | You can use three columns, just simplify your HTML a bit. See [this](http://jsfiddle.net/DTcHh/)  |
| | Just find the ban hammer. |
| | Prefixing tables with `tbl` is pointless and makes reading the SQL much more difficult. Line 2 looks wrong, you can't comma separate `join` criteria, you should use `and` instead (and maybe add brackets for clarity). Now, describe in one sentence the data which you want to retrieve.  |
| | I'm a bit late but rather than VMs I'd recommend Docker with [Kitematic](https://kitematic.com). From the UI you can search for images and in a couple of clicks have the latest and greatest pulled and running locally. Operating systems, databases, programming environments, forums, bug trackers, infrastructure, CI, you name it, there … |
 | [You need to select the correct app category](http://stackoverflow.com/a/29397507/7649503). |
 | |
| | Re: Brainf**k There are plenty of [esoteric programming languages](https://en.m.wikipedia.org/wiki/Esoteric_programming_language), some of which have been around for a [long time](https://en.m.wikipedia.org/wiki/INTERCAL#Syntax). I'm not sure actually teaching students syntax is too important, but demonstrating that there are many languages each with their own strengths and weaknesses is. Readability and succinctness are *definitely* advantages.  |
| | Re: Shortcuts to SSH Here's how I'd do it (and have done it for years). It's the canonical, accepted answer for Linux too. The SSH program has support for 'shortcuts' built in, you simply need to add the hostnames (or aliases) in your `~/.ssh/config` file. So, in *my* config file, if I have the … |
 | Re: how i can do it You can't have it because immediately after assigning it you're overwriting the value. I believe you can fix it by turning your computer upside down so the first line runs after the second. Hope this helps. |
| | You're calling `worldmapA()` but your function is called `worldMapA()`. Chrome dev tools will help you in situations like this.  |
 | Your regexp should probably be `[\*]?[ABMQRWY][A-z0-9]{4}235`, see [this](http://rubular.com/r/wGDVXXZIVu) example. |
| | You can do it using `border-radius` ([here's an example](http://jsfiddle.net/NXZnq/)) but it's not guaranteed to always be circular. If you change the `1` to `100,000` you'll see what I mean. |
| | I am not a lawyer, but I believe that if you 'port' software from one language to another, you're creating a derivative work and the original licence applies. However (from Wikipedia): > The code base of Netlib was written at a time when computer software was not yet considered merchandise. … |
| | Did you actually read the source? Assuming you want to replace the `icon-cog`: <div class="icon-cog box-icon"></div> Replace the contents of the div with an `img` tag: <div class="box-icon"> <img width="60" height="60" src="http://i.imgur.com/vPkeDtI.png"/> </div> Results in beautiful images whever you like.  |
| | I'm currently writing a Markdown powered CMS, which adheres to [Commonmark](http://commonmark.org). Their [help page](http://commonmark.org/help/) is quick, easy and to-the-point. |
 | If you plan on writing in English, I'd master it first. Yes, I know you're actually linking to that site for SEO purposes. Kind of lame at the best of times. |
 | [XPath](https://www.w3.org/TR/xpath/) `/solar/solardata/solarwind|/solar/solardata/magneticfield` yields: <solarwind>509.4</solarwind> <magneticfield> 1.9</magneticfield>  |
| | If you did that it would no longer be responsive! (actually, the only way it would 'respond' would be if you're using a tablet/phone and rotated it) |
| | Re: Chat application A graph database alone isn't the right choice for a chat application. A message would be represented as an edge between two nodes (people) and too many edges will hurt performance. Storing the actual social network portion of a chat app in one makes a lot of sense, though. It's … |
| | I'd try somewhere like Microcenter, if you look at their clearance/open box section on the website there are some deals to be had. I don't know what your budget is, but [this](http://www.microcenter.com/product/455377/XPS_8900_Desktop_Computer?ob=1) for $791 looks like it'll fit the bill. You'd have to see what's available in your local store … |
| | If you want to play 3d games or develop with Cuda/OpenCL, very. For browsing the web and 'normal' development, not so much. Neither my MBP and XPS have one, both are lightweight and quiet, and both cope fine with a big external monitor. Also, if you plan on running Linux …  |
 | |
 | |
 | Re: page skips I'd suggest using something like SquareSpace for this kind of site, rather than attempting to build it yourself. It has an e-commerce module built-in and plenty of easy templates to choose from. A note unrelated to the original question, when at 100% zoom, I can only see 2/3 of the … |
| | > Perhaps what I am doing, however, is creating a new membership record? This is correct, but when you're posting to `/groups/memberships`, to which group are you adding a member? I'd expect to see something more like this. Of course, you don't *need* all of these actions (i.e. updating a … |
| | In Chrome, open the dev tools and click "Toggle Device Toolbar". In the toolbar's dropdown, you'll see entries for common devices (Nexus 5X, Nexus 6P, iPhone 5, iPhone 6, iPad and iPad Pro).  |
The End.