Dreamweaver MX Ultradev is explored (2)

Dreamweaver MX Ultradev is explored (the record that 2) shows the database is medium

Go up to told us to basically negotiate the link that installs a database, we should begin true implementation tiring-room application today, get data from inside the database, what tell in front prepare to work today. The webpage that we see nowadays basically is dynamic, alleged trends combined a database namely, replace news automatically. Retrieving data from inside the database is among them the basiccest, also be a kind of our most commonly used dynamic means. We are about to carry inquiry below, the Product in Northwind database retrieves product information list in the watch.

If the attention is in when setting site, the Access in Testing Server option installs FTP please or Local/Network, (the 2-1 that be like a graph) , otherwise Bindings cannot be used.



Graph 2-1

Choose the Bindings label in the Application face plate of right . Press plus button (the 2-2 that be like a graph)



Graph 2-2
In Recordset dialog box, have detailed setting, following:

Name: DisProduct
Connection: Northwind (it is that link that we establish in going up to be told, can choose)
Table: Product (listed here all watches in the database, we choose Product)
Columns: All fields in Product are inside, if choose Select sheet to choose pushbutton, so we can undertake filtration to the field. (the 2-3 that be like a graph)



Graph 2-3

After the setting ends, we can have a test, press the Test button of right, it is very surprizing, the data that we need has listed entirely came, the force of the tool is great! (the 2-4 that be like a graph)



Graph 2-4
Click OK to return Recordset dialog box, click OK to return a page again, at this moment the change that we can see appear in Binding label, the name that we build appeared for the inquiry of DisProduct. I think ev erybody saw this very should easy think of an object, very intuitionistic, easier than the target is being established in code understanding became much (the 2-5 that be like a graph) click the "+" date on the side, spread out, before Product expresses all medium fields to appear in you. (the 2-6 that be like a graph)



Graph 2-5



Graph 2-6

Our purpose is to want to show product list on the page, the job below you will discover, indicating the thing in the database on the page is how easy, you will again those who experience a tool is great.
One is built on the page two 4 form, fill respectively in group on: Product name, unit amount, monovalent, stocks (the 2-7 that be like a graph) these are the fields that we want to show on the page. Below one, we will put in the content of the field.



Graph 2-7

Choose the field that develops in Bindings, we choose field of " of " product name first, be in the 2nd of form next t he first clicks a mouse, make cursor amid is blinked, return Bindings face plate next, click Insert pushbutton, (the 2-8 that be like a graph)



Graph 2-8
Ordinal measure " unit number with same method, monovalent, stocks " field inserts form in, (the 2-9 that be like a graph) , still have a more simple method, it is you can procrastinate move a field reach the place that should place, the effect is same, and more simple. Good, read former code now, if you are the abecedarian of an Asp, tell you an experience, read the former code that Mx generates more namely, to you study Asp has very great help. Because can discover after you, oneself simple accretion a few code can try two pages to incorporate, log onto a page for instance, that is hind word, see you can know slowly.



Graph 2-9

Good, save your page now, seeing your labor gain in the browser next. Must not tell me you do not know how to debug Asp page! Show how, have a result only, ve ry make you disappointed. Ha, record finger did not move, show party only of course. Look then.

We should begin to tell Server Behaviors, use her to be able to realize a lot of functions, did not say first, look slowly, the problem that we should solve now is how to show all records. Pitch on form all the 2nd unit case (the 2-10 that be like a graph) ,



Graph 2-10
Click the "+" date pushbutton of Server Behaviors label, issueing Repeat Region of the choice in pulling menu, in Repeat Region dialog box choice All sheet chooses pushbutton, if you do not think it is OK also to show entirely,the sheet above the choice chooses pushbutton, the amount that the input hopes to show (the 2-11 that be like a graph)



Graph 2-11

The pushbutton that press OK is returned. Appeared more again in Server Behaviors label a behavior (the 2-12 that be like a graph) . Examine former code, you discover he just added statement of a loop.



Graph 2-12

Save what what do to alter, debug again, how, you are in (graph 2-11) in how much to install to come out how many. Come here today the position, everybody can be reviewed well the following, basically be to build inquiry, there still are a lot of keys inside.


To be continued...