Topic awaiting preservation: ASP Response.write/execute

i am generating a page out of a db when i use response.write i can read out the html if i use execute it will do me the asp how can i combine them so it does both asp and html? (probably a simple answer but i dont know it)

it is unclear what you're trying to do...can you please show an example of the desired output ?

well i want do generate the sites out of a db well say a complete newsscript in the db and then read it out but asp wil not output html and asp lets say i have the news in a table response.write will give me the table and execute will give me the news but i need something to output asp and html ..clearer now ?

well, i still don't get you...ASP and DB will get you what you want.

here's a sample code:

<table>

<%

q = "select * from mytable";

Rec.Open(q, DBCon);

while (!Rec.Eof)

{

%>

  <tr>

    <td width="19%">

      <%=Rec("cn")%>

    </td>

    <td width="19%">&nbsp;

      <%=Rec("cname")%>

    </td>

    <td width="20%">&nbsp;

      <%=Rec("tduration")%>

    </td>

    <td width="5%">&nbsp;

      <%=Rec("tcost")%>

    </td>

  </tr>

<%

}

%>

</table>

well the problem is when i do it the way you wrote is that it wont execute the asp scrips

could it be that i use adodb and a dns to connect to the DB???



[This message has been edited by Blacknight (edited 09-14-2002).]