Posts

Showing posts from June, 2019

Social Media Logins and Account based systems

So you want a sign in account based thingo for your Acme website with the old social logins and maybe even a roll your own one for those who don't trust your linking to any of these social companies. Seems simple enough, but there are some interesting side things that can happen. Suppose you are on Facebook, Google and Hotmail (whatever it's called) even Twitter and Linkedin. If you are one of those types who has a different email for each service, then thanks and good luck that's your problem, every time you sign up/in, you'll be given a new account by our Acme company. If you do have an email address that follows you round, then shouldn't you not care about who is validates that it's you? Sure, you shouldn't care, so said user then doesn't need to remember whether they signed on with Facebook / Google/ Linkedin or whatever. So how do we achieve that? well at some point, you have to have 1 metric which you deem to be the identifier. Not nece

ArraySum in Lucee for Query Total and ValueList

Over at Lucess's Atlassian bug board is a reported which I come across all the time in cross compatibility between ACF and Lucee  https://luceeserver.atlassian.net/browse/LDEV-544 I'm not a fan of proprietary functions like queryColumnData, so the easiest equivalent for both to work is : arraysum(listtoarray(valuelist(qryObject.columnname))) Not as neat as the old ArraySum(qryObject["columnname"]), but who cares, I only seem to use it for table totals anyway!