I could be permission?
"JacquesWentworth" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
>
>
>
