Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Distinct result based on only 1 field column
I have 2 tables: - TableOne has fields A,B,C,D,E - TableTwo has fields B,F,G,H,I,J User will provide input parameter '@InputParameter' (i.e. field A in TableOne) into TableOne, then need to lookup the B value in TableOne. With the B value found in TableOne, need to display TableTwo fields... -
Newbie: SQL query to perform searches on multiple fields
This is my code so far: SELECT [Person].* FROM [Person] WHERE (@Title IS NULL OR [Person].[Title] = @Title) AND (@Family_Name IS NULL OR [Person].[Family_Name] = @Family_Name) AND (@Given_Name IS NULL OR [Person].[Given_Name] = @Given_Name) AND (@City IS NULL OR [Person].[City] = @City) -
Newbie: SQL query to perform searches on multiple fields
I am trying to produce a search form that allows the user to enter up to 4 fields, namely: Title, First Name, Last Name and City Scenarios: - if the user only enter the title (e.g. Mr) and leave all other fields blank, then the result should return all records for the Title = "Mr" - if the... -
Create Notes email from Notes document fields
Trying to have a script(using formula or lotus script) that will compose an email when user clicks on a button/link in 'Notes client' after opening a notes document. The email should pop-up giving the user the "opportunity to edit the email" before clicking the Send button to send...- NotesUser
- Thread
- Replies: 0
- Forum: E-Mail issues
-
Online (CBT) Upgrade R6 Application Course...
Any ideas where I could get CBT material for the Upgrade R6 Application Development course for Lotus Notes/Domino?- NotesUser
- Thread
- Replies: 1
- Forum: Technical certification and testing
