When do I use a surrogate key in PostgreSQL? I have been working on a site where the question of “When do I use a surrogate key?” has come up in conversation quite often. I wrote this out because the answer is bigger than a dinner table conversation. Enjoy. What is a surrogate key? A [...]
Entries Tagged as 'PHP'
PostgreSQL surrogate key guideance
April 19th, 2013 · No Comments · PHP, PostgreSQL
Tags: Enter your zip code here
Format a US postal address in MySQL using null propagation
February 10th, 2012 · No Comments · PHP
How to use null propagation in MySQL to format addresses for the US postal service. If any element is missing, do not print the surrounding punctuation.
Tags:
Add PHPDoc declarations to variables in QCodo
August 3rd, 2009 · No Comments · PHP
QColumn.class.php: line 151. case ‘ControlType’: if ($this->blnIdentity) return ‘QLabel’; if ($this->blnPrimaryKey) return ‘QLabel’; if ($this->blnTimestamp) return ‘QDateTime’; if ($this->objReference) return ‘QListBox’; switch ($this->strVariableType) { case ‘boolean’: return ‘QCheckbox’; break; default: return ‘QTextBox’; break; } _qform_edit.tpl: line 28 /** * @var <%= $objColumn->ControlType; %> <%= $objCodeGen->FormControlVariableNameForColumn($objColumn); %> */ and optionally /** * @var QButton btnSave */ [...]
Tags: