Home > Domino Tips > Developer > JavaScript > @DBColumn and @DBLookup for all browsers using Ajax
Domino Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

JAVASCRIPT

@DBColumn and @DBLookup for all browsers using Ajax


Rishikesh Sahi
09.18.2005
Rating: -4.05- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


This generic code can be used to perform @DBColumn and @DBLookup using Ajax (Asynchronous JavaScript and XML) in all browsers. It's perfectly tested on Mozilla, Netscape and of course Internet Explorer. And it's easy to use without changing any line from the code.

Steps to use:

  1. Make your first column categarized in view (which you wana use for dbcolumn and dblookup).

  2. Assume you have to combo on form. So, call function Dbcolumn on OnLoad of the form:

  3. When you select any option from combo1 then its respective value should come in second combo. So, call dblookup function on OnChange of first combo:

The last parameter in both functions is comboBox name object, which is on your form used to display options.

MEMBER FEEDBACK TO THIS TIP

If you run this script on a server using a fully qualified hostname (like http://www.myserver.com) as server it won't work and will create a security issue in both IE and Firefox, r...


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
JavaScript
Trap JavaScript runtime errors in Domino Web apps
JavaScript workaround fixes Lotus Notes 8.x PostOpen event issue
Write HTML and JavaScript in Notes view rows and columns on the Web
JavaScript detects Web browser type and version in Notes/Domino 8.0.2
JavaScript creates a jump box on a Lotus Notes Web form
How to create dynamic JavaScript in Notes Domino without formulas
Trap an attachment path via the Domino file upload control field
Converting Lotus Notes views to XML documents using JavaScript
Prevent errors on iFramed pages with JavaScript
How to add keyboard functionality for Lotus Notes documents

Ajax for Lotus Notes Domino
Display SharePoint data in a Lotus Notes Web application with Ajax
Top 10 Lotus Notes Domino programming and development tips of 2007
Ajax for Lotus Notes Domino
Editing fields in a Lotus Notes view with Ajax
Ajax code equivalent of the @DBColumn formula for Lotus Notes
A bevy of Notes/Domino development tips
A smorgasbord of Notes/Domino development tips
Latest Ajax tools from Nexaweb target SOA, Web 2.0
Delete documents over the Web using Ajax and JavaScript
Ajax threats worry researchers

JavaScript for Lotus Notes Domino
Trap JavaScript runtime errors in Domino Web apps
JavaScript workaround fixes Lotus Notes 8.x PostOpen event issue
Write HTML and JavaScript in Notes view rows and columns on the Web
JavaScript detects Web browser type and version in Notes/Domino 8.0.2
JavaScript creates a jump box on a Lotus Notes Web form
Top 10 Lotus Notes/Domino coding and development tips of 2008
How to create dynamic JavaScript in Notes Domino without formulas
Trap an attachment path via the Domino file upload control field
Converting Lotus Notes views to XML documents using JavaScript
Mimic Lotus Notes Domino application functionality on the Web

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


esulting in a Javascript security error.

To have it works with a fully qualified hostname, the two lines

must be changed to:

—Renaud T.

******************************************

To allow this function to lookup multi-value fields from views, simply change the following function from this: to this:

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip exchange by member Rishikesh Sahi. Please let others know how useful it is via the rating scale at the end of the tip. Do you have a useful Notes/Domino tip or code to share? Submit it to our bimonthly tip contest and you could win a prize and a spot in our Hall of Fame.

Rate this Tip
To rate tips, you must be a member of SearchDomino.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Domino & Lotus Notes Security Solutions: Authentication, Antispam, Encryption and Antivirus
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts