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?! Continue reading
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 legal.
Sometimes, it’s desirable to synchronize child report page settings to their parents. Brian Welcker posted a code sample showing how to automate this property copying using the now old-style .Net 2.0 Web Reference approach. Let’s implement the same functionality using the modern (though, unfortunately, more verbose) Service Reference approach. Continue reading
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 GET, PHP properly populated $_GET. What was wrong with $_POST?! Continue reading
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? Continue reading
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) or June 2012 (unknown day)? Continue reading
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 a class which it doesn’t recognize, it will error out with a “class not found” error. Also, without Magento’s startup process running, PHP doesn’t know about the Mage family of singleton methods (e.g. Mage::getModel(), Mage::helper()) which are commonly used to create class instances. Continue reading
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 memo text? Continue reading
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 Insert Object, etc.) from the pop-up menu. When a container field is primarily used to store non-audio content, the required right-clicking quickly gets old. How do you modify a container field’s behavior so that a left-click displays the Insert File dialog? Continue reading
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 processes control-of-flow statements normally. In the case of an IF statement, SQL Server determines which conditional expression evaluates to true and then executes the code associated with that expression. Turn FMTONLY to ON and SQL Server executes every conditional branch, even those associated with conditions evaluating to false!
Programmatically Setting a Magento Item’s Price When Adding It to Cart
Using code, how would we give a Magento item a one-time special price then add that item to the shopping cart?
The process is simple:
- Create an instance of the Magento product,
- give it a custom price by calling setSpecialPrice,
- then save the product instance (store must be running as the admin store).
- Next, grab the Magento cart object (a singleton),
- add the product instance to the cart,
- then save the cart.
