Domino Upgrade

VersionSupport end
5.0
6.0
6.5
7.0
Upgrade to 8.5x now!
(see the full Lotus lifcyle) To make your upgrade a success use the Upgrade Cheat Sheet. Contemplating to replace Notes? You have to read this!

Search

Reference

1. Learn XPages online
2. Communicate with IBMers and Lotus Experts using Sametime

About Me

I am the "IBM Collaboration & Productivity Advisor" for IBM Asia Pacific. I'm based in Singapore.
Reach out to me via:
Follow notessensei on Twitter
(posts)
Skype
Sametime
IBM
Facebook
LinkedIn
XING
Amazon Store
Amazon Kindle

Mobile tag

Twitter

Languages

Other languages on request.

Visitors

Useful Tools

Get Firefox
Use OpenDNS
The support for Windows XP is coming to an end and has . Time to consider an alternative to move on. sounds like a lot of time, but, like an object in a mirror, it is closer than you think.

« When licensing gets in the way of sales and revenue what will happen? | Main| doc.ComputeWithForm Revisited »

One more reason to build Domino applications

Catching up on my blog reading I checked the http://www.joelonsoftware.com/items/2006/11/01.html on Joel on Software. Joel explains what an SQL injection bug is and how vulnerable a lot of sites are to that. An upcoming report from Mitre (cited here and here) claims that SQL injection and cross site scripting are rapidly becoming the attack vector #1 replacing buffer overflows as prevalent security hole. Joel had posted a solution how to avoid that quite a while ago. However this coding style doesn't seem to be too wide spread.
Of course you can use Domino for your web application and don't bother about SQL or if you can't live without SQL let DECS and LEI do the heavy lifting instead of "cleanscrubbing" your strings yourself.

Comments

Gravatar Image1 - There are many times I wish that Domino has a built-in SQL interface for making my life easier when writing reports, but I am willing to do a little extra work to not have to deal with the SQL hacking that is prevalent throughout the internet.

Sean---

Gravatar Image2 - Sean,
you have a couple of options for reporting:
- NotesSQL (co-production of Lotus and Crystal Reports) which turns Domino into an SQL datasource
- DXL, XSLT, XSL/FO (get a good tool for writing that)
- DB/2 integration in R7
- DECS/LEI for the others
- HTML in Domino (play with the content type to load it to Excel)
- I think there is a data provider for Eclipse Birt
- a bunch of commercial products

Of course: a well designed Notes apps hardly needs reports (once you get that idea out of the heads of the users). We had that before :
http://www.wissel.net/blog/d6plinks/SHWL-5QB3TN
stw

Gravatar Image3 - I've done most of the above, with the exception of the DXL and Db2 stuff. And I know it keeps me employed that I know how to get the data out of Notes in just the right way, but it would sure be nice to be able to do a join and use the order by. Heck, I'd love to just be able to pass a value to get a sorted document collection. Something like dc.sort("duedate", 1) would be a wonderful thing, instead I have to figure out how to do it on my own.

Sean---

Post A Comment

Please note: Comments without a valid and working eMail address will be removed. This is my site, so I decide what stays here and what goes.

:-D:-o:-p:-x:-(:-):-\:angry::cool::cry::emb::grin::huh::laugh::rolleyes:;-)

Disclaimer

This site is in no way affiliated, endorsed, sanctioned, supported, nor enlightened by Lotus Software nor IBM Corporation. I may be an employee, but the opinions, theories, facts, etc. presented here are my own and are in now way given in any official capacity. In short, these are my words and this is my site, not IBM's - and don't even begin to think otherwise. (Disclaimer shamelessly plugged from Rocky Oliver)
© 2003 - 2012 Stephan H. Wissel - all rights reserved as listed here: Creative Commons License
Unless otherwise labeled by its originating author, the content found on this site is made available under the terms of an Attribution/NonCommercial/ShareAlike Creative Commons License, with the exception that no rights are granted -- since they are not mine to grant -- in any logo, graphic design, trademarks or trade names of any type.