bạn có thể bỏ qua phần bố trí và đánh dấu chỉ phần nội dung fuseactionspecific, như thể hiện trong hình 38-14: Chỉnh sửa màn hình người sử dụng. Chú ý rằng các biến đi đã vạch ra rải rác trong hình 38-14. Bạn có thể thấy rằng việc sử dụng màu sắc khác nhau làm cho sự khác biệt giữa đi và các biến đến dễ dàng hơn. | 952 Part VIII ColdFusion MX Administration 2. For this example we previously created a database named CFMXDatabase in SQL Server Enterprise Manager as shown in Figure 43-13. Note that you would replace CFMXDatabase with your own SQL Server database. Setting up this database is beyond the scope of this book as it has more to do with SQL Server administration than ColdFusion. CFMXDatabase E I l Databases Ẹ 0-1 advbootexercises I CFMX J CFMXBible - J F. Diagrams I Tables Views Stored Procedures p-Wi Users - Roles n Rules j j j n Defaults ỄL User Defined Data Types L User Defined Functions j Full-Text Catalogs Figure 43-13 The database in SQL Server Enterprise Manager. 3. In ColdFusion Administrator enter CFMXDatabase or the name of your own SQL Server database in the Database field and in the Server field. For the username and password of course use whatever you set up for this purpose. In this example we enter CFMXUser and the CFMXUser s password. Keep the default port of 1443 and enter a brief description. After you finish the form looks as shown in Figure 43-14 with your own database name username and password of course . Figure 43-14 The datasource settings form. 4. Click Submit and you re taken back to the list of datasources where the new datasource now appears with an ok beside it. And that s it. Now simply referring to CFMXBibleExample in your CFQUERY and CFSTOREDPROC tags gives you access to the CFMXDatabase database. Most datasource setups are about the same although some target databases that require a different set of parameters from those shown for SQL Server. The Oracle driver for example communicates with an Oracle database by using a different set of parameters as you see in the following section. Chapter 43 An Overview of ColdFusion MX Administrator 953 Defining a new Oracle datasource The process of setting up an Oracle datasource is similar to the one that we describe in the preceding section for SQL Server but Oracle requires different .
