677 Posted Topics
 | When you say "side of the app" I assume you mean a `dll`. In that case you can use [PInvoke and DllImportAttribute](https://docs.microsoft.com/en-gb/cpp/dotnet/calling-native-functions-from-managed-code#pinvoke-and-the-dllimport-attribute). If you have a separate binary running elsewhere you'll need an API.  |
 | A small bug, clicking the upvote/downvote button on mobile makes the comment box appear *very briefly* then disappear. Happens on Android/Chrome.  |
 | It's not *just* the algorithm, as @alan.davies said, the data plays a part. Instead of storing up or down votes as integers, you probably need to introduce a new relation (let's refer to it as `Vote`) that has a `post_id` and a `user_id` which are foreign keys to the `posts` …  |
 | I created a guide on stopping Samsung from spamming your TV's UI with adverts. The same technique can be used to block skiing vaguely Korean. https://gist.github.com/peteryates/b44b70d19ccd52f62d66cdd4bcef1e52 |
 | I'll help you out by telling you that you need to format your code properly. I'm not surprised you can't find the error in that wall of text. Lastly, dynamic SQL like this is what we'd call a 'code smell'. It's an indication that some other part of your design … |
 | var spamTarget = prompt("What's your email?"); |
 | The two methods are to [store the image directly in the table as a blob](https://docs.microsoft.com/en-us/sql/relational-databases/blob/binary-large-object-blob-data-sql-server?view=sql-server-2017) or to store it on disk (or in the cloud) and store the location/path in your table. I'd favour the latter approach simply because it's simpler, keeps your database size manageable, doesn't require you to … |
 | |
 | Re: Install Apache To anyone other than Davy, you're best using [Chocolatey](https://chocolatey.org/packages/apache-httpd). It's a sane apt/brew like package manager for Windows and does all the hard work for you. Of course, using a Unix like OS makes it even easier.  |
 | That's not how PDF files work. All of the calculations that take place in the layout stage are done and finalised (this sets PDF apart from Postscript). You need to treat PDF files as if they are paper. If there's an update, reprint it from the new source. It's digital … |
 | I'm not sure what you mean by "I am wanting to select an access database table after gaining the ID for the table." To find a record with a matching first and last name using SQL you'd do something like select * from patients where firstname = 'Joe' and lastname … |
 | You need to `union` the two similar tables together then query the resulting set using `group by` with `max` to get the latest information. I'd do this in two stages using views, otherwise your query will be complex and ugly. I think you should also question your database design, needing … |
| | It's easy * Add a new checkbox * Create an associated label with text "Select All" * Write some code that when the new checkbox is checked checks the other boxes, and vice versa. Done. Here are some ways not to do it * Ask a vague question on a … |
 | I quite enjoy puzzles like this. Of course, I suspect that your problem will get much harder once you start adding stuff like `(Banana, fruits, or)` to the equation, as then you'll need to worry about brackets and presedence. However, for this simple version here's how I tackled it in …  |
| | Python is clean, expressive and has a great standard library. It's not *just* a web development language, it can be used for most tasks. Where it really pulls ahead of PHP from a development perspective is its general consistency and availability of scientific libraries. |
| | Reverend Jim is correct. It may help if you say the relationship out loud; if it's a 'has many' or 'belongs to' relationship (with a foreign key) you'd typically use a `join`: * A person has zero, one or many credit cards * A credit card belongs to a person … |
| | Re: GIT stash I think you need to spend a little time learning git before you dive in and start using it. Git can be a cruel mistress. To stash your work run `git stash`. It says that in the doc you "read". In short, don't pull when your repo has uncommitted changes. |
| | The difference between hardware and software is that you can touch hardware. And yes, this is a hijacked thread. |
 | Where are you? In the UK we have markets like Music Magpie that will give you quotes for items in your collection. Failing that, you can always sell through eBay or Amazon but if you have *lots* of CDs, creating lots of ads might be a tedius prospect. |
 | If you have a problem like this you're probably better just starting again. This is a bad idea that will generate useless data. Burn it with fire.  |
 | I love how there's a discussion in one thread about how to save the platform/community and then there's this crap. People left because the signal:noise is better on SO and Reddit. This is clearly noise. Nobody will get anything useful from this and the thousand other threads like it.  |
 | Why are you using PHP for this? Can't you just use an`update` statement with a `where` clause? |
 | Replace `sum` with `avg`. But average (mean) is meaningless without standard deviation, so you'd better work that out too. |
 | Essentially what you need is something that sits between the web page and the database. We'd often refer to this layer as an [API](https://en.wikipedia.org/wiki/Application_programming_interface), but just think of it as a simple program that receives HTTP requests and responds with some data. Here's a really simple example written in Ruby …  |
| | https://stackoverflow.com/questions/10646142/what-does-it-mean-to-escape-a-string |
 | https://dev.mysql.com/doc/refman/8.0/en/join.html |
 | > but searching for "dog mouse cat" will return no results This is what your query is specifying. To make it match a jumble of words you need to can split up the string and group your criteria with `and`. This will soon get messy, especially if your searching across … |
| | There's an implementation of [SQLRand](https://github.com/nettrino/SQLRand) available on GitHub and you can read the original paper that proposed the idea [here](http://web1.cs.columbia.edu/~angelos/Papers/sqlrand.pdf). Personally I think the approach is over complicated and would instead opt for a *sane* ORM and coding standards that eliminate the angles of attack. |
 | Do you want to get sued? Because this is how you get sued. What value is there in an app that redirects me to a website? What value to me, them (the brands), and you? As far as I can see, there's none. |
 | This is why mixing code and markup makes things *more difficult*. If this was in a Rails controller using an ORM it's simple and, more importantly, **debuggable**. PER_PAGE = 20 # should be in a config file, here for clarity def search @results = Video .where(active: true) # plus whatever … |
 | Like doesn't support multiple conditions, you need to use `or`. |
 | I'm more of an editor than IDE kind of guy but VSCode might fit the bill. It has a built in package manager so you can install PHP (or any other language, technology etc) specific functionally. I use it for Go, JavaScript, CSS and HTML/Vue templates and it works just … |
 | I think that spatial functionality probably isn't really required for this, you only need to store coordinates for points (of interest) and a city key in that table, unless you want really fancy functionality like clicking a city will automatically query for any POI within 20km. To start with, an … |
 | You need to provide more info. Is this a form you're submitting to the server to calculate or do you want all this to happen in the browser? Have you tried anything yourself? |
 | |
 | I think you're approaching this from the wrong direction. You should be storing the start date and calculating the increment using `datediff` in a computed column. If you need more complicated logic (like zero days being displayed as one day), take care of that in the application and just store …  |
 | If you *really* care about image quality (say if you're printing fine art photos), Inkjet is better. For almost all office environments where most printing is black text with the odd image that's not going to be hung on a gallery wall, Laser is more convenient and faster. |
 | If you're using a capable database you can create a JSON field, but as with every choice there are pros and cons. The pros are, of course, flexibility. Providing your JSON is valid, it can be stored, no matter how complex or nested. The cons, funnily enough, are also related …  |
 | I don't know much PHP, but if you simply want a list of function names with a count of how frequently they occur, you can do the heavy lifting in grep. Note, I used GNU Grep which I had to install on my mac with `brew install grep`. The one … |
| | What's the advantage of this over `drop schema myschema`? |
 | > my project is about the cleaning service app "Cleaner than your mom" |
 | I'd do this in stages. Create a view where for each table you summarise totals by the month, you'll need to use `extract` or `date_part` to split the date into `year`and `month` integer fields, which you'll group by, and `sum` to get the monthly totals. Then your joining of the … |
| | I'm a frequent eBayer and in all the years of buying I've only been stung once, a long time ago, and stupidly I used nochex instead of PayPal and couldn't even trace the scammer. Now I only buy expensive things (more than say £20) from UK based sellers with excellent … |
| | > to provide matchmaking between users Is there value in that? I know there is value in informed matchmaking but you need a high quality pool of users and companies. Can DW's userbase (which if I'm not mistaken is Dazah's too) support this kind of use in the real world? … |
| | Microsoft has a mixed record. LinkedIn was barely touched (and remains a cesspit of the highest order), Skype was mangled and is a shadow of its former self, as was Nokia. Others, like Yammer and aQuantive were just absorbed. If Microsoft change too much too soon, GitHub users may leave … |
| | If you want a cross-platform UI that doesn't suck golf balls through a hosepipe I'd recommend Qt and [Qt-Creator](https://en.wikipedia.org/wiki/Qt_Creator). It's extensive, well-tested, been around since the mid nineties and has bindings for plenty of languages, but works best with C++. Lots of [high-profile commercial software](https://en.wikipedia.org/wiki/Qt_(software)) and [big open source projects](https://www.kde.org/announcements/plasma-5.5.95.php) … |
| | SSH with keys is the way to go. Written and vetted by cryptography experts, battle tested, hugely widespread and supported by all modern deployment mechanisms. Rolling your own encryption routine can be fun, but it [probably won't be that secure](https://security.stackexchange.com/questions/18197/why-shouldnt-we-roll-our-own). |
 | Sounds like a bug in the API to me. Did you write the backend too? I'd use a tool like HTTPie/cURL so you can accurately and repeatably test requests |
| | Re: border-collapse Learn how to combine CSS selectors. Clue, your failing for is looking for a `table` within `#profitlosstbl`. https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Selectors |
| | In a few years it won't be uncommon to see driverless cars, every car company is pouring money into the problem; a mix of new players like Tesla and Google and older ones like Volvo and Nissan leading the way. They already have hundreds of thousands of deathless hours under …  |
The End.