Community Member
Member Avatar
Featured pty 448 Replied To a Post in Access 2000 mdb locking/corrupt on win7
Topic by NuGG in Software Development
Is there anything in the database that can't be migrated to a newer version?

Using a database that's been unsupported for nearly fourteen years is a bad idea. Reply by pty
Member Avatar
Topic by maylynn in Mobile Development
> Not using any PHP page

var url = serverURL() + "/login.php"; Reply by pty
Member Avatar
pty 448 Replied To a Post in output code in VSC
Topic by Siberian in Programming
Without knowing what you've done it's difficult to diagnose anything. Did you install [this](https://code.visualstudio.com/docs/languages/python)? Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in Fixing my not-so-smart TV
Topic by pty in Hardware and Software
Not that anyone will be too bothered, but I created a full guide on how to remove the ads.

[Here is the link](https://gist.github.com/peteryates/b44b70d19ccd52f62d66cdd4bcef1e52).

Hopefully anyone who happens across this thread in a search will find it useful. Post here (or on Github) if you run into any problems! Reply by pty
Member Avatar
pty 448 Gave Reputation to cereal in Data leak through ISP
Topic by Thomas_42 in Networking
Hi!

I remember reading that there was a failure point on SSL as antiviruses were performing a MITM against browsers to verify the contents of connected pages. In practice they used to replace certificates in the client machine. Is this still an issue? See: http://ieeexplore.ieee.org/document/6956558/

Anyway, just a drop in … Reply by cereal
Member Avatar
pty 448 Replied To a Post in Data leak through ISP
Topic by Thomas_42 in Networking
Additionally, in theory your ISP could inspect your data as it passes through them on its way to you. However, sites that contain **important personal data** (such as your bank, email provider, online shops you buy things from, etc) should be secured via [SSL](https://en.wikipedia.org/wiki/Transport_Layer_Security). This will prevent *anyone* from inspecting … Reply by pty
Member Avatar
pty 448 Replied To a Post in Data leak through ISP
Topic by Thomas_42 in Networking
What does your ISP have to do with your data? Why would they ever see it? If they *were* compromised, how would that affect you? Reply by pty
Member Avatar
pty 448 Replied To a Post in how to break number into digits in java?
Topic by Abdullah_18 in Programming
Here is a working version. Unfortunately in the wrong language, looks like OP *will* have to do some work after all.

loop do

puts "Enter a number (-1 to end):"
num = gets.strip

exit if num == "-1"

num
.chars
.each
.with_index(1) {|c,i| puts "Digit#{i} = #{c}"}

end Reply by pty
Member Avatar
pty 448 Replied To a Post in Installing TinyMCE
Topic by davy_yg in Web Development
TinyMCE is open source and the 'community' (read: unsupported) edition is available using NPM, and easy to use with module loaders like webpack and browserify.

I'm guessing Davy hasn't done it that way, but without him saying what he's done it's impossible to point him in the right direction. The … Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in Back up tables from site code?
Topic by overwraith in Software Development
Both Oracle and SQL Server support `BACKUP DATABASE`, but they have different syntaxes and options.

Providing you can connect a web app to any database you want to back up, you should be able to execute these commands using the SQL driver your language/framework provides.

Docs [here](https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#BRADV89511) and [here](https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql). Reply by pty
Member Avatar
pty 448 Gave Reputation to davy_yg in Installing TinyMCE
Hello,

I am trying to install TinyMCE standard version but I have not been successful yet.

tinymce_471_dev/index.php

<!DOCTYPE html> <html> <head> <script src="https://tinymce_471_dev/tinymce/js/tinymce/tinymce.min.js"></script> <script>tinymce.init({ selector:'textarea' });</script> </head> <body> <textarea>Next, start a free trial! First Post in Topic by davy_yg in Web Development
Member Avatar
pty 448 Replied To a Post in XHR Request status 0 issue
Topic by Yugandhar_1 in Programming
Incidentally, here's the portion of my API that handles CORS. It's in Go (with [vestigo](https://github.com/husobee/vestigo)), but should be easily translateable to whatever platform you're working with:


if config.CORSEnabled {

Warning.Println("CORS is enabled, origin:", config.CORSOrigin)

r.SetGlobalCors(&vestigo.CorsAccessControl{
AllowOrigin: []string{"*", config.CORSOrigin},
AllowHeaders: []string{"Authorization"},
AllowCredentials: true,
MaxAge: 3600 * time.Second,
})

} Reply by pty
Member Avatar
pty 448 Replied To a Post in XHR Request status 0 issue
Topic by Yugandhar_1 in Programming
I've come across this before and believe it's related to [`Access-Control-Allow-Origin`](https://en.wikipedia.org/wiki/Cross-origin_resource_sharing). I'd expect it to be a consistent problem rather than something that happens occasionally, though.

Are you serving your frontend and backend on different addresses/ports/vhosts? Reply by pty
Member Avatar
pty 448 Replied To a Post in Creating an array of different data types
Topic by random_1 in Software Development
Not in Java. You can use `ArrayList<MyObject>` and make `MyObject` flexible enough to cope with more than one type.

In other more-flexible languages you can be more direct. In Ruby, for example:



stuff = ["a", :a, 1, ["a", :a], {a: 1}]
=> ["a", :a, 1, ["a", :a], {:a=>1}] Reply by pty
Member Avatar
pty 448 Gave Reputation to rproffitt in Microsoft Edge
Topic by davy_yg in Web Development
Just for this I opened that URL in Opera and the image had a video play button on the left rainbow effect.

Maybe that's not a PNG at all? Reply by rproffitt
Member Avatar
pty 448 Replied To a Post in Microsoft Edge
Topic by davy_yg in Web Development
I don't use Windows. You've probably got the old version cached or something, the latest IE and Edge have supported alpha-PNG files for years. Reply by pty
Member Avatar
pty 448 Replied To a Post in Microsoft Edge
Topic by davy_yg in Web Development
Could you post a screenshot of the problem and the actual .png file? Hard to tell what's going on on mobile Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in Cannot Connect to Database
Topic by mattyd in Software Development
You'd need to check with whoever is hosting your database. The error message you mention is coming from MySQL, so the connection *to the DB* appears to be fine, just the permissions for your particular user on the server are at fault. Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in Cannot Connect to Database
Topic by mattyd in Software Development
You need to ensure that your user has privileges to connect to your database. Try connecting from the command line, use the `grant` command to add permissions to a user, and `flush privileges` to make sure they're applied. Reply by pty
Member Avatar
pty 448 Replied To a Post in Deleting a single record by id
Topic by random_1 in Web Development
Also make the `id` field a `primary key` (or at least `unique`) to prevent this from happening at the application level. Reply by pty
Member Avatar
Topic by Dipayan_1 in Software Development
> databases don't have 'Arrays'

While this [hasn't been strictly true for a number of years](https://www.postgresql.org/docs/9.6/static/arrays.html), @ stultuske is correct in suggesting that using an array inside a RDBMS is likely to have drawbacks. Reply by pty
Member Avatar
pty 448 Replied To a Post in reading a csv file with multiple types
Topic by COKEDUDE in Software Development
c
Yes, use a [library](https://github.com/semitrivial/csv_parser). Writing robust CSV parsers is very difficult because of the difficulty of nicely dealing with "bad" data. Reply by pty
Member Avatar
pty 448 Replied To a Post in Getting MS SQL Query to work in PHP
Topic by Magic8Computing in Community Center
What's the error? Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in Cross-Posting
Topic by AssertNull in DaniWeb Community Feedback
> Unfortunately I am as much in the dark as everyone else here as to how to adapt.

Have a quick look at what's replaced forums in this area.

Take [r/learnprogramming](https://www.reddit.com/r/learnprogramming/) for example.

There aren't any "NEED HOTEL BOOKING APP HALP PLS" posts (they do appear but are *swiftly* dealt … Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in AutoGenerator For Names
Topic by Stefan_1 in Software Development
Use [Faker](https://github.com/stympy/faker) or similar. Keep in mind, there aren't an unlimited number of first (or last) names so you'll have to create *some* random element and append it to avoid clashes. Reply by pty
Member Avatar
pty 448 Replied To a Post in Coding
Topic by Howard_2 in Software Development
This is a good question and there are thousands of potential answers, but here's what I'd suggest. Of course this depends on your interests and what you've learned so far.

Start with a problem. It doesn't have to be complicated or wide-ranging and can be as contrived as you like. … Reply by pty
Member Avatar
Featured pty 448 Gave Reputation to rproffitt in Cross-Posting
Topic by AssertNull in DaniWeb Community Feedback
Here's the dictionary for Pander (noun). "Gratify or indulge (an immoral or distasteful desire, need, or habit or a person with such a desire, etc."

There has been a slew of low quality questions from a few members that were done for nothing more than to expose their spam links … Reply by rproffitt
Member Avatar
Featured pty 448 Replied To a Post in The Best Way to Store ipv4 & ipv6?
Topic by mattyd in Databases
That's the best approach. My suggestion makes sense if you don't have a pile of stuff to migrate, because all the hard work has been done. If migration is a big complex task, cereal's approach is very sensible and more portable between databases/stores. Reply by pty
Member Avatar
Featured pty 448 Replied To a Post in The Best Way to Store ipv4 & ipv6?
Topic by mattyd in Databases
I'd use PostgreSQL which has [native network address data types](https://www.postgresql.org/docs/9.6/static/datatype-net-types.html). Reply by pty
Member Avatar
Topic by FOYSAL_1 in Web Development
Perhaps paste the error instead of a minified jQuery? Reply by pty