complex dataview filters

[mkiger]

Hey guys,
I've never seen a dataview.rowFil ter example that was anything more than
something like "id = 100" or something like that. I'm trying to right one (in
asp.net/vb.net) that looks like this:
rowFilter = "authorid in (select userid from users where accountid = " &
intUserid & ")".
I'm getting an error that there is a missing operand following 'userid'
Is this just to complex for a rowFilter? I've never seen anything that said
so.
Any input would be greatly appreciated.

[Ken Tucker [MVP]]

Re: complex dataview filters

Hi,

It is to complex for the rowfilter.

Ken
------------------------
"mkiger" <mkiger@discuss ions.microsoft. com> wrote in message
news:F096DC62-19A4-44A1-9971-800C5A7B6762@mi crosoft.com...
Hey guys,
I've never seen a dataview.rowFil ter example that was anything more than
something like "id = 100" or something like that. I'm trying to right one
(in
asp.net/vb.net) that looks like this:
rowFilter = "authorid in (select userid from users where accountid = " &
intUserid & ")".
I'm getting an error that there is a missing operand following 'userid'
Is this just to complex for a rowFilter? I've never seen anything that said
so.
Any input would be greatly appreciated.

[Cor Ligthert]

Re: complex dataview filters

Mkiger,
[color=blue]
> rowFilter = "authorid in (select userid from users where accountid = " &
> intUserid & ")".[/color]

I try to understand what you want to say with this expression.

I am curious for that, can you say it in other words.

Cor