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?
Oh .. you didn't mention having a "text" column. Well like the message says "text" column can't be used with UNION or DISTINCT. EDITNot unless you CAST it to "varchar" (which would obviously mean truncating
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 …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online.
The email signature template has been downloaded from:
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …