Genii Weblog


Civility in critiquing the ideas of others is no vice. Rudeness in defending your own ideas is no virtue.


Tue 30 Nov 2004, 11:44 PM
Mike MidasLuck be a Lady Tonight
by Mike Midas, Ace Developer

The low sexy voice came over the phone with the kind of invitation that grabbed you by the scruff of the neck and dragged you three thousand miles through the ether, no matter the consequences.  I'd never met the dame, but you could tell by her first words that I'd never walk by her in a crowd.


"Mr. Midas? This is Annika from Uppsala, Sweden, and I have a problem", she purred, and right then she could have asked for a light and the phone would have burst into flame faster than a cheap firecracker on a hot 4th of July.

"What can I do for you?", I asked, measuring the possibilities the way a jockey measures his steed.

"I work for Uppsala Exports, and we recently, uh, merged with a bigger firm."

The sudden chill in her voice made me want to pull on a sweater.  There was no mistaking the venom, and I realized there might be more to this tiger than pretty stripes.  I said nothing, and let her choose her words carefully.

"We used to use Lotus Notes for e-mail and applications", she started, and I knew by the catch in her throat that the parting wasn't her choice.  "Now, we have Outlook and Exchange", and again the tone gave away her secrets as easily as a diary left out on a high school desk.

I was ready to brush her off, since there is nothing worse than a whiny dame, but she went on and I listened.  My little black book wasn't so full that I was going to hang up on a voice like that without some hesitation.

"We have hundreds of applications written for Notes that use doclinks", she said, warming to the subject like butter on a hot stack of flapjacks.  "We thought we could just let Domino convert the links for us, but then we would still have to have Notes clients", and I hardly needed to hear the rest.  "We can keep a Domino server or two for applications, but the Notes clients have to go, and fast."  And there it was.  The naked pleading in her voice would have gotten you arrested in some Middle Eastern countries.  "So, we thought maybe we could use your Midas products to modify the applications and make them send out web URL's instead.  The applications are mostly ready for web access, so we just have to modify the code, and there are way too many to modify by hand."  Her voice drifted on, but I didn't hear most of it.

They say that life takes some crazy turns, sometimes leaving you to meander down a quiet lane with white picket fences and two fresh faced kids in every yard, then just when you get comfortable, shifting gears and sending you spinning down a steep mountain road where you have to hug the side like a distant aunt at Easter.  But seldom had I a hit a hairpin turn like this, with two wheels off the ground and my entire life set up on double reels for a twilight showing if I made a wrong turn.

"You want Midas for that?", I gasped, reeling at the thought and grabbing a shot glass and a bottle from my bottom drawer. "Midas is good for a lot of things, but look, lady, you can't go around modifying whole applications like some teenage stunt driver rearranging his face with the road."

"But I thought Midas would let me modify design elements?" she stammered, and I could feel her withdrawing like the last few bucks from my bank account on the Thursday after payday.

"Yeah, you can add some fields to a form or create an image resource or even build a page element, but this?  This?...", and I couldn't even go on.  I waited for the click as she hung up the phone on my dreams, but the sound I heard wasn't what I expected.

"I'll handle this." came the voice, hard and smooth as a fist of iron in a velvet glove.  My colleague, Crystal, took the phone from my trembling fingers, and took charge like Bobby Knight in a Hoosier play-off. "You don't need Midas, miss, but we do have a solution." she spat out, and the edge in her voice belied any chance of argument.  "You need our CoexLinks product.  It can convert doclinks to web URLs or Notes URLs, or even different types of URLs for different databases."

As Crystal walked out of the room, leaving me shattered and bruised with my ego deflated like a tire on broken glass, I could hear her going on about CoexLinks allowing a company to migrate applications to the web slowly, and the dynamic nature of the URL links.  I shut it all out.  The train may have left the station, but I didn't have to weep and wave.

Copyright © 2004 Genii Software Ltd.

Tue 30 Nov 2004, 09:18 AM
I am just having too much fun with the new (soon to be released) universal @DbLookup.  To give you an idea of the flexibility, here are a few formulas.  See if you can figure out what they do, and why they would be used, then click on the answer to see how close you came:

@DbLookup("Midas":"NoCache"; ""; @DocumentUniqueID; "Body":"Paragraph  *"; "Bullet"; "Text"; "KeyProperty=ParagraphStyle KeyMatch=Substr");

Answer

width := @Sum(@DbColumn("Midas":"NoCache"; ""; @DocumentUniqueID; "Body":"Graphic *"; "GraphicWidth"; "Format=Number"));

Answer

filesize := @Sum(@DbLookup("Midas":"NoCache"; ""; @DocumentUniqueID; "Body":"File *"; ".doc"; "FileSize"; "Format=Number KeyProperty=OriginalFileName KeyMatch=Ends "));

Answer

@DbColumn("Midas":"NoCache"; ""; @DocumentUniqueID; "Body":"Section  *");

Answer

anchors := @DbColumn("Midas":"NoCache"; ""; @DocumentUniqueID; "Body":"Anchor  *"; "AnchorText");
@If (anchors != ""; "["+@Implode(("<a href=\"#"+@ReplaceSubstring(anchors; " "; "%20"))+(("\">"+anchors)+"<a>"); "<br>")+"]"; "")

Answer

Copyright © 2004 Genii Software Ltd.