ASP FAQs and Answers (10)

1. About <table> Folding line:
<table style= "table-layout:fixed" width= "border=" 0 "cellspacing=" 0 "cellpadding=" 7 "bgcolor=" #f7f7f7 ">
<tr>
&LT;TD style= "left:0px; width:100%; Word-wrap:break-word ">
Dffadfdaqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqsfdffadfdasfdffadfdasfdffadfdasfdffadfdasfdffadfdasfdffadfdasfdffad fdasfdffadfdasfdffadfdasf
</font></td>
</tr>
</table>
The point is "Word-wrap:break-word" to remove it and then see it.
2. Batch input in the application of the database is more extensive, on the volume of the method also has many kinds of input.
Below I combine my practical application, talk about how I realize.
The main use is the concept of the set of form, by looping through all the data in the collection.
Considering everyone's convenience, I integrated it into a page.
The following are the specific code:
Batchinput.asp
<%
'#####################################
' File Function: Batch input data
' Author:myhon
' Date:2003-8-19
'#####################################
' Write data to the database
SUB WriteData ()
Dim reccnt,i
Dim Fieldname1,fieldname2,fieldname3
Dim conn
Dim sqlstr,connstr
Connstr= "Provider=sqloledb.1;initial catalog=mydatabase;data Source=myhon; User Id=sa; Password= "
Set Conn=server.createobject ("ADODB. Connection ")
Conn.Open ConnStr ' Establish a database connection
Reccnt=request.form ("Stu_num"). Count ' Get a total number of records
' Batch input data
For I=1 to Reccnt
Fieldname1=trim (Request.Form ("fieldName1") (i))
Fieldname2=trim (Request.Form ("fieldName2") (i))
Fieldname3=trim (Request.Form ("FieldName3") (i))
Sqlstr= "INSERT into myTable (FIELDNAME1,FIELDNAME2,FIELDNAME3) VALUES ('"
Sqlstr=sqlstr & fieldName1 & "', '"
Sqlstr=sqlstr & fieldName2 & "', '"