problem with Redirect function

I am trying to use the resopnse.redirect function but I'm having a hard time.

I write "response.redirect URL" in the body of the asp page, and an error is recived:
"
Response object error 'ASP 0156 : 80004005'

Header Error

/tests/dbr/wr2.asp, line 31

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
"

If I put the redirect statment before the html tag it works, but I need it to execute after I do somethings in the body.

any ideas?



P.S
Does anybody know if I can get a list of the tables in a database after I opend a ADO connection? If its posible, than how?

At the top of your asp page put


This will buffer the html output until the asp side code completes or you do an explicit response.flush

OK, thanks, that worked.

But I realy wanted to know if their is a property in an ADO connection or anything else that enables to access a table in the database without knowing the table name, is their a collection that includes the names of the tables that are in the database?

thanks anyway, ben.

SQL Server supports the ANSI INFORMATION_SCHEMA to query the db structure. I think I read somewhere that INFORMATION_SCHEMA will work with an Access 2000 DB and ADO.

SELECT * FROM INFORMATION_SCHEMA.Tables

wow, if only i knew this sooner.

thanks,
Do you where I can find information on the INFORMATION_SCHEMA? to learn how to use it...

P.S.
is the INFORMATION_SCHEMA availble in asp or only asp.net?

The information_schema is built in to ms sql server. I'm pretty sure it's available with an access DB via OLEDB.

http://www.ocelot.ca/is.htm tells a bit more about information_schema. It's a database thing, not specific to asp/NET/php or any other language. DBMS's either do or don't provide the information_schema data.

what's DBMS?

OK, I didn't understand any of the tutorials i read on information_schema, and neither understod the tutorials on DBMS, but I found something that could be it,

Is the OpenSchema method in an ADO connection is the INFORMATION_SCHEMA?

I'm trying to work with it, but is it what you ment?

Nevermind, I did it, Thanks anyway........

DBMS = DataBase Management System