andrewsw's Profile User Rating: *****

Reputation: 4518 Guru
Group:
Mentors
Active Posts:
16,809 (17.53 per day)
Joined:
12-December 12
Profile Views:
130,412
Last Active:
User is offline Today, 05:04 PM
Currently:
Offline

Previous Fields

Country:
GB
OS Preference:
Windows
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
3475
Expert In:
VB.Net/VB6
Icon   andrewsw Giggity, Giggity, Goo!

Blog entries

andrewsw's Blog > Basic SQL Knowledge

Posted 21 July 2015

It surprises me how often we encounter people who do not know how to join two tables together in a single query. People seem to find just enough information to create a table, to define a primary key, and to write a simple SELECT query based on the table. They do not read beyond this basic knowledge.

I suppose we could blame the internet to an...

Read Full Entry →

andrewsw's Blog > Find JavaScript Errors in Google Chrome

Posted 07 July 2015

In Google Chrome right-click an element (or anything on the page) and choose Inspect Element to access GC's developer tools.

Image reduced in size

You can apparently use Ctrl-Shift-I to do this as well, although I find pressing F12...

Read Full Entry →

andrewsw's Blog > VB.NET Get SQL Server INCREMENT Value

Posted 14 June 2015

This isn't a tutorial, just a lump of code that I wanted to make available that demonstrates retrieving INCREMENT values for newly inserted SQL Server (Express) records, and displaying them on a WinForm. (There are some links in the code to articles on this subject.)

Of course, you should question whether you need to retrieve, or even...

Read Full Entry →

andrewsw's Blog > Post-It Notes in localStorage

Posted 05 June 2015

I started to explore this earlier today, a web page to create post-it notes, and then save, and retrieve, them from localStorage. I was going to entitle this blog "..work in progress" but I actually found that I managed to complete everything that I intended to include. (Note: I use jQuery.)

You can press the plus sign to create a new...

Read Full Entry →

andrewsw's Blog > Multi-line replace in Sublime Text

Posted 18 May 2015

I recently needed to find and replace blocks of code across multiple files. For example, to replace the footer of every HTML page. (Normally I would use PHP includes so that there is only a single footer, in a single file, but I wasn't allowed to do this for this site.)

It took a bit of digging to achieve this in Sublime Text. (Maybe it is...

Read Full Entry →

My Information

Member Title:
I'm not here to twist your niblets
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Fixing you
Programming Languages:
VB.NET, C#, Java, SQL, PHP, JavaScript, jQuery, HTML, CSS, Python, VBA, VB6, Regex

Contact Information

E-mail:
Private

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    matt4051 Icon

    23 Jul 2015 - 16:21
    Offers really good help, i am very appreciated that he took the time to check my work out
  2. Photo

    _KABOOSE_ Icon

    05 Jul 2015 - 12:28
    awesome
  3. Photo

    mbole87 Icon

    01 Apr 2015 - 00:58
    Andrewsw helps me second time, awesome.
  4. Photo

    farad Icon

    15 Nov 2014 - 16:34
    One of the best...
  5. Photo

    abdalraheem Icon

    31 Dec 2013 - 04:59
    Thanks
  6. Photo

    Michael26 Icon

    14 Nov 2013 - 04:21
    Boom, 2000 rep points :)
  7. Photo

    laytonsdad Icon

    21 Aug 2013 - 14:03
    Getting close to 1500 rep, you are a robot.
  8. Photo

    Flukeshot Icon

    14 Jul 2013 - 16:09
    1337 reputation points, truely elite!
  9. Photo

    Michael26 Icon

    09 Jun 2013 - 14:11
    Wow andrew, you're on fire this month
    82 reputation points, nice :)
  10. Photo

    Michael26 Icon

    27 May 2013 - 16:14
    Great for you andrew, keep up the good work :)
  11. Photo

    jon.kiparsky Icon

    15 May 2013 - 13:13
    Jinx, buy me a coke!
  12. Photo

    laytonsdad Icon

    29 Mar 2013 - 14:15
    You are awesome.
  13. Photo

    kai_itz me Icon

    19 Mar 2013 - 23:10
    superb keep going....
  14. Photo

    _HAWK_ Icon

    04 Mar 2013 - 23:18
    Diggin on your Avatar man!
  15. Photo

    raghav.naganathan Icon

    26 Feb 2013 - 03:05
    Congrats on the 500 Mr.Enlightened :)
  • (2 Pages)
  • +
  • 1
  • 2