Digital Propulsion

DIGITAL PROPULSION BLOG

Determining the devices screen size with Android

A simple code snippet for determining the mobile devices screen size using the Android SDK
Category: Programming | by Adam Plocher on Jan 03

Fun With Dates in Microsoft SQL

This query will generate a DateTime column for the start/end of the Week, start/end of the Month and more.
Category: Programming | by Adam Plocher on Jun 07

Views in MySQL 5.0

A view is a pre-compiled virtual table that is generated by a user-defined SELECT statement. Unlike tables, views don't physically store data on the database server, instead they act as aliases to existing tables.
Category: Programming | by Adam Plocher on May 04

Triggers in MySQL 5.0

MySQL now has the ability to create triggers. Triggers are programmable events that react to queries and reside directly on the database server.
Category: Programming | by Adam Plocher on Apr 05

Stored Procedures in MySQL 5.0

MySQL 5.0 introduced a number of new features, including stored procedures. This guide demonstrates how to create sprocs in MySQL5.
Category: Programming | by Adam Plocher on Mar 20

SQL Injections with Microsoft SQL & Sybase

Microsoft SQL and Sybase use a different method to escape quotes, which means they need special treatment when it comes to SQL Injections in PHP.
Category: Programming | by Adam Plocher on Mar 10

SQL Injections in PHP with MySQL

SQL injections are a major security risk in many PHP applications. Injections are caused when a web developer allows the end-user to manipulate a variable that is being inserted into a database query string...
Category: Programming | by Adam Plocher on Feb 26


1
W3C: XHTML 1.0 Transitional  W3C: CSS Validated