358 Lotus blogs updated hourly. Who will post next? Home | Downloads | Events | Pods | Blogs | Search | myPL | About 
 
Latest 7 Posts
A Tool I Made To Export From Notes to SQL (ETL) | Blog
Tue, Jan 14th 2014 95
The Perfect Desk Quest - 2013 Update (Part 2) | Blog
Wed, Dec 11th 2013 57
Recovering a Laptop After Forgetting Windows and BIOS Password | Blog
Wed, Dec 4th 2013 75
Rockall Design Now in its 11th Year! | Blog
Fri, Nov 1st 2013 55
Using Font Awesome Icons in Fireworks | Blog
Mon, Oct 14th 2013 92
Document Action Logs, Including "Limitless" User Comments | Blog
Wed, Sep 25th 2013 247
Bootstrap Advanced Date Picker Plugin | Blog
Fri, Sep 6th 2013 111
Top 10
Document Action Logs, Including "Limitless" User Comments | Blog
Wed, Sep 25th 2013 247
The Hidden Cost of Holidays | Blog
Thu, Jun 14th 2012 232
Money Saving Expert
Wed, Jun 15th 2011 168
Bootstrap Advanced Date Picker Plugin | Blog
Fri, Sep 6th 2013 111
A Tool I Made To Export From Notes to SQL (ETL) | Blog
Tue, Jan 14th 2014 95
Using Font Awesome Icons in Fireworks | Blog
Mon, Oct 14th 2013 92
How To Remove Voice Command From Galaxy S2 Without Rooting | Blog
Tue, Jul 10th 2012 81
Solution to Java Applet Puzzle | Blog
Fri, May 4th 2012 77
Recovering a Laptop After Forgetting Windows and BIOS Password | Blog
Wed, Dec 4th 2013 75
Web Services: Using Complex Types | Blog
Mon, Apr 16th 2012 68


A Reason Not to Like Notes | Blog
   

I've been working on a user registration "component" for a Domino database. Something to let users register for access and then, once logged in, change their passwords.

As part of both processes the password entered is validated and checked it's of a certain quality. It has to be a certain length as well as containing both uppercase and lowercase letters along with some numbers. So, "P4ssw0rD" is ok but "p4ssw0rd" and "P4SSW0RD" aren't.

I needed to perform this validation both in @Formula and LotusScript.

The @Formula is simple:

@Length(Password)>6 & @Matches(Password; "*{A-Z}*") 
 & @Matches(Password; "*{a-z}*") & @Matches(Password; "*{0-9}*")

It would follow that the LotusScript equivalent would be:

If Len(doc.Password(0))>0 And doc.Password(0) Like "*[A-Z]*" And doc.Password(0) Like "*[a-z]*" And doc.Password(0) Like "*#*" Then

But, wait. It looks like there's a bug in LotusScript which means all the following are True:

"ABCDE" Like "*[a-z]*"
"abcde" Like "*[A-Z]*"
"AbCdE" Like "*[A-Z]*"

The only way round this I've found is to use the whole alphabet, like so:

If Len(doc.Password(0))>0 
 And doc.Password(0) Like "*[ACBDEFGHIJKLMNOPQRSTUVWXYZ]*"
 And doc.Password(0) Like "*[acbdefghijklmnopqrstuvwxyz]*" 
 And doc.Password(0) Like "*#*" Then

You've got to like love Notes! An hour of my day wasted...

Click here to post a response



---------------------
http://www.codestore.net/store.nsf/unid/BLOG-20120216-0650
Feb 16, 2012
58 hits



Recent Blog Posts
95


A Tool I Made To Export From Notes to SQL (ETL) | Blog
Tue, Jan 14th 2014 6:10a   Jake Howlett
As I watch all my customers leaves Notes/Domino behind, all I can do is try and assist as best I can. As part of this process I've found myself creating a Notes-to-SQL export tool. The tool is Notes-based and involves the following three part process: Step 1. Loop through and analyse every single document in the target database and build a list of all unique combinations of Form + Field + Data-Type. For each combination it finds, a Notes document is created which lists the Form name, the Fie [read] Keywords: domino lotus notes rich text database server sql
57


The Perfect Desk Quest - 2013 Update (Part 2) | Blog
Wed, Dec 11th 2013 3:10a   Jake Howlett
Back in March I updated you all on how my on-going quest for the perfect desk was coming along. Here now is another update. Question: Can you ever have too many monitors or enough "real estate" desktop size? Answer: No! Here's how my desk looks now: From left to right, there's a (newly-added) Dell U2713H (showing OS X), a Dell U2711 and a Samsung SyncMaster 245B (both showing the same Windows 7 PC). All in there are 9,676,800 pixels glaring back at me!! Aside from adding a brand new monito [read] Keywords: desktop mac
75


Recovering a Laptop After Forgetting Windows and BIOS Password | Blog
Wed, Dec 4th 2013 3:10a   Jake Howlett
My sis-in-law loves a bargain (she's from Yorkshire!) and recently rang to ask me (via her sister, my wife) if I'd be able to recover a laptop she'd been offered, before she went ahead and bought it. Apparently the owner of the laptop had forgotten the Windows password and had written the laptop off as worthless, so was willing to sell for next-to-nothing. I said yes, I'd able to do something with it. What I didn't realise was that it might have a BIOS password, which it did! Initially I' [read] Keywords: google laptop password
55


Rockall Design Now in its 11th Year! | Blog
Fri, Nov 1st 2013 4:00a   Jake Howlett
Rockall Design ltd (the little company I run from the office-slash-garage in my garden) was 10 years old yesterday. It's customary on this day each year that I plot a chart of turnover growth over the years. So, here it is: As you can see it's been a bumper year. Last year I put down what, at the time, I thought was a good year to: Long hours and 'hard' work. But mainly luck! This year is much the same. Although, if I thought I was doing long hours back then I had no idea what was in stor [read] Keywords: domino lotus microsoft office
92


Using Font Awesome Icons in Fireworks | Blog
Mon, Oct 14th 2013 4:00a   Jake Howlett
The font-based web icons from Font Awesome is brilliant. Especially when used in conjunction with Bootstrap. You can quickly and easily add any one of the icons to your HTML buttons (or many other elements for that matter). Like so: Sometimes though, you can't use web fonts. Either you can't rely on them being supported or, for some other reason, you just want to use an image file. That was the case for me recently and I wanted an image file of an exclamation mark. Here's how easy it was usi [read] Keywords:
247


Document Action Logs, Including "Limitless" User Comments | Blog
Wed, Sep 25th 2013 4:00a   Jake Howlett
Action Logs are something I'm sure we've all added to the bottom of a Domino web form. Here's an example of one I added to a recent Domino-based app I created and then wrapped with Bootstrap. The log is shown to the user as a three column table(when, who, what) with the latest action first. My approach to storing this data has always been to use a single multi-value text field. The value stored might look something like this:24/09/2013 17:08:12^^24 Sep '13^^17:08^^Joe Bloggs/ROCKALL^^Docum [read] Keywords: admin agent domino lotusscript ajax css email




111


Bootstrap Advanced Date Picker Plugin | Blog
Fri, Sep 6th 2013 4:00a   Jake Howlett
For some time now I've been creating date fields in Bootstrap-based websites that look like this: Clicking either in the field or on the button next to it launches a date-picker, like this: In the Notes Form the Date Field is configured in such a way that it accepts dates in the format 12-Dec-2009 (while storing them in normal Notes DateTime format of course). The field properties are like so: It all works well and users like them. Not least because there's no confusion over whether it' [read] Keywords: domino notes application javascript properties
35


Quick Tip: Login To Same Site as Two Different Users | Blog
Tue, Aug 20th 2013 12:00p   Jake Howlett
Here's a tip I discovered kind of by accident in one of those "I wonder if" moments. It came about after discovering a Fiddler tip that lets you trace localhost http traffic. The solution is simple: you simply add a trailing space, so that you surf to http://localhost./ At first I'd assumed that this was some odd quirk in the way browsers handled host names. Turns out it's actually working the way it should. Technically speaking all FQDNs should have a trailing space, in order to make them [read] Keywords:
62


How To: Virgin Media + BT Infinity = Reliable Internet Connection? | Blog
Mon, Aug 12th 2013 4:03a   Jake Howlett
The quest for an always-on internet connection is almost at an end! As if to assure me it was worth it, within 24 hours of Virgin Media connecting my secondary (failover) broadband connection the "primary" BT line went down. Again. For the third time in as many months. This time, however, I was prepared and had a backup connection and could carry on working. The BT engineer that came this time was very helpful. Bordering on apologetic for the fact I'd had so many visits of late. So much so he [read] Keywords: admin agent email interface wifi
40


Modern Day Communication Reliability | Blog
Thu, Aug 8th 2013 4:09a   Jake Howlett
Two weeks ago today I mentioned that I'd ordered a Virgin Media cable internet connection as a redundant 2nd connection in case my first goes down. Today the engineer is due to come and connect me up. Yep, a two week wait to get connected. Luckily I'm already on the internet, otherwise there's not a chance I'd ever wait that long. Anyway, I booked a date and the AM time slot for the visit and went about "waiting". Then, yesterday I got the message below: Which sent my overly-paranoid an [read] Keywords: twitter




Created and Maintained by Yancy Lent - About - Blog Submission - Suggestions - Change Log - Blog Widget - Advertising - Mobile Edition