Community Member
Member Avatar
pty 184 Replied To a Post in SQL query joining 6 tables in asp.net
Topic by Alv45525 in Databases
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. Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in A playground for php
Topic by JamesCherrill in Programming
php
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 … Reply by pty
Member Avatar
Topic by UI in Community Center
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 … Reply by pty
Member Avatar
pty 184 Replied To a Post in string
Topic by Mehar Awais in Programming
Don't worry, my program does this. Thank you for your concern. Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Invite Facebook Friends to visit your Website.
Topic by SimonIoa in Web Development
[You need to select the correct app category](http://stackoverflow.com/a/29397507/7649503). Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Shortcuts to SSH
Topic by Dani in Mac OS X
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 … Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Brainf**k
Topic by AssertNull in Programming
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. Reply by pty
Member Avatar
pty 184 Replied To a Post in how i can do it
Topic by kiyo_1 in Software Development
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. Reply by pty
Member Avatar
Topic by FarrisFahad in Search Engine Strategies
Without original content you'll struggle. And high quality original content, believe it or not, takes time and effort (or time and money!).

Also, blocking your site up with a non closeable image on mobile is not a good sign. Reply by pty
Member Avatar
Featured pty 184 Created Mastodon
Has anyone tried [Mastodon](https://en.wikipedia.org/wiki/Mastodon_(software)) yet? For those who don't know it's a federated, distributed and (currently) technology-orientated social network (well, rather a group of interoperable social networks) that's fully open source and ad-free. I've been impressed so far but as with every new network, whether it flies or not will … Topic by pty in Community Center
Member Avatar
Featured pty 184 Replied To a Post in Mastodon
Has anyone tried [Mastodon](https://en.wikipedia.org/wiki/Mastodon_(software)) yet? For those who don't know it's a federated, distributed and (currently) technology-orientated social network (well, rather a group of interoperable social networks) that's fully open source and ad-free. I've been impressed so far but as with every new network, whether it flies or not will … First Post in Topic by pty in Community Center
Member Avatar
pty 184 Replied To a Post in Trying to find a bug in my JS game.
Topic by Goldfinch in Web Development
Perhaps try a slightly different workflow. If your code is transpiled you'll see these errors in the console straight away. Look at [Typescript](https://www.typescriptlang.org), a typed superset of JavaScript, or [Babel](https://babeljs.io), which allows you to write the latest version of JavaScript (es6, es7) but serve es5. Reply by pty
Member Avatar
pty 184 Replied To a Post in Perl Regular Expression help
Topic by Jason_31 in Software Development
Your regexp should probably be `[\*]?[ABMQRWY][A-z0-9]{4}235`, see [this](http://rubular.com/r/wGDVXXZIVu) example. Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Create circle with css
Topic by davy_yg in Web Development
css
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. Reply by pty
Member Avatar
pty 184 Replied To a Post in Trying to find a bug in my JS game.
Topic by Goldfinch in Web Development
You're calling `worldmapA()` but your function is called `worldMapA()`.

Chrome dev tools will help you in situations like this.

![Screenshot_from_2017-04-14_13-18-12.png](/attachments/large/0/25cfa35fa5b536f7ed612d572ba02c2b.png "align-center") Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in How to Choose License Type?
Topic by DavidB in Community Center
Wikipedia support [Latex](https://en.wikipedia.org/wiki/Help:Displaying_a_formula#LaTeX_commands) notation which shouldn't require any uploading on your behalf. Reply by pty
Member Avatar
Featured pty 184 Gave Reputation to DavidB in How to Choose License Type?
I have translated many numerical math programs from FORTRAN into C++ and JavaScript. The original FORTRAN source code listings are posted on the NETLIB site and have been in the public domain for 20, 30, years.

The C++ and JavaScript translations that I write are hand-coded, line-by-line, and repeatedly tested … First Post in Topic by DavidB in Community Center
Member Avatar
Featured pty 184 Replied To a Post in How to Choose License Type?
Topic by DavidB in Community Center
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. … Reply by pty
Member Avatar
Topic by newbi11 in Web Development
Plus, the CSS is totally different between the first and second fiddles. Posting examples with minimised code is a bad idea, it's clearly broken because while it looks like Bootstrap 2 the fonts aren't applied in the preview window. Total failure. Reply by pty
Member Avatar
Topic by newbi11 in Web Development
It's unresolved because you're a chump. I'm not here to do your work, resize your images or craft your stylesheets.

You asked a question, I answered it; I subsequently ignored the request for further help via PM. Your posting history is fun of similar tactics. Maybe you should rethink your … Reply by pty
Member Avatar
Topic by newbi11 in Web Development
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.

![Screen_Shot_2017-03-25_at_14_38_25.png](/attachments/large/0/53a382fb4b264f77092269a378dbaf78.png "align-center") Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Change Markdown Syntax Page
Topic by diafol in Community Center
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. Reply by pty
Member Avatar
pty 184 Replied To a Post in Email marketing or Social media
Topic by Sinelogix_1 in Digital Marketing
Not spamming forums with stupid questions works quite well, you should try it. Reply by pty
Member Avatar
Topic by bill_21 in Digital Marketing
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. Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Twitter Bootstrap based on device width
Topic by Dani in UI / UX Design
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) Reply by pty
Member Avatar
Topic by Phil_7 in Web Development
The XPath works, your PHP looks wrong.

$xmllint --xpath "/solar/solardata/solarwind|/solar/solardata/magneticfield" solarxml.xml

<solarwind>511.8</solarwind><magneticfield> -0.7</magneticfield>

I assume you didn't read [the documentation](http://php.net/manual/en/simplexmlelement.xpath.php). I don't know PHP, there may be preferred libraries for this type of thing. Reply by pty
Member Avatar
Topic by Phil_7 in Web Development
[XPath](https://www.w3.org/TR/xpath/) `/solar/solardata/solarwind|/solar/solardata/magneticfield` yields:

<solarwind>509.4</solarwind>
<magneticfield> 1.9</magneticfield> Reply by pty
Member Avatar
pty 184 Replied To a Post in Chat application
Topic by jeffersonalomia in Web Development
Yes, that sounds like a good use case and it's quite easy to set up a reasonable demo in Neo4J.

create
(Frank:Member {name:'Frank'}),
(Julian:Member {name: 'Julian'}),
(Amanda:Member {name: 'Amanda'}),
(Claire:Member:Admin {name: 'Claire'}),
(Susie:Member {name: 'Susie'}),
(Dolly:Member:Admin {name: 'Dolly'}),

(Frank)-[:HAS_CHATTED_TO]->(Amanda),
(Claire)-[:HAS_CHATTED_TO]->(Frank),
(Amanda)-[:HAS_CHATTED_TO]->(Susie),
(Susie)-[:HAS_NOT_CHATTED_TO]->(Dolly),
(Dolly)-[:HAS_NOT_CHATTED_TO]->(Frank),
(Frank)-[:IGNORES]->(Susie),
(Dolly)-[:IGNORES]->(Julian),
(Julian)-[:HAS_CHATTED_TO]->(Amanda)


Which results in this … Reply by pty
Member Avatar
pty 184 Replied To a Post in Chat application
Topic by jeffersonalomia in Web Development
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 … Reply by pty
Member Avatar
Featured pty 184 Replied To a Post in Laptop video card
Topic by Dani in Hardware
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 … Reply by pty