• Member Avatar for pty
    pty

    Replied To a Post in Oracle SQL. How to output more than one record?

    Your procedure is returning `VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE`. You should be returning a `table`.
  • Member Avatar for pty
    pty

    Replied To a Post in 32GB USB stick won't store video files over 16GB

    Which filesystem are you using?
  • Member Avatar for pty
    pty

    Replied To a Post in Google JavaScript code syntax highlighter

    More likely you didn't follow their instructions. It looks quite straightforward to me.
  • Member Avatar for pty
    pty

    Replied To a Post in Back links YES or NO?

    Delete and ban. These threads are worthless.
  • Member Avatar for pty
    pty

    Replied To a Post in Access 2000 mdb locking/corrupt on win7

    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.
  • Member Avatar for pty
    pty

    Replied To a Post in How do i display username after login using HTML page

    > Not using any PHP page var url = serverURL() + "/login.php";
  • Member Avatar for pty
    pty

    Replied To a Post in output code in VSC

    Without knowing what you've done it's difficult to diagnose anything. Did you install [this](https://code.visualstudio.com/docs/languages/python)?
  • Member Avatar for pty
    pty

    Replied To a Post in Fixing my not-so-smart TV

    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 …
  • Member Avatar for pty
    pty

    Gave Reputation to cereal in Data leak through ISP

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in Data leak through ISP

    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, …
  • Member Avatar for pty
    pty

    Replied To a Post in Data leak through ISP

    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?
  • Member Avatar for pty
    pty

    Replied To a Post in how to break number into digits in java?

    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):" …
  • Member Avatar for pty
    pty

    Replied To a Post in Installing TinyMCE

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in Back up tables from site code?

    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, …
  • Member Avatar for pty
    pty

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in XHR Request status 0 issue

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in XHR Request status 0 issue

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in Creating an array of different data types

    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, …
  • Member Avatar for pty
    pty

    Gave Reputation to rproffitt in Microsoft Edge

    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?
  • Member Avatar for pty
    pty

    Replied To a Post in Microsoft Edge

    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.
  • Member Avatar for pty
    pty

    Replied To a Post in Microsoft Edge

    Could you post a screenshot of the problem and the actual .png file? Hard to tell what's going on on mobile
  • Member Avatar for pty
    pty

    Replied To a Post in Cannot Connect to Database

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in Cannot Connect to Database

    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, …
  • Member Avatar for pty
    pty

    Replied To a Post in Deleting a single record by id

    Also make the `id` field a `primary key` (or at least `unique`) to prevent this from happening at the application level.
  • Member Avatar for pty
    pty

    Replied To a Post in Student Database Program in Java for class 10 Students

    > 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 …
  • Member Avatar for pty
    pty

    Replied To a Post in reading a csv file with multiple types

    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.
  • Member Avatar for pty
    pty

    Replied To a Post in Getting MS SQL Query to work in PHP

    What's the error?
  • Member Avatar for pty
    pty

    Replied To a Post in Cross-Posting

    > 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 …
  • Member Avatar for pty
    pty

    Replied To a Post in AutoGenerator For Names

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in Coding

    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. …
  • Member Avatar for pty
    pty

    Gave Reputation to rproffitt in Cross-Posting

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in The Best Way to Store ipv4 & ipv6?

    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 …
  • Member Avatar for pty
    pty

    Replied To a Post in The Best Way to Store ipv4 & ipv6?

    I'd use PostgreSQL which has [native network address data types](https://www.postgresql.org/docs/9.6/static/datatype-net-types.html).
  • Member Avatar for pty
    pty

    Replied To a Post in Google Map not loading - Map showing the error

    Perhaps paste the error instead of a minified jQuery?
  • Member Avatar for pty
    pty

    Replied To a Post in Cloud speed vs Desktop speed

    I develop on an average machine (a 2014 MBP, i5 with 8GB RAM). I don't need any more grunt because I have [AWS](https://aws.amazon.com) at my fingertips. I can have a …
  • Member Avatar for pty
    pty

    Gave Reputation to balaji_8 in Python Bank System

    guyz i typed this code for bubble sorting in python and i think it needs some alterations. could someone pls check it out for me. thanks a lot!!!! i know …
  • Member Avatar for pty
    pty

    Replied To a Post in hide and show css

    Seeing as you're *already* loading Bootstrap, [why not just use it](https://jsfiddle.net/Wc4xt/1052/)?
  • Member Avatar for pty
    pty

    Gave Reputation to naheedkassam in Nesting SQL statements from a single table

    Thanks guys for the tips. I solved it using below query. WITH ReportsCTE as (select UserID,UserDisplayName,UserReportsTo from CRM_User_Master where UserDisplayName in(select UserDisplayName from CRM_User_Master where UserID = 1) union ALL …
  • Member Avatar for pty
    pty

    Replied To a Post in Convert UTC to local time MVC

    I'll just leave [this](https://www.youtube.com/watch?v=-5wpm-gesOY) here.
  • Member Avatar for pty
    pty

    Replied To a Post in Nesting SQL statements from a single table

    That sounds like what he's after. With more than one level you'd need to use a window query to do this. [Here's an example](https://gist.github.com/peteryates/5098463) I wrote many years ago.
  • Member Avatar for pty
    pty

    Replied To a Post in a progrm that take any date and give the name of day

    Date already does this, just replace the date (ie `2004/05/07`) with the one you want. $ date -d"20040507" +"%A" Friday
  • Member Avatar for pty
    pty

    Replied To a Post in Github and Gitlab

    Github and Gitlab are both companies that do more or less the same thing; they provide a hosted Git service. The main difference is that Gitlab is open source and …
  • Member Avatar for pty
    pty

    Replied To a Post in full width responsive image size

    While Davy is almost right, setting the width of the surrounding `div` won't quite work; that will make the `div` itself 100% wide but not the contents. You'd need to …
  • Member Avatar for pty
    pty

    Replied To a Post in Button Disappears

    You can't expect anyone to work out what's going on without posting the accompanying JavaScript. I suggest you make a JSFiddle or similar.
  • Member Avatar for pty
    pty

    Replied To a Post in if statement

    I think the question is "if I compare a string to an integer, what will happen?"
  • Member Avatar for pty
    pty

    Replied To a Post in Is there a function in c# that returns x times of given char or string. Or

    Unfortunately there's not a function that drives traffic to your crappy website either!
  • Member Avatar for pty
    pty

    Replied To a Post in Difference between Linux and Window hosting

    Now you can run SQL Server and .NET on Linux, the remaining differences are user familiarity and price. Linux is free but if you already use and know Windows, Linux …
  • Member Avatar for pty
    pty

    Replied To a Post in Need Help with Database project

    Keeping questions and scenarios fresh helps prevent lesser students (like this one) from just finding the answers online. This problem has been solved hundreds of times, and there's an exact …
  • Member Avatar for pty
    pty

    Replied To a Post in Need Help with Database project

    I'd ask for the money back on whatever course you're doing, the material [hasn't changed for seven years](https://www.daniweb.com/programming/databases/threads/303390/erd-question).
  • Member Avatar for pty
    pty

    Replied To a Post in Please help me make this program work, can't find the problem

    You're welcome, glad I could be of service.

The End.