Coldfusion, WHERE Clause with Dates
In coldfusion, when using an MS Access database, I often build queries in Access and then paste the SQL into my coldfusion page. When filtering (using the WHERE or HAVING clauses) by date, Access surrounds a date with pound signs (#1/1/2055#). Coldfusion uses hash or pound signs as pointers, so such a query will fail. The answer is to use double pound signs (##1/1/2005##).

Archives