CFML apps written a decade ago, still work..
# water-cooler
e
CFML apps written a decade ago, still work..
🤘 1
👀 1
s
I don't have any problem modifying the code I wrote a decade ago..... now the code someone else wrote 2 decades ago is another story
b
I've spent days now adding cfqueryparam tags to legacy code someone else wrote who knows when. So I guess it depends what you mean by, "need to change it."
👍 4
s
I could not even tell you how many thousands and thousands of queries I have had to add cfqueryparams to because someone else didn't do it
😢 2
I feel that that should really be emphasized on all CFML training documents
b
@Scott Bennett I feel your pain. On the bright side, I've been catching up on my music listening.
s
yes, it is nice steady brainless work
work that I usually delegate these days
that and changing iif() to elvis operators, or changing evaluate("form.#something#") to form[something], etc
b
I have a multi-page checklist I'm going through to move code from a CF2016 server to a CF2021 server. Discovering all the missing cfqueryparam tags in what is probably our largest app was a real setback.
s
yeah, I'll do a fixinator scan on new clients and then we tirage and schedule those fixes as time and budget permits
e
I like my legacy code, Here is a book written in 2008, it's still valid. Here is a website, running function Y, it was written in 2008, and it still operates to this day chunking along, receiving only security patches and upgrades when necessary. So far I have seen python, java, Perl, asp/.net code all be rewritten over and over, as something changed with the libraries or infrastructure. It doesn't do anything exciting, but if it failed, it would not be good.
a
Has anyone worked with Appscan to find issues? Do you know how that would compare with Fixinator?
s
The backwards compatibility of CF is definitely a big positive. I have been dabbling with VR development in unity, and it is a nightmare to figure out how to do the same things in different versions of unity.
I'll be going through a tutorial and as long as I do everything with the same version as whoever wrote the tutorial it is fine, then I go try to build something similar in another version of unity and I can't do it because everything has been moved around and there are different object names and different properties, etc
then I have to go find a new tutorial and learn the same thing over again
e
I tried unity, its a mess IMHO.. I have been toying around with https://playcanvas.com/
s
thanks, I'll check that out... I had pretty much thrown in the towel on unity. I was thinking of checking out unreal
👍 1
oooh, it's javascript, that will help... my c# is not that great
e
Neither is mine, and my javascript is horrible, but well enough to get what I want done, plus the export feature is great as it is possible to manipulate data in cf. So its a win win
👍 1
d
Re cfqueryparam, a friend had a colleague ask them, two days in a row, about a crash in their code that would have been solved by using cfqueryparam. The same colleague, twice in two days, not a newb, by calendar at least. Oi. Though I suppose we all live in our own glass houses of some sort or other...
j
image.png
🤣 1
t
Ooh, not so sure. I saw some code once that (naively) used DateFormat() to create a credit card expiry date for use in a SQL query. Trouble was, it created a 2-digit year date, and after a certain year SQL Server would treat that as the previous century (IIRC 30 would become 1930, not 2030). So much stuff can just work… until it doesn’t.
j
just copy legacy code into GPT-4 and ask it to improve it. Works for my old crappy code anyways, lol.