Note 14. A very beautiful table border settings: <td width= "28%" style= border-right: #000000 1px solid; Border-top: #000000 1px solid; Border-left: #000000 1px solid; Border-bottom: #000000 1px solid ">
15. To achieve the printing function of the page: <input name= "imageonclick=" Document.execcommand (' print ', ' true ', ' true ') "Type=image onclick=" Document.execcommand (' print ', ' true ', ' true ') ' value= ' print ' src=http://www.163design.net/a/y/' images/printpage.gif ' Width= "height=" >
16. Implementation of the page save function: <input name= "imageonclick=" Document.execcommand (' SaveAs ', ' true ', '. htm ') ' "Type=image onclick=" Document.execcommand (' SaveAs ', ' true ', '. htm ') ' value= ' save ' src=http://www.163design.net/a/y/' images/saveas.gif ' Width= "height=" >
The 17.SELECT keyword enables users to query all data for a specified field in a data table, but this sometimes makes it inevitable that duplicate information appears. You can use the DISTINCT keyword in the SQL language if you want to query only for information that has a different record value. The syntax format is as follows:
Select DISTINCT "column_name" from "table_name"
18. Display the result for each front small black dot:
<OL>
<LI> This web site uses Active Server Pages.
<LI> This web site uses advanced HTML tags.
<LI> This web site contains no <BLINK> blinking </BLINK> text.
</OL>
19. Displays the result to 3 items currently have 1,2,3 respectively
<ol type=i>
<LI> Makeup and scripting Languages
<ol type=1>
<LI> Basic HTML
<LI> Intermediate HTML
<LI> Advanced HTML
</OL>
</OL>
Nesting of sequence tables, type indicates the use of that sequence, such as I, 1,a,a
In some cases, you may want to cancel some numbers at the beginning of the list or somewhere in the list, and by using the start attribute of the <OL> identifier, you can specify the first number in the list; You can omit a range of numbers by using the <LI> Value property. The following examples use these two identifiers:
<BODY>
<ol type=a start=3>
<LI> I Display the letter ' C '.
<li value=6> I Display the letter ' F '.
</OL>
</BODY>
20. Define the use of the list
<DL>
<DT> Inveigle
<DD> to entice or lure by artful talk.
<DT> Frisson
<DD> A Brief moment of emotional excitement:shudder,thrill.
</DL>
Unlike other lists, the definition list uses three identifiers:<dl> identifiers that contain a definition list,<dt> identifies the word to be defined, while <DD> specifies the word definition.
21. Open a database with a password
Connstr= "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data source=" & Server.MapPath ("Db1.mdb") &_
"Jet oledb:database password=gzlong" & Password
22. Implemented a file containing a virtual directory:<!--#include virtual= "/asptest/subdbtable.inc"-->
23.Insert into Oldorder (Num,date,amount)
Select Num,date,amount
From order
Where date< ' 30-12-98 '
Description: The statement identifies the table Oldorder that receives the new row and the column that receives the data, exactly like a single line Insert statement. The remainder of the statement is a query that retrieves the data in the order table. SQL executes the query on the order table first, and then inserts the query results into the Oldorder table line by row.
The 24.Update statement always contains the where statement, and the UPDATE statement is dangerous, so you must explicitly recognize the importance of the where statement, where the statement is used to specify the rows that need to be updated.
Standard syntax:
UPDATE table_name
SET columnname1 = value1
[, columname2 = value2] ...
WHERE search_condition
Update Customers
Set credit=200000.00,state=021
Where ID in (80,90,100,120)
We can see that the process of SQL processing update statements is to iterate through the specified table, update the rows whose search criteria result is true, and skip rows whose search condition results in false or empty
The Delete from order Where id=99.
CREATE TABLE BILLS
(NAME CHAR (30),
AMOUNT number,
ACCOUNT_ID number)
Implement the ability to create a table
28. Delete Table if you feel you no longer need to save the product information, you can remove the table and all the data it contains from the database by using the Drop table statement.
Standard syntax:
DROP TABLE table_name
29.<p align= "center" > User name <input type= "text" name= "username" onkeypress= "if (Event.keycode > && Event.keycode < 48) | | (Event.keycode > && event.keycode < 65) | | (Event.keycode > && event.keycode < 97)) Event.returnvalue = false; "size=" class= "Input" >
I can't remember what I realized ... Hehe ... It seems to be only valid input of numbers and letters!
30. Definition of mouse style: Style=cursor:hand
31. With the completion of the function is as follows: Click a picture in a window, pop-up a window, when changing the new window of the picture, the original window of the picture, along with the changes. Registration is commonly used to select the Avatar Function!
###### #弹出窗口的部分程序 ###########
<script>
Window.focus ()
function Chg (URL)
{
Window.opener.document.form1.face.value=url;
Window.opener.document.form1.faceimg.src=url;
}
</script>
<%
For I=1 to 9
Response.Write " "
Next
For i=10 to 13
Response.Write "
