The ‘Computer programming’ Archives
Posted July 4, 2008 by

Symfony / Propel: How to Left Join

A JOIN is a way to connect related database tables by the common values between them. A left join contains all of the rows from the primary table plus related members of the second database if they exist. Using joins can significantly reduce the number of database queries required to render a web page. This […]

Category Symfony

Posted June 27, 2008 by

Symfony: Rebuild from Schema.yml Without Loss of Data

As my test database became more complex, I hated entering data again after doing a propel-build-all. Following these commands, you can save your database content after rebuilding your database from your schema file.

Category Symfony

Posted April 6, 2008 by

Symfony: Delete an Application

The command line provisioning utility in symfony provides mechanisms to create an application, but doesn’t have the means to delete one. If you’ve unintentionally created an application or no longer need an app and want to do housecleaning, this Tech-Recipe describes how to get it gone.

Category Symfony

Posted April 4, 2008 by

Symfony: Fix propel-insert-sql error: Can’t connect to local MySQL server

After building your model and the SQL code to represent it, symfony offers a mechanism to insert the SQL code directly into your configured database. If you are running MySQL locally, this should work for you with no additional configuration. If you are running MySQL on another server, as is common in shared web hosting […]

Category Symfony

Posted March 8, 2008 by

PHP: Print the current year for copyright notices

Hardcoding the year in a copyright notice is an easy way to get a blog or other website started, just placing the starting and ending years next to the copyright symbol. We have the very best of intentions to change this number right after the big ball drops in Times Square each year. We’re also […]

Category PHP programming

Posted March 6, 2008 by

Dreamweaver CS3: Change How Text is Pasted into Design View

Pasting the text from another application into Dreamweaver’s design view can be rather messy. This is due to the default settings, as they keep the original structure and basic formatting of the originating application. Fortunately, the defaults can be changed to better meet your main needs and using Paste Special can be used for situations […]

Posted January 22, 2008 by

Fix for ASP Pages That Will Not Display an ADO Recordset based on a #Temp Table

Here’s the problem: your asp page is designed to display the data contained in an SQL generated #temp table. When you run the page, you get an error that states that the operation is not allowed when the object is closed. If you execute the SQL command in a query window though, the data is […]

Posted September 17, 2007 by

Symfony: Add log message manually

When troubleshooting a complex web application (or a simple one), there are times that sending a message to a log file will help. Two command syntaxes are required depending on if you are in an action or a template. When using the development environment of an application in Symfony, the log message will show up […]

Category Symfony

Posted August 6, 2007 by

Symfony: Troubleshooting file uploads

The Symfony framework is an amazing project which brings many best practices to the hands of mortal coders. It’s also a dauntingly vast system with many subdirectories and classes. While trekking your way up the learning curve, you may run into hurdles which seem daunting. One possible gotcha involves adding file uploading to an existing […]

Category Symfony

Posted July 16, 2007 by

Visual Web Developer: Enable AutoRecover and Set Save Interval

Using AutoRecover can be a real lifesaver, especially if disaster strikes and you lose all of that great coding that you were working on. By default, Visual Web Developer has AutoRecover disabled. To enable AutoRecover and set the save and retention intervals, follow these steps:

Posted May 15, 2007 by

AS3 switch/case statement syntax

This howto describes the basic usage of switch/case statements in actionscript.

Posted May 6, 2007 by

AS3: How to Convert Number to String

Frequently, it is nice to convert numbers to strings in actionscript 3. For example, this will correct the error — 1067: Implicit coercion of a value of type Number to an unrelated type String.