I am running Coldfusion 9 and SQL 2008 and am trying to write a query to merge two date columns (openDate and pastDate) from the same table into one column and extract the year from it so I can sort by year.
<cfquery name="getPast" datasource="Exhibitions">
select Year(openDate + pastDate) as exhibitYear
order by exhibitYear desc
but this just gives me an empty string for all records.
Is there a way to do this?
It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code.
The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day.