Rachel, 

When you dim a variable in VBS, it's a Variant by default. Consequently, your
statement - dim fieldlist(1) - dimensions a 2 element array of Variants. When
you assign values to these elements, they are not explicitly Longs or Ints or
Strings, which the library may be expecting, but Variants. Use the conversion
functions CLng, CInt, CStr, etc.  to give the Variants an explicit datatype
that matches what the library expects.

For example:

     dim fieldlist(1)
     fieldlist(0)=CLng("600004500")
     fieldlist(1)=CLng("600006400")

This ought to clear up the problem.

Chris Woyton


Rachel Harding <[EMAIL PROTECTED]> wrote:

 Hi,
 Can someone please explain to me how I can retreive a list of records 
 field values from a remedy database using the COM/.NET api in an ASP? (not 
 aspnet)
 It is actually very simple in asp.net, but eludes me completely when using 
 classic ASP.
 
 I have tried the following which always returns a type mismatch:
 
 Dim entryfieldValueList
 Set entryfieldValueList = Server.CreateObject
 ("BMC.ARSystem.EntryFieldValueList")
     
     dim fieldlist(1)
     fieldlist(0)=600004500
     fieldlist(1)=600006400
     entryfieldValueList2 = arserver.GetListEntryWithFields
 ("PEOPLE", "'Personnel ID' LIKE ""123%""", fieldlist, 0, 0)
 
 I cannot find the sample asp page mentioned on the remedy COM & .NET API 
 articles.
 
 What am I doing wrong?
 
 Thanks in advance
 Rachel
 
 _______________________________________________________________________________
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 

_________________________________________________________
This mail sent using V-webmail - http://www.v-webmail.org

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Reply via email to