I use print function

<input type=button value=Print onClick="print()" id=button1 name=button1>

but it is only print two columns with respect to width of column,


how can print the following query records by the ASP ?
how can print full record which is retrieve by the query in ASP ?

i.e

<%
ssql=”select * from software order by manufacturer”

set rs=cn.Execute(ssql)

do while rs.eof=false

Response.Write("<tr>")

fieldData = rs("manuf") & ""
If Len(fieldData) = 0 Then fieldData = " - "
Response.Write("<td align=center>" & fieldData & "</td>")

fieldData = rs("software") & ""
If Len(fieldData) = 0 Then fieldData = " - "
Response.Write("<td align=center>" & fieldData & "</td>")

fieldData = rs("sofcd") & ""
If Len(fieldData) = 0 Then fieldData = " - "
Response.Write("<td align=center>" & fieldData & "</td>")

fieldData = rs("version") & ""
If Len(fieldData) = 0 Then fieldData = " - "
Response.Write("<td align=center>" & fieldData & "</td>")

fieldData = rs("vendor") & ""
If Len(fieldData) = 0 Then fieldData = " - "
Response.Write("<td align=center>" & fieldData & "</td>")

rs.movenext
loop
%>

Mateen

How is your table defined? If its a set width in pixels it may be that some columns are outside the page width, so they get clipped. Try using a proportonal width, like <table width="85%">.

Also, don't you need Response.Write("</tr>") before rs.movenext?

This is more of an HTML question than a SQL Server one.

thanks