Category Archives: Programming

Saving & Restoring WPF DataGrid Columns’ Size, Sorting and Order

A data grids usually allow users to reorder, resize, and sort its columns. A refined data grid implementation remembers the user’s changes to its columns’ display, restoring the columns to match how they previously appeared each time the application is … Continue reading

Posted in Programming | Tagged , | Leave a comment

XAML Binding’s StringFormat Ignored!

Why, oh why isn’t <Label Content=”{Binding Amount, StringFormat=C}” />‘s output formatted as currency? Instead of displaying $123.90, the label shows 123.9. My StringFormat is ignored! Is WPF broken?!

Posted in Programming | Tagged , | Leave a comment

SSRS – Updating Linked Report Page Properties

Page property changes made to Microsoft SQL Server Reporting Services (SSRS) reports are not passed on to linked reports. For example, changing a parent report’s page size from letter to legal will not change child linked reports’ page sizes to … Continue reading

Posted in Programming | Tagged | Leave a comment

PHP $_POST Empty After Setting post_max_size & upload_max_filesize

$_POST was empty! Firebug showed that the web browser was submitting the form’s data to the server. Yet, for some reason, PHP was not putting the data into the $_POST array. If I switched the form’s action from POST to … Continue reading

Posted in Programming | Tagged , | Leave a comment

Rake Package Task Fails with Status 127 on Windows

The other day, I tried running a Rake Package task on a Windows system. Rake aborted with “Command failed with status (127): [zip -r Module.zip Module...]“. What could be the problem?

Posted in Programming | Tagged , | Leave a comment

Storing Incomplete (Partial) Dates in SQL Databases

Complete (full) dates and unknown dates can easily be stored in a database table via a nullable date column. What about storing incomplete (partial) dates—where the month, day and/or year is unknown? How do we record July 10 (unknown year) … Continue reading

Posted in Programming | Tagged | 2 Comments

Unit Testing & Magento’s Autoloader

If code written for Magento is executed outside of Magento—as occurs when running unit tests—Magento’s normal startup process (which registers its autoload functionality) is not run. Without the autoloader in place, the first time PHP encounters a request to initialize … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Passing a Memo Field to SAGE Payment Soluations’ Gateway API

In SAGE Payment Solutions’ virtual terminal, transactions have a memo field. However, the gateway’s HTTPS Bankcard Specifications API documentation doesn’t mention a way to programmatically set this field. Using the HTTPS POST API, is there a way to pass in … Continue reading

Posted in Programming | Tagged | 2 Comments

Show Insert File Instead of Record Audio Dialog – FileMaker Pro Container Fields

Click on a container field in a FileMaker Pro form and you’ll be presented with a Record Audio dialog. To store a file or other non-audio content, you must right-click on the field and then choose Insert File (or Insert Image or … Continue reading

Posted in Programming | Tagged , | Leave a comment

SET FMTONLY ON Changes SQL Control-of-Flow Statement Processing

The other day, my friend Jonathan (of Camenisch Creative) surprised me by pointing out that SET FMTONLY ON changes the way Microsoft SQL Server processes control-of-flow statements (IF…ELSE…END, GOTO, RETURN, etc.) When SET FMTONLY is OFF (the default), SQL Server … Continue reading

Posted in Programming | Tagged | Leave a comment