Best method to hide

[Jeff Uchtman]

What's the best method to hide, or not show a certain record when doing a
pull from a database, as in I am pulling a list with a dozen category's and
I don't what to show one of them.

Thanks
Jeff

[martin de vroom]

put a where clause in your db select statement to ensure the value you do
not want does not come back from the database in the first place.

alternatively

loop through your records.

if rs.("dbvalue") = "value to hide"
'dont show the value.
else
response.write('value is ' & rs.("dbvalue") )
end if

you could probabally do this more efficintly using getrosws. but best to
limit the rows at source with a where clause.

cheers

martin.

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:uN**************@TK2MSFTNGP10.phx.gbl...

What's the best method to hide, or not show a certain record when doing a
pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.

Thanks
Jeff

[Jeff Uchtman]

Clause worked great.

Thanks
Jeff
"martin de vroom" <ma***********@hotmail.com> wrote in message
news:eM**************@TK2MSFTNGP10.phx.gbl...

put a where clause in your db select statement to ensure the value you do
not want does not come back from the database in the first place.

alternatively

loop through your records.

if rs.("dbvalue") = "value to hide"
'dont show the value.
else
response.write('value is ' & rs.("dbvalue") )
end if

you could probabally do this more efficintly using getrosws. but best to
limit the rows at source with a where clause.

cheers

martin.

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:uN**************@TK2MSFTNGP10.phx.gbl...

What's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's

and

I don't what to show one of them.

Thanks
Jeff