complex dataview filters

[Guest]

Hey guys,
I've never seen a dataview.rowFilter 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]]

Hi,

It is to complex for the rowfilter.

Ken
------------------------
Hey guys,
I've never seen a dataview.rowFilter 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]

Mkiger,

rowFilter = "authorid in (select userid from users where accountid = " &
intUserid & ")".

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