Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: SQL2K & Workflow Problem


Message #1 by "Knight Chang" <cs871269@c...> on Sun, 12 May 2002 05:46:41
Hello.
I have build a workflow application on SQL2k using office xp developer.
when i try to insert a record into sql and update some fields in the 
workflow(session.item & session.item.updatebatch). I always get an error
msg. If i mark this update script in the workflow and only addnew & update
in the ASP, it works. My scripts are as follow
in ASP:
rsADO.CursorType = 1
rsADO.LockType = 4

rsADO.AddNew
rsADO("blah") = "blah"
rsADO.UpdateBatch

in SQL Workflow Action script:
Session.Item("blah") = "blah2"
Session.Item.UpdateBatch

  Return to Index