Hi
I have written a Cache WebService with various methods and a query (below).
Testing all the WebMethods works fine from the testing page.
When I reference the webservice from a .Net Windows Application, it works
fine and return the dataset with data. My problem is when running exactly
the same code from a .Net WebForm. It returns the Dataset, but the dataset
has no rows in.
Has anyone have this problem before?
Thanks
Jacques
/// Search for a user(s) by User Id and/or User Name
Query SearchUsers(UserName As %String, UserID As %String) As
%SQLQuery(CONTAINID = 1) [ WebMethod ]
{SELECT * FROM HSTCognosUser
WHERE (UserName %STARTSWITH :UserName AND UserID %STARTSWITH :UserID)
ORDER BY UserName,UserID}
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim UserName As String = "J"
Dim UserId As String = "J"
Dim ws As New UserService.UserService()
Dim dt As DataTable = ws.SearchUsers(UserName, UserId).Tables(0)
Dim dr() As DataRow = dt.Select()
Dim i As Integer
Label1.Text = dt.Rows.Count
Label2.Text = dr.GetLowerBound(0) & "-->" & dr.GetUpperBound(0)
For i = dr.GetLowerBound(0) To dr.GetUpperBound(0)
Label3.Text += i & dr(i)(0) & dr(i)(1) & dr(i)(2) & dr(i)(3)
Next i
End Sub
