Just a note to let anyone who doesn't know -
I'm doing a presentation this Thursday to the Melbourne CFUG on using Eclipse as a IDE for developing ColdFusion.
To c/p from the notice that was sent out to the CFAUSSIE mailing list, I will be presenting:
- Installing Eclipse
- Plugin installation (including CFEclipse, as well as several handy others)
- Overview of using Eclipse and it's capabilities.
- Overview of CFEclipse and it's capabilities.
- General Q & A.
I will basically be taking a clean computer - and installing Eclipse, and then going through installing plugins piece by piece, so if you are new to Eclipse, it should (hopefully) leave you with a good idea about how to set up Eclipse for yourself as a good IDE for developing ColdFusion - which can be a bit of a hurdle if you have never used Eclipse before.
The plugins I will be installing (for reference)
I hope to see some people there!
Something I came across today when dealing with Chinese languages -
the javascript escape() function only works for ASCII characters, so if you are using another language things tend to go wonky pretty quick.
The function you want to use is encodeURIComponent() which will handle Unicode quite happily.
For a bit more reading: WorldTimZone's article on UTF-8 encoding for older browsers.
This was one of those things where I've just gone 'I wonder if this works..' and strangely enough it DID!
Situation was something like the following (okay - something is a very broad term, because it wasn't really like this at all) -
I have a document management system - and each document has a document_createdDate and a document_releaseDate - however if the user chose to release a document 'Now' the document_releaseDate would be set to NULL.
So when I went to order a document list by document_releaseDate, obviously that would be rather hard, as values could be NULL in a date list.
So I figured - why not sort such that, if is document_releaseDate is NULL, then sort by the document_createdDate - that would provide a able solution to my sorting issue.
Then I discovered I could put CASE statements into my ORDER BY clause - and that made things real easy - e.g.
select *
from
tbl_document
order by
case
WHEN document_releaseDate IS NULL then
document_createdDate
else
document_releaseDate
end DESC
And presto - a conditional sort! Of course there are other ways to solve the same problem, but I thought that was nifty.
This was done a Oracle 9i database.
