Blog CFC Updated
This post is more than 2 years old.
Bug where if no entries for current month and next month is browsed via calendar. Another one found by Rob Brooks-Bilson. As always, the download zip has been updated.
Subscribe for Updates
Want to be informed when I post new articles? If you've got an RSS reader you can subscribe to my feed. If you would rather get an email, simply enter your email address below. You will get an email once a day when new posts have been released.
Archived Comments
Ray,
In the cfc you refer to a function named "getDate()"
Where does this function/method reside?
It''s a SQL function, not a CF function, notice there is no # around it. getDate() is the same as CF''s now() function.
Ok, so by the same token, things like dateDiff() and Day() are SQL functions.
What then would be the most efficient way to handle using an MS Access db (or any other data source) that does not support some of these SQL functions?
I have a child cfc that inherits from your cfc for additional methods - would It be wise to overwrite the base methods from the child, bearing in mind that I would like to easily include any changes you make to the base cfc?
Also, I see that blog.sql has been modified. Have you changed the structure of the database since you first released the code?
Appreciate your help Ray ....
Access has it''s own functions. For example, getDate() in Access is the same as CF, now(). Access also has a datediff function... and I think it''s called dateDiff. The best thing to do is just search on google.
I don''t _believe_ that I''ve modified the tables... actually, I did once, but I know that when I did it, I updated the sql file in the zip.