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.
(This post is more than 2 years old.)
Blog CFC Updated
Support this Content!
If you like this content, please consider supporting me. You can become a Patron, visit my Amazon wishlist, or buy me a coffee! Any support helps!
Want to get a copy of every new post? Use the form below to sign up for my newsletter.
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.