Solution | design | Problem as Microsoft launched the Web page and database solutions, ASP because of Microsoft's unique operating system and other technical backing support, it 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.
