Styjun

Withdrew when Jimmy met up with Heath

How many different ways are there to checkmate in the early game?

How does "Te vas a cansar" mean "You're going to get tired"?

What does Apple mean by "This may decrease battery life"?

What are the advantages and disadvantages of Wand of Cure Light Wounds and Wand of Infernal Healing compared to each other?

Plausibility of Ice Eaters in the Arctic

Write an interpreter for *

Trying to write a shell script that keeps testing a server remotely, but it keeps falling in else statement when I logout

Why does Intel's Haswell chip allow FP multiplication to be twice as fast as addition?

How can I iterate this process?

Is refreshing multiple times a test case for web applications?

English - Acceptable use of parentheses in an author's name

Extremely casual way to make requests to very close friends

changing number of arguments to a function in secondary evaluation

How can you evade tax by getting employment income just in equity, then using this equity as collateral to take out loan?

Why do funding agencies like the NSF not publish accepted grants?

Dropdowns & Chevrons for Right to Left languages

How to change a file name containing ":" in timing info

Ex-contractor published company source code and secrets online

Infeasibility in mathematical optimization models

Word or idiom defining something barely functional

Was the 2019 Lion King film made through motion capture?

Resonance and mesomeric effect

Christian apologetics regarding the killing of innocent children during the Genesis flood

Data Type issue while building notes database connections

Using a lotus script to change data in a field.Want the data to be multi linedlinking databases in lotus notesno duplication in database lotus noteDisplay image in notes form from another databaseCalling COM component method from IBM Notes 9 failsLotus Notes “MAILDOC type mismatch” error while debuggingSearching Lotus Notes DatabasesExport data from lotus notes database“Like” button for a database in Lotus NotesHow to check Purge Interval Replication Control of a database- lotus notes

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I fill the value of a specific notes document in a variable which has the data type VARIANT.

Reason: The value includes a backslash, letter and numbers.

Later in my code, I would like to build a database connections with this variable. Unfortunately it always fails with the following message:

Type mismatch in method CoerceString: Unkown found, Unkown expected

My code:

Dim varMailFile As Variant
Dim varMailServer As Variant
Dim maildb As New NotesDatabase( "", "" )
Dim cprofile As NotesDocument

vMailFile = doc.GetItemValue( "MailFile" )
vMailServer = doc.GetItemValue( "MailServer" )

Call maildb.Open(vMailServer, vMailFile)

I have already try to define the varMailFile and varMailServer as String, but it stilld doesnt work.
It makes also hard to troubleshoot, because the error message is not telling you what it found and what it expects.

I hope you can help me. Thanks.

lotus-notes lotus-domino lotusscript lotus

share|improve this question

edited Mar 27 at 12:07

Emba Bakar

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

add a comment | 

0

I fill the value of a specific notes document in a variable which has the data type VARIANT.

Reason: The value includes a backslash, letter and numbers.

Later in my code, I would like to build a database connections with this variable. Unfortunately it always fails with the following message:

Type mismatch in method CoerceString: Unkown found, Unkown expected

My code:

Dim varMailFile As Variant
Dim varMailServer As Variant
Dim maildb As New NotesDatabase( "", "" )
Dim cprofile As NotesDocument

vMailFile = doc.GetItemValue( "MailFile" )
vMailServer = doc.GetItemValue( "MailServer" )

Call maildb.Open(vMailServer, vMailFile)

I have already try to define the varMailFile and varMailServer as String, but it stilld doesnt work.
It makes also hard to troubleshoot, because the error message is not telling you what it found and what it expects.

I hope you can help me. Thanks.

lotus-notes lotus-domino lotusscript lotus

share|improve this question

edited Mar 27 at 12:07

Emba Bakar

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

add a comment | 

I fill the value of a specific notes document in a variable which has the data type VARIANT.

Reason: The value includes a backslash, letter and numbers.

Later in my code, I would like to build a database connections with this variable. Unfortunately it always fails with the following message:

Type mismatch in method CoerceString: Unkown found, Unkown expected

My code:

Dim varMailFile As Variant
Dim varMailServer As Variant
Dim maildb As New NotesDatabase( "", "" )
Dim cprofile As NotesDocument

vMailFile = doc.GetItemValue( "MailFile" )
vMailServer = doc.GetItemValue( "MailServer" )

Call maildb.Open(vMailServer, vMailFile)

I have already try to define the varMailFile and varMailServer as String, but it stilld doesnt work.
It makes also hard to troubleshoot, because the error message is not telling you what it found and what it expects.

I hope you can help me. Thanks.

lotus-notes lotus-domino lotusscript lotus

share|improve this question

edited Mar 27 at 12:07

Emba Bakar

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

Dim varMailFile As Variant
Dim varMailServer As Variant
Dim maildb As New NotesDatabase( "", "" )
Dim cprofile As NotesDocument

vMailFile = doc.GetItemValue( "MailFile" )
vMailServer = doc.GetItemValue( "MailServer" )

Call maildb.Open(vMailServer, vMailFile)

share|improve this question

edited Mar 27 at 12:07

Emba Bakar

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

share|improve this question

edited Mar 27 at 12:07

Emba Bakar

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

asked Mar 27 at 8:37

Emba BakarEmba Bakar

881010 bronze badges

1 Answer
1

active

oldest

votes

4

NotesDocument.GetItemValue always returns a variant, even if the item only contains one value. You need EITHER to assign the first value (Index = 0 because LotusScript is 0- based by default) to your variable or just use the first value in your call:

First possibility:

varMailFile = doc.GetItemValue( "MailFile" )(0)
varMailServer = doc.GetItemValue( "MailServer" )(0)
...
Call maildb.Open(varMailServer, varMailFile)

Second possibility

varMailFile = doc.GetItemValue( "MailFile" )
varMailServer = doc.GetItemValue( "MailServer" )
...
Call maildb.Open(varMailServer(0), varMailFile(0))

share|improve this answer

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  works great - Thank you Torsten!
  
  – Emba Bakar
  Mar 27 at 12:03
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55372842%2fdata-type-issue-while-building-notes-database-connections%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

4

NotesDocument.GetItemValue always returns a variant, even if the item only contains one value. You need EITHER to assign the first value (Index = 0 because LotusScript is 0- based by default) to your variable or just use the first value in your call:

First possibility:

varMailFile = doc.GetItemValue( "MailFile" )(0)
varMailServer = doc.GetItemValue( "MailServer" )(0)
...
Call maildb.Open(varMailServer, varMailFile)

Second possibility

varMailFile = doc.GetItemValue( "MailFile" )
varMailServer = doc.GetItemValue( "MailServer" )
...
Call maildb.Open(varMailServer(0), varMailFile(0))

share|improve this answer

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  works great - Thank you Torsten!
  
  – Emba Bakar
  Mar 27 at 12:03
  

  
  
  
  

add a comment | 

4

NotesDocument.GetItemValue always returns a variant, even if the item only contains one value. You need EITHER to assign the first value (Index = 0 because LotusScript is 0- based by default) to your variable or just use the first value in your call:

First possibility:

varMailFile = doc.GetItemValue( "MailFile" )(0)
varMailServer = doc.GetItemValue( "MailServer" )(0)
...
Call maildb.Open(varMailServer, varMailFile)

Second possibility

varMailFile = doc.GetItemValue( "MailFile" )
varMailServer = doc.GetItemValue( "MailServer" )
...
Call maildb.Open(varMailServer(0), varMailFile(0))

share|improve this answer

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  works great - Thank you Torsten!
  
  – Emba Bakar
  Mar 27 at 12:03
  

  
  
  
  

add a comment | 

NotesDocument.GetItemValue always returns a variant, even if the item only contains one value. You need EITHER to assign the first value (Index = 0 because LotusScript is 0- based by default) to your variable or just use the first value in your call:

First possibility:

varMailFile = doc.GetItemValue( "MailFile" )(0)
varMailServer = doc.GetItemValue( "MailServer" )(0)
...
Call maildb.Open(varMailServer, varMailFile)

Second possibility

varMailFile = doc.GetItemValue( "MailFile" )
varMailServer = doc.GetItemValue( "MailServer" )
...
Call maildb.Open(varMailServer(0), varMailFile(0))

share|improve this answer

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges

varMailFile = doc.GetItemValue( "MailFile" )(0)
varMailServer = doc.GetItemValue( "MailServer" )(0)
...
Call maildb.Open(varMailServer, varMailFile)

varMailFile = doc.GetItemValue( "MailFile" )
varMailServer = doc.GetItemValue( "MailServer" )
...
Call maildb.Open(varMailServer(0), varMailFile(0))

share|improve this answer

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges

answered Mar 27 at 9:54

Torsten LinkTorsten Link

8,8951212 silver badges3030 bronze badges