RE: [Blogcfc-develop] First Zip

[Raymond C. <jed...@mi...>]

> 1) Yeah, but you hard coded your name etc. in the path. :-)

Well, it's my product... at least till we get it into CFC. Ok, maybe
it's an ego thing, but does anyone else mind the camdenfamily in the
path? I'll switch it to something else if so.

> 2) > and < in dates suck, don't do it. = sucks even more. 
> Dates are the worst when it comes to SQL (especially if you 
> use Oracle). And FWIW, I strongly disagree with you pulling 
> out DB specific stuff, I think you should indeed use your DB 
> and let it do what it does best. Diff DBs? Sounds like a job 
> for a) stored procedures, b) a loadable db library, c) 
> inheritance, d any or all of the above.

Anyone else thoughts on this? I could support Access and SQL Server w/o
the need for CreateUUID. I'm not sure I agree with Ben here, on the
other hand, I never plan on using anything but SQL Server.

-ray


> 
> 
> 
> -----Original Message-----
> From: blo...@li...
> [mailto:blo...@li...] On 
> Behalf Of Raymond Camden
> Sent: Monday, August 11, 2003 9:07 AM
> To: blo...@li...
> Subject: [Blogcfc-develop] First Zip
> 
> 
> Ok folks, I'm a bit too rushed to investigate the CVS 
> interface, so to make things easier, I'm just sending a zip. 
> Remember, this is not a new feature package, just a 'clean 
> up' package. Changes include:
> 
> 1) Path changes. The client, cfc, and install crap are all in 
> separate folders.
> 
> 2) Cleaner DB code:
> 	Except for two places, there is no SQL Server specific 
> code. The goal is to make the Blog work ok in most, but not 
> all DBs. The db specific code that remains is date specific. 
> I'm going to switch from datePart/diff calls to the use of 
> "where date > X and date < X" type syntax. Anyone know how 
> portable that is?
> 
> 3) Migration Script. There is a migration script in the 
> install folder. It worked ok for me, but has not been heavily tested. 
> 
> 4) There was a bug where I used "id" in a cfc method and it 
> matched a url var, so now ALL arguments use "arguments." in 
> cfc methods.
> 
> 5) The old article editor didn't have a way to add a new 
> category. There is now a way to do so.
> 
> Rough order of what I'll do next:
> 
> a) Change the db specific code and see if I can get 
> Access/SQL Server both running out of the box.
> b) Add "More" support. This is a super easy thing to add.
> c) Purely for my enjoyment, support for <code>. What will 
> <code> do? Any entry that has a <code></code> block in it will...
> 
> 	Automatically color the code using the coloredcode custom tag.
> 	Automatically escape < and >
> 
> So this means you can do
> 
> <code>
> 	<cfset x = now()>
> </code>
> 
> In a blog entry and won't need to worry about escaping the <> 
> in code. It will be done for you by the client.
> 
> d) And then of course we need to begin the real work of 
> getting N blog support/N user/etc.
> 
> ==============================================================
> ==========
> ===
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> (www.mindseye.com)
> Member of Team Macromedia 
> (http://www.macromedia.com/go/teammacromedia)
> 
> Email    : 
> jed...@mi...
> Blog     : www.camdenfamily.com/morpheus/blog
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites 
> including Data Reports, E-commerce, Portals, and Forums are 
> available now. Download today and enter to win an XBOX or 
> Visual Studio .NET. 
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet
_072303_01/01
_______________________________________________
Blogcfc-develop mailing list Blo...@li...
https://lists.sourceforge.net/lists/listinfo/blogcfc-develop