This is just an ASP little skill. Although it is suitable for calling this function in different file names, it is also a prerequisite. Let's take a closer look at the original principles.
The following section shows the basic page
Code :
Set
"An example of randomly reading records from a databaseSet Rs1 = server. CreateObject ("adodb. recordset ")Set Rs = server. CreateObject ("ADODB. RECORDSET ")SQL = "Select id from Article order by id desc"Rs. Open SQL, dataconn, 3, 3If not rs. EOF
The data structure and the add page will not be written. The select statement will be released. % @ LANGUAGE =" VBSCRIPT "CODEPAGE =" 936 "%>Dim Recordset1Dim Recordset1_numRowsSet Recordset1 = Server. CreateObject ("ADODB. Recordset
ASP2HTML WITH TEMPLET
I hope that you can see this title to see its functions:
1. with templet means that a preset template will be used for the generated page architecture. I have introduced this in a previous tutorial, I hope you will be familiar
Let ASP match MySQL
The tools needed
Mysql-4.1.11-win32
Myodbc-3.51.11-1-dll
Myodbc-3.51.11-1-win
Mysqlcc-0.9.4-win32
-------------------------------------------------------------------
Registration file
Spent a little time to the previous Haiyang top 2006 of the SQL module to the VBS version, and its function is the same, but may not be used to use the ASP version of the comfortable, but can be used, can be used in the DOS, infiltrate the intranet
access|asp+| Data | database |ajax Tutorial
Examples of Ajax tutorials [Arisisi original]
In fact, the initial application of Ajax is very simple, popular is the client (JavaScript) and server (ASP or PHP, etc.) scripting language data interaction.
Dim Curpage
Curpage=cint (Request ("page")
If curpage = empty or curpageCurpage = 1
End If
Response.contenttype= "Application/xml"
response.charset= "gb2312"
Response.expires=0
Response.Write ("")
Dim rs,sql ' defines connection database objects
Set
1, with templet meaning is that the generated page schema will take a set of templates, which I introduced in a tutorial before, I hope you see this tutorial on the ASP template should be familiar with.2, ASP converted to HTML. Don't let me talk
Voting Batman translation Finishing
4. Document Default.asp
id = Request ("id")
If ID = "" Then
ID = 30
End If
Title = "Polls (Create your own poll)"
%>
asp polls
another Joint product from tipped Cow development and adrenalin labs
First use access to create a new database, named Luntan, the name of the datasheet is "information", establish the following fields: "Text", "name", "Time", and set the "time" default value to now ()
Set com = Server.CreateObject ("ADODB.")
server 1, ASP files:
' EXAMPLE as: Put a 24-hour online number in the database into an Excel file
' AUTHOR: Steel Workers
' Email:hello_hhb@21cn.com
' Date:2001-3-25
' Test: Testing through in Nt4,sp6,sql SERVER 7.0,excel2000
%>
Generate
Program | paging | performance
Sql= "Select ID from News order by ID Desc"Sqla= "Select title,filepath,filename from News where ID"sqlb= "ORDER by ID Desc"Rs. Open sql,conn,1,1Thepagecount=1Currentpage=1Topage=1If not Rs. Eof Then' #
Tree-type structure, tree structure -----------the [test] table to generate a script---------------
if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ Test] ') and OBJECTPROPERTY (ID, N ' isusertable ') = 1)
drop table [dbo]. [
Data | database
Before discussing the example, first understand the flash and ASP combination principle, actually understand a little ASP's friends know ASP is based on HTML. Flash and ASP interface principle and pure ASP file interaction principle
Advertisement second, management function
There are 12 ASP files in the Management Section, and the main functions of these scripts are as follows:
Banneradminlogin.asp: Login page for admin function. The default user name is "ADMIN user" and the
Data | database/Database Connection | database connection ASP connecting SQL Server2000 database routines
--------------------------------------------------------------------------------
Dim mode
Mode=request.form ("Text4")
If Mode=1
This is my own experience, for you to make a reference.My goal is to make development simple, consider the implementation statements as little as possible, and devote more effort to thinking about business logic. I hope my article will inspire and
Data | database | random "An example of a random reading of a record from a database
Set Rs1=server. CreateObject ("Adodb.recordset")
Set Rs=server. CreateObject ("ADODB.") RECORDSET ")
Sql= "Select ID from Article ORDER by id DESC"
Rs. Open
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.