Sign up to connect with pty and gain access to their complete profile
  • Member Avatar
    pty

    Replied To a Post in MySQL lcase vs lower differences?

    They are synonymous, if you check the official docs it says as much. The reason they're both there is for familiarity, SQL Server and DB2 use `lcase`, Oracle and PostgreSQL …
  • Member Avatar
    pty

    Replied To a Post in The DW Homepage shows duplicates and isn't useful.

    While you're at it Dani, I think there should be a preference somewhere to hide (or group, maybe) the "began watching a topic" and "viewed a topic" cards. Am more …
  • Member Avatar
    pty

    Replied To a Post in MySQL transactions

    Did lowering the transaction isolation level to `READ COMMITTED` make any difference to the timing?
  • Member Avatar
    pty

    Replied To a Post in Editing Date format in javascript

    I'd just use [toLocaleTimeString](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toLocaleTimeString). let options = {weekday: 'long', year: 'numeric', month: 'long', day: 'numeric'}; let now = new Date(); console.debug(now.toLocaleTimeString("en-GB", options)); If you need more formatting control then you …
  • Member Avatar
    pty

    Replied To a Post in MySQL transactions

    All RDBMs have more-or-less the same [Transaction Isolation Levels](https://en.wikipedia.org/wiki/Isolation_(database_systems)) but sometimes they go by slightly different names and MySQL has a few extra oddities. Before going further understanding what a …
  • Member Avatar
    pty

    Replied To a Post in MySQL bulk insert timestamp

    MySQL binds `current_timestamp()`/`now()` at the beginning of the statement so I believe all of your records would have the same `created_at` value. If you wanted them to differ I think …
  • Member Avatar
    pty

    Replied To a Post in what is the use of filter in google analytics?

    You can also use filters to *filter out* data from your own networks. This will prevent internal use of your site/app by employees/testers from influencing statistics.
  • Member Avatar
    pty

    Replied To a Post in jQuery does not support mobile touch

    These days, just build responsive. jQuery Mobile has always been a kludge, I wish it didn't have the jQuery name because that made people think it was actually good. It's …
  • Member Avatar
    pty

    Replied To a Post in CodeIgniter redis sessions

    The bugs I linked to are present in the PHP Redis driver, `phpredis`. CodeIgniter's Sessions functionality uses it to connect to Redis. There is even a caveat [in the documentation …
  • Member Avatar
    pty

    Replied To a Post in Show error.... How to copy a store proc one to between database same server

    This is a really weird use-case, I wouldn't recommend it. A better approach is to use a single database and make your dynamic objects (views, functions, procedures etc) aware of …
  • Member Avatar
    pty

    Replied To a Post in CodeIgniter redis sessions

    Looks like this has been a problem in PHP for a [long time](https://github.com/phpredis/phpredis/issues/37). On a brighter note, it looks like [a fix is on the way](https://github.com/phpredis/phpredis/issues/1267).
  • Member Avatar
    pty

    Replied To a Post in DaniWeb: The Next Generation

    Yep looks really good! In making this reply I encountered a slight bug. I typed some words into the box, hit "post reply" and it took me to the login …
  • Member Avatar
    pty

    Recommended Can you tell me how to burn a DVD DL using Windows 10?

    Can you tell me how to burn a DVD DL using Windows 10 and Cyberlink Media Suite, IMGBurn, Express Burn, Winx DVD Author, Wondershare or Windows 10 own burning software. …
  • Member Avatar
    pty

    Gave Reputation to happygeek in How do I compare & merge two Microsoft Access 2007 databases

    Dani was testing stuff, and this thread was used as part of that which caused it to appear in the feed.
  • Member Avatar
    pty

    Replied To a Post in How do I compare & merge two Microsoft Access 2007 databases

    I just realised this thread is six years old. I had no idea that was the case when I answered above. For some reason it was in the main feed …
  • Member Avatar
    pty

    Replied To a Post in How do I compare & merge two Microsoft Access 2007 databases

    So you have a target database (the one you'll be left with at the end) and a source database, the one you'll copy *from*. Take a backup of both of …
  • Member Avatar
    pty

    Replied To a Post in How can i show my website only display on a mobile phone not in pc

    No, that's not how the web works. If I want to browse 2gud.com (I don't, but bare with me) I can just override my user agent at the click of …
  • Member Avatar
    pty

    Replied To a Post in New Employee Training. USA. "Active Shooter Training Module."

    Violence at football matches isn't really a thing now. Yes, it happens but incidents are isolated and infrequent. I'd say the most violent times are Friday and Saturday nights in …
  • Member Avatar
    pty

    Replied To a Post in What is the latest most important trend in digital marketing?

    I think the next big thing is to sign up for forums with a female name and fake avatar and make nothing posts with links to shit websites that like …
  • Member Avatar
    pty

    Replied To a Post in Tory party conference app with ZERO login security hacked by pranksters

    And these clowns want companies to add backdoors and to circumvent encryption. I hope the GPDR gives them a nice kick up the arse while we embarrass ourselves on the …
  • Member Avatar
    pty

    Gave Reputation to rproffitt in python program

    I was able to write this in one line. Here it is. print "9\n89\n789\n6789\n56789\n456789\n3456789\n23456789\n123456789\n" In case this doesn't fit your top post's requirement, I would be guessing if more was …
  • Member Avatar
    pty

    Gave Reputation to rproffitt in python program

    I was able to write this in one line. Here it is. print "9\n89\n789\n6789\n56789\n456789\n3456789\n23456789\n123456789\n" In case this doesn't fit your top post's requirement, I would be guessing if more was …
  • Member Avatar
    pty

    Replied To a Post in Insert into not working in my php code

    I still find it funny that *the* place to go for online tech discussion ([Hacker News](https://news.ycombinator.com/news)) still uses nested tables for all layout. I know it's wrong but it works …
  • Member Avatar
    pty

    Gave Reputation to benanamen in Insert into not working in my php code

    Tables for layout went out in the 90's. We use CSS now.
  • Member Avatar
    pty

    Gave Reputation to Reverend Jim in Convert The numerical string to regular expression? How?

    I've had a few of those. I learned that end-users can be very lazy when it comes to saying what they want so I would write up a spec and …
  • Member Avatar
    pty

    Replied To a Post in Convert The numerical string to regular expression? How?

    I have *optimised* this even more so you don't need to worry about those pesky patterns and stuff. Just use `(.*)`.
  • Member Avatar
    pty

    Replied To a Post in Sorting and loops in Ruby

    Additionally, I forgot the sorting element. For an array of hashes you'll notice that if you try to sort directly the comparison will fail: [{name: "Ringo"}, {name: "John"}, {name: "Paul"}, …
  • Member Avatar
    pty

    Replied To a Post in Sorting and loops in Ruby

    You have made a decent start. In addition to looping you need to think about how you might store the user-entered results. In order to loop you're probably best using …
  • Member Avatar
    pty

    Gave Reputation to AndrisP in jQuery Datepicker: Set Current Date

    I see you are using `<input type="date" />` - do not need set date by jQuery, just add value (format `YYYY-MM-DD`), e.g. `<input type="date" value="2018-09-24" />`

The End.