Tutorials | solutions | Getting Started | designing | questions
As Microsoft launched the Web page and database solution, ASP because of Microsoft's unique operating system and other technical backing support, so has been rapid development, and is receiving more and more welcome, in the current E-commerce site in the construction of a lot of the use of ASP to write programs.
Recently, many readers have consulted us about the methods of ASP and some problems encountered in learning, some of which are problems that beginners often encounter and face. In order to let the reader in the process of learning ASP to deepen the understanding of the ASP, and can effectively solve the problems encountered, we specifically collected some of the more representative of some of the problems, listed here and give answers to each, I hope in this limited space for you to learn ASP help.
1. Question: Is ASP a programming language?
A: ASP is not a programming language, but a development environment. ASP provides an environment for executing instructions on the server side, which utilizes special symbols () to differentiate between HTML and commands that must be translated by the server before being sent to the client. The instructions that it can execute include the HTML language, Microsoft VBScript, and Microsoft JScript, so you can create powerful Web applications.
2. Question: Can you use PWS for hosting multiple Web sites on a Web server?
A: Only one Web site can be accommodated on the PWS. To accommodate multiple Web sites on the same computer, you need to use Windows NT Server or Windows Server/professional and IIS.
3. Question: How to use 6 built-in ASP objects?
A: ASP provides a number of inline objects that can be accessed and used directly in instructions without having to be established, with the following six objects: Request object, Response (Response) object, Session object, application (application) object, Servers (server) objects, cookie objects, server objects in these six objects can load other components, which can extend the functionality of the ASP.
The object created by using Server.CreateObject, its lifecycle begins when it is established, and ends at the end of its web page program. If you want the object to be used across pages, you can use the session object to record the object that Server.CreateObject created.
4. Question: Why the following error occurred when using Response.Redirect: "Title error, HTTP headers have been written to the client browser, changes to any HTTP headers must be made before the page content is written"?
A: Response.Redirect can transfer the page to another page, using the syntax structure is this: Response.Redirect URL, where the URL can be a relative address or an absolute address, but in IIS4.0 use and in IIS5.0 use is different.
The IIS4.0 Transfer Web page must occur before any data is exported to the client browser, otherwise an error occurs. The so-called data here includes HTML labels, such as:< html>,< body>, which have been improved in IIS5.0, and the buffer is turned on by default in IIS5.0, and such errors are no longer generated.
There is a buffer property in the response object that can set whether the Web site will transfer data to the client immediately after processing the ASP, but setting this property must also precede the transfer of any data to the client.
For the sake of insurance, no matter what ASP platform to run, write <% response.buffer=true%> at the beginning of the page, set the buffer to open, such error will not happen.
5. Question: Does the buffer output have any effect on the transmission of the Web page?
A: In a larger web page, the first part may have some latency in the browser, but it is faster to load the entire Web page than not to buffer.
6. Question: Is it possible to use the Request.QueryString collection when the value of a query string is not submitted by a form?
A: The request object is used to read the browser's data, except that it can read the contents of the form field and can be used to read parameters that come with the URL, regardless of how the request string is added to the link address. You can use the Request.QueryString collection to submit a form using the Get method, or to follow all the values in the linked query string of an additional query string.
7, the problem: I wrote a lot of comments in the ASP script, this will affect the speed of the server processing ASP files?
A: In the process of writing a program, it is a good habit to make comments. After testing by foreign technicians, the overall performance of an ASP file with too many annotations will only drop by 0.1%, which means that the performance of the server is basically not felt in the actual application.
8. Question: Do you need to use <% @LANGUAGE =vbscript at the beginning of each ASP file?
A: At the beginning of each ASP file, use <% @LANGUAGE =vbscript%> code is used to inform the server to use VBScript now to write programs, but because the default program language of ASP is VBScript, so ignore this code can also run correctly, However, if the script language of the program is Javascrip, you need to indicate the scripting language used in the first line of the program.
9. Question: Is it necessary for me to use option Explicit in each ASP file?
A: In practice, the concept of VBScript variables is blurred, allowing direct use of variables without the dim declaration of variables, but this is not a good habit, it is easy to cause a program error, because it is possible to repeatedly define a variable. We can use the Option Explicit statement in a program so that when you use a variable, you must declare it, and if you use a variable that is not declared, the program will run into error.
It has been proved that using option Explicit in ASP files can minimize the chance of program error and greatly improve overall performance.
10. Question: What security measures are there when running ASP files?
A: ASP provides a good code protection mechanism, all ASP code is executed on the server side and only returned to the client code execution results. However, the malicious person does not rule out the deliberate destruction of the Web server, so you should pay more attention to security issues when writing ASP files.
Although the introduction of files in ASP as an extension of INC, ASP is still recommended as the extension of the primer file. When this code is running on a poorly secured Web server, you can browse the contents of the introduced file by simply entering the address of the address bar that introduces the file (inc), because on the Web server, if you do not have a dynamic connection library defined to resolve a type, such as Inc, The file is displayed in Source mode.
In addition, do not put the database files within the structure of the site, so that when the malicious person to obtain the database path, you can easily access the database, and then arbitrarily change the database content. It is a good practice to establish a data source name DSN (date source name) for the database, where information about connecting to the specified data provider is stored in the DSN, including: "The physical location of the database, the type of driver used to access the database, Any additional parameters required to access the database driver, which can be accessed directly from database access.
11. Question: When evaluating the Web database management system, what problems should be considered?
A: When evaluating a Web database management system, three aspects must be taken into account: multiuser problem; The web database should be a relational type; security of the database.
12. Question: What is ADO, and how does it operate the database?
A: The full name of ADO is the ActiveX Data Object (ActiveX), an optimized set of dedicated objects to access the database, providing a complete site database solution for the ASP, which functions on the server side, providing the homepage content containing the database information, By executing SQL commands, users are allowed to enter, update, and delete site database information in the browser screen.
ADO mainly includes the Connection,recordset and command three objects, their main functions are as follows:
· Connection object: Responsible for opening or connecting to the database file;
· Recordset object: Accessing the contents of the database;
· Command object: To assign an action query directive to a database, and to execute a stored procedure for SQL Server.
13. Question: What is the difference between using a Recordset object and a Command object to access a database?
A: The Recordset object will require the database to transfer all the data, then the large amount of data will cause network congestion and the database server overload, so the overall implementation efficiency will be reduced.
Using the Command object to invoke the SQL statement directly, the operations performed are performed on the database server, and are clearly highly efficient. Especially on the server side to perform the creation of completed stored procedures, can reduce network traffic, in addition, due to the prior syntax analysis, can improve the overall efficiency of execution.
14. Question: Do I have to create a connection object for each Recordset object?
A: You can save resources by using the same connection object for different Recordset objects at the same time.
15. Question: What is a database management system (DBMS)?
A: Database in order to ensure that the data stored in the security and consistency, there must be a group of software to complete the corresponding management tasks, this group of software is a database management system, referred to as Dbms,dbms with the different system, but generally speaking, it should include the following aspects:
Database Description Function: Define the global logical structure of the database, local logic structure and other kinds of database objects;
Database management functions: including system configuration and management, data access and update management, data integrity management and data security management;
database query and Manipulation functions: This function includes database retrieval and modification;
Database maintenance functions: including data introduction and extraction management, database structure maintenance, data recovery function and performance monitoring.
In order to improve the efficiency of database system development, modern database system, in addition to DBMS, also provides a variety of tools to support application development.
16, the question: What is the current popular web database management system?
A: The current popular web database management system has Microsoft SQL Server, Oracle, DB2, Sybase, small scale enterprises to use Access more.
17. Question: What is the difference between using the AddNew method of ADO in ASP and using "Insert into ..." statement directly? Which Way is better?
A: The AddNew method of ADO only encapsulates "Insert into" statement, so when manipulating large amounts of data, using SQL statements directly will greatly speed up access to data because it reduces the "translation" Time of ADO. Because the operations performed by SQL statements are performed directly on the database server, they have a significant advantage, especially when the data volume is large.
18. Question: Why do I use standard Insert record statements in ASP to insert into books (Name,email) VALUES ("Icu8", "admin@icu8.com") will be wrong?
A: SQL (structured Query language/Structured Query language) is a data query language developed by IBM in the 1970 's and is now the standard for relational database query languages. An SQL statement is an English based program language that you can use to add, manage, and Access databases.
Strings that are added in an SQL statement can use double quotes, but in an ASP you need to use single quotes for normal execution. So it should be written as insert into books (Name,email) VALUES (' icu8 ', ' admin@icu8.com ').
19. Question: What is an ActiveX control? Where can I get these ActiveX controls?
A: Microsoft ActiveX controls are reusable software components developed by software vendors. In addition to the ASP's embedded objects, additional installed ActiveX controls can be used in ASP, which can save a lot of valuable development time, in fact, in the ASP also embedded a lot of ActiveX controls can be used.
With ActiveX controls, you can quickly add special features to Web applications and development tools. For example, use the AdRotator object to make the advertisement scroll board, use the FileSystemObject object for file access, and use the marquee object to implement scrolling text.
There are now more than 1000 commercially available ActiveX controls that can be developed using a variety of programming languages such as c,c++, as well as Microsoft Visual Java Development Environment, Microsoft visible J + +. Once the ActiveX control has been developed, the design and developers can use it as a preinstalled component for developing client programs. Using ActiveX controls in this way eliminates the need for consumers to know how these components are developed and, in many cases, do not even have to program themselves to complete the design of a Web page or application.
There are more than 1000 commercial controls currently provided by third party software developers. The Microsoft ActiveX component Library (ActiveX Component Gallery) has information and associated connections that point to a variety of ActiveX controls provided by Microsoft and third party developers. In the Microsoft ActiveX component Library (ActiveX Component Gallery), you can find a list of companies that develop Internet-enhanced ActiveX controls.
20, Question: Why Use strstartport= (Request.Form ("catmenu_0") statement to take the value of the starting site in the form is not found in the database?
A: This is because the value of the starting site you are taking may have spaces, for example, the original intention is "Hangzhou", but because the space exists, the ASP program to take the value may be "Hangzhou", and the database only "Hangzhou" record, of course, can not find, the solution is to use the TRIM function will be the two spaces of the string to remove all, The corresponding statement is:
A: Any action that causes the end of a Web page, such as pressing the "Refresh" button on the browser, or closing the browser, and then reopening it, will result in the end of the variable life cycle.
If you want to keep the contents of a variable at the end of a Web page for the next execution, you can use the Application object to implement it. For example, you can use the Application object to make statistics web site traffic counters.
The session object, like the Application object, stores the contents of the variable at the end of the Web page, but unlike the Application object, each online is a separate sessions object. Simply put, all online Internet users share only one application object, but each online surfer has its own session object.
The Application object and the session object can help us record the information on the server side, while the cookie object will record the information on the client with the help of the cookies provided by the browser. It is important to note that cookies are recorded in the browser information, so the data access is not as easy as accessing other ASP objects (information stored on the server side) so simple, in practice, only when the browser started browsing a server's Web page, The browser is able to exchange cookies data with the server before the server has downloaded any data to the browser.
22. Question: What should be done after the object is used?
A: When you finish using the object, you first use the Close method to release the system resources occupied by the object, and then set the object value of "Nothing" to free up the memory occupied by the object, otherwise the Web Service site will run inefficient or even crash because of too many objects, as follows:
<%
Object. Close
Set object = Nothing
% >
23. Question: Are there several ways to read HTML form fields in an ASP file?
A: The Request object can read the contents of an HTML form field in addition to the parameters that are attached to the URL behind it, and the syntax structure that is often used is as follows:
< form method= "Get│post" action= "URL" >< form >web the name of the site (or the IP address of the site)/asp file name, you can see the results of the server performing ASP files in the browser after you enter.
27. Question: What is asp.net? What does it have to do with ASP?
A: Active Server Pages (ASP, Active Server Page) is a relatively simple programming environment in which you can mix HTML, scripting languages, and a small number of components to create server-side Internet applications;
Asp. NET is a powerful programming environment that Microsoft can use to create web-based applications using a variety of high-level languages such as C # and scripting languages, HTML, XML, XSL, and so on. Asp. NET C # as an object-oriented language, in many ways, C # will become Microsoft's Java-like language. C # is one of the most important features of ASP.net development, and Microsoft will develop C # as a strong competitor to Java. This is also Microsoft. An important part of the NET Framework. I think C # is the main tool for Microsoft to beat its opponents in the programming language field.
Asp. NET in object-oriented, database connection, large site applications are better than the ASP program, ASP. NET also offers new features such as built-in object caching and page-result caching, built-in XML support, simple processing of XML datasets, and more fully interactive server control.
Asp. NET is still completely locked in Microsoft's operating system, to really play asp.net potential, you have to use C # or vb.net. Both languages will become the core scripting language of the ASP.net standard.