Stephan H Wissel needed to read HTML from a remote site and return a specific table for further processing. He didn't like the usual methods so he used an XPath parameter in LotusScript. He's included some code to help explain the process.
Stephan H Wissel needed to read HTML from a remote site and return a specific table for further processing. The usual answers to the problem weren't desirable so he used an XPath parameter in LotusScript. He's included some code to help explain the process.
WANT THE TOP LOTUS EXPERTS BY YOUR SIDE WITHOUT PAYING HEFTY CONSULTING FEES? LOOK NO FURTHER. Like having a team of consultants by your side -- ones who have all the answers and never make mistakes -- THE VIEW gives you immediate access to field-tested instruction, guidance, and best practices from the brightest Lotus professionals around.
While it's always a good idea to keep your SQL code separate to your C# code in ASP.NET there are times when you just want to do a quick query on a database without wanting to go about creating Stored Procedures or adding Queries to table adapters.
This happened to me in a current project which has a "admin portal", which has a "dashboard". The dashboard should show the status of the system - counts of new entries, unanswered support calls etc etc.
Assuming you have Table Adapters in place that connect you to the tables needed you can use LINQ to quickly get data from the database, like so:
ClaimsTableAdapter cta = new ClaimsTableAdapter(); //Total liability for approved claimsvar q1 = (from a in cta.GetData() where a.Approved && !a.Redeemed select a.Points).Sum().ToString(); //Claims logged in the last monthvar q2 = (from a in cta.GetData() where a.created >= DateTime.Now.AddMonths(-1) select a).Count().ToString();
Looks a bit like SQL doesn't it!? From what I've read on LINQ the idea is to give the power of SQL to developers who might not be up-to-scratch with SQL coding (err, a bit like myself).
Notice how I used the DateTime C# class to adjust a date and didn't need to remember how to do that in SQL code!
Until now I'd overlooked LINQ. Now I've seen how useful and quick it can be I plan on getting to know it in more depth. For this I'll be using LinqPad and have a the O'Reilly Pocket Reference on order.
Sami Salkosuo has contributed a new
project to OpenNTF - Command
Line EMail Client (direct
download). The Command Line EMail Client is a program
for reading and sending mail from the command line. The purpose of the
command line email client is to ...
This is a plea for you to transfer the Smartsuite read functionality from Symphony 1.3 into Symphony 3. This is most important to all SmartSuite users - of which I believe there are many, me amongst them .... To be honest I'm saddened it was removed as part of the upgrade from 1.3 to 3.
In September 2010, IBM removed the Sandbox from developerWorks Lotus. With that removal, they also broke countless forum responses that link to specific Sandbox files, as well as links from countless blogs and web sites all over the world.
There are two ways to fix this. Either put the Sandbox back to where it was before, and thereby restore all broken links. The other way is to put it on OpenNTF, and make sure that every link to the old Sandbox is properly redirected to the same document on OpenNTF.
There are still lots of useful code and examples in the Sandbox, for both new and experienced developers and administrators, even if it's several years old by now, and I fail to see a good reason to remove it.
For the time being, the Sandbox can be accessed on my site: http://www.bananahome.com/ldd/sandbox.nsf
In September 2010, IBM removed the Sandbox from developerWorks Lotus. With that removal, they also broke countless forum responses that link to specific Sandbox files, as well as links from countless blogs and web sites all over the world.
There are two ways to fix this. Either put the Sandbox back to where it was before, and thereby restore all broken links. The other way is to put it on OpenNTF, and make sure that every link to the old Sandbox is properly redirected to the same document on OpenNTF.
There are still lots of useful code and examples in the Sandbox, for both new and experienced developers and administrators, even if it's several years old by now, and I fail to see a good reason to remove it.
H1 Using HTC devices with Lotus Notes TravelerH1 Many people have reported various issues using newer HTC devices with Lotus Notes Traveler. The problems include data not syncing from the device to the server, device sync loops, and issues with install or uninstall of the Lotus Notes Traveler ...
If you don't see the Attach File icon in an email, calendar entry, to do item, or other Notes document, you can click the More Buttons icon in the Text Properties toolbar to see more text properties options. Notes Standard: Notes Basic:
Metadata is information that describes the characteristics of stored data. It can be used to organize and search emails, calendar entries, and other Notes documents. When you open a document, metadata is already captured in some fields and you can add information, such as keywords or a description ...
IBM Lotus Domino Server 8.5.2 Interim Fix 2 (852IF2) for W32/ Type: Incremental Installer / Release Date: 02 December 2010. See 'More Information' link above for additional information.
A button is a graphic that, when activated, launches an action. For example, you can send someone a document with a button in it that sends a reply back to you if the user clicks it. You must be in a richtext field (a field that allows text, objects, file attachments, and pictures) to create a ...
An action hotspot launches an action. It works like a button, but it looks like a link (has blue underlined text). For example, you can add an action hotspot in an email that will send an autoreply back to you. You can create a hotspot in emails, calendar entries, to do items, and other Notes ...
IBM Lotus Domino Server 8.5.2 Interim Fix 2 (852IF2) for zLinux64/ Type: Incremental Installer / Release Date: 02 December 2010. See 'More Information' link above for additional information.
IBM Lotus Domino Server 8.5.2 Interim Fix 2 (852IF2) for IBM i V5/ Type: Incremental Installer / Release Date: 02 December 2010. See 'More Information' link above for additional information.
IBM Lotus Domino Server 8.5.2 Interim Fix 2 (852IF2) for IBM i V6/ Type: Incremental Installer / Release Date: 02 December 2010. See 'More Information' link above for additional information.
The IBM Client for Smart Work solution includes open standardsbased email, productivity editors, real time communication, social computing and other software that can be used on a variety of netbooks, thin hardware clients, and desktopslaptops. The IBM Client for Smart Work offers a complete, ...