Link to home
Start Free TrialLog in
Avatar of sl1nger
sl1nger

asked on

error 8002009 - type mismatch

Here's my code....

                     dim oWebi
      dim objXML
      dim rs
      
      set oWebi = server.CreateObject("Webi.bWebi")
      set rs = oWebi.AddNewRegistrant
      set objXML = server.CreateObject("MSXML.DOMDocument")
      objXML.async = false
      objXML.load request
      rs.fields("webi_id") = clng(Request.QueryString("id"))
      rs.fields("first_name") = objXML.selectSingleNode("//first_name").text
      rs.fields("last_name") = objXML.selectSingleNode("//last_name").text
      rs.fields("email") = objXML.selectSingleNode("//email").text
      rs.update
      oWebi.SaveRegistrant(rs)
      Response.Write true      

It was working...  I get an mismatch error 8002009  on this line oWebi.SaveRegistrant(rs)
Avatar of ddrudik
ddrudik
Flag of United States of America image

I assume you are using BusinessObjects, but that's just a guess since you didn't specify what "Webi.bWebi" is.  You may want to cross-post this in the Business Objects forum and if that fails to receive the desired result then post a question to their message boards:
http://www.forumtopics.com/busobj/viewforum.php?f=40

Unfortunately I have no other tips to share about using Webi.
Avatar of Member_2_3718378
Member_2_3718378

sl1nger --

Can you write the contents of those values to the screen before you try calling oWebi.SaveRegistrants(rs), and post back here what they are?

=========================================
'...
Response.Write "<br>" & vbNewLine
Response.Write Request.QueryString("id") & "<br>" & vbNewLine
Response.Write objXML.selectSingleNode("//first_name").text & "<br>" & vbNewLine
Response.Write objXML.selectSingleNode("//last_name").text & "<br>" & vbNewLine
Response.Write objXML.selectSingleNode("//email").text & "<br>" & vbNewLine
'...
=========================================


-= DeathToSpam =-
Avatar of sl1nger

ASKER


sure death to spam..

Error message:

Error(s) occurred during the save of the registrant.<br>
21<br>
Mark<br>
Tester<br>
MarkTester@test.com<br>
True
Avatar of sl1nger

ASKER

Will to be exact...

Error(s) occurred during the save of the registrant.
<br>
21<br>
Mark<br>
Tester<br>
MarkTester@test.com<br>
True
Sorry, been afk for the past week.  Will try getting back to you tomorrow...

-= DTS =-
Avatar of sl1nger

ASKER

What do you think?
ASKER CERTIFIED SOLUTION
Avatar of Member_2_3718378
Member_2_3718378

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sl1nger

ASKER

This helped me work with it.
Glad to be of (some) help.  :)


-= DTS =-