> That's what the "PreserveSingleQuotes()" function was made
> for - it should fix you right up.

Thank you for jogging my memory on that, it did the trick perfectly.

> As an aside you may want to do some research on how you can
> access variables in CF - I think it'll save you a lot of
> effort here.
> <snip...>
> You could probably get rid of the CFIF as well if you use
> CFQUERYPARAM instead of building "raw" SQL.  You'll also
> get a (small) performance boost and the ability to check
> datatypes.
>
> Don't take this the wrong way - what you have will work
> just fine and there's nothing wrong with it.  I just
> thought since you're talking about creating this is as
> "toolbox" code that you might be interested.

As I continue to get myself up to speed with the new complexities of
ColdFusion MX I am taking things in "baby steps".  My progress as a
ColdFusion developer was slightly hindered at my last job because they were
running CF 4.0 and CF 4.5 on their servers even after 5.0 came out.  There
are things that I didn't even know existed in CF that I need to comprehend,
such as CFC's, custom objects, etc.

I have two goals right now - the first is to get my site (which is what
these admin functions are for) built and the second is to then learn how
things like CFC's and the like can be used to create a 100% portable toolbox
that I can use for any number of sites.

Thanks for the advice and keep it coming, I'm a few years behind and need to
catch myself up to speed pretty darn fast!  I *thought* I was pretty good at
CF and for the most part I can still hold my own, it's just a matter of
teaching this dog the new tricks!

Until Later!
Hatton

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to