In infopath saving to a SQL database using a stored procedure

S

SDecou

using this code behind the click event of a button I am receiving an error.
Does anyone see anything wrong with this code?

Dim CLEmpID
Dim CLClientMatter
CLEmpID=XDocument.DOM.selectSingleNode("//dfs:myFields//dfs:dataFields//d:OverTime//@EmpID").text
CLClientMatter=XDocument.DOM.selectSingleNode("//dfs:myFields//dfs:dataFields//d:OverTime//@ClientMatterNoBill").text

in vbscript what is the correct syntax when using the queryadapter?
XDocument.QueryAdapter.Command = "execute dbo.sp_insert_Overtime" clempid +
"'"
XDocument.Query()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing multiple parameters to stored procedure 4
Query Trouble - Need to return largest element from a column to one field 0
Building custom button. 11
InfoPath Execute Stored Procedure Error 5
store data returned from a sql query in jscript 0
Convert JSScript Example to VBScript 1
Retrieving OUTPUT parameter from Stored Procedure 2
running stored proc against db using script - issue 0

Top