Dreamweaver MX Ultradev is explored (5-1)

Dreamweaver MX Ultradev is explored (5) deletes the record in the database

Continue the brigade of our Dreamweaver MX, the server behaviour that in on one chapter we studied how to use DW MX to be taken oneself updates the record in the database, everybody still ought to answer remain fresh in one's memory. Its powerful server act can be below the case that we need not write a code undertake operating to the database in the database, for example in front mentioned insertion, newer, delete etc. In this one chapter, if use DW MX to undertake deleting to the record in the database,we will learn.

The basic idea that says it first. : ) the page that allow may include to make an user delete a database to record through the browser in WEB application, it is preexistence normally the record that should delete shows on the page, the operation that occupies a library through user logarithm next will delete needless record. Took a Delete Record oneself in DW MX (delete a record) server behavior, come to what logarithm occupies a library delete undertake operating. Operate with the newer database that we learn in on one chapter actually very much the same, pass the data that browse first, the choice wants the data that delete, undertake deleting a page accordingly next, affirm delete. Concrete step is here differ also one expatiatory, refer to please go up to see.

　　 <1>Preparation works, in on one chapter we were told about how to use jump turn to detail page to join (Go To Detail Page) server behavior jumps turn to relevant database to record a field. Here not exceptional also, if pursue,show the result finally (5-1) and (5-2) be shown.



5-1



5-2

The detailed field that makes above is here differ also one expatiatory, specific refer to the 4th chapter please. : )

　　<2>Good, early days job already prepared to end, this our leading role is De lete Record (delete a record) server behavior. Its function is very simple also, see a name know it uses those who delete record volume technically namely. OK, build us child page, receive the cost that the first page passes, show corresponding database is recorded. These is in in the 4th chapter we also have tell, if pursue,show the result finally (5-3) and (5-4) be shown. Remember to put form into watch sheet, undertake naming to the text casing inside.



5-3



5-4
　　<3> Delete Record(deletes a record) detailed introduction. Application- - > Server Behaviors- - > Delete Record, if pursue (5-5) be shown.



5-5

Click if pursue,appear (5-6) shows dialog box. The renews database content server action that place of before discovering it and us not hard one chapter explains is very similar.

Connection: The database that can issue the choice in drawing list to want to use from this joins, if do not have, can click the Define from the back to define join of a database again.

Delete From Table: Fall in this in drawing list, can choose to want to delete the record of which watch in the database.

Select Record From: Choose to want use record volume name here.

Unique Key Column: The crucial field that pitch on wants to delete record volume to be in a watch, if crucial field content is a number, need pitch on right Numeric answer choose casing, general we use what it acquiesces to go here.

Delete By Submitting: Fall in this in drawing list, the choice submits the name expressing sheet that deletes an operation. Go up because of our page a sheet of a watch, and did not undertake naming to it, so it can choose Form1 automatically, if single to the watch name undertook change or many express sheet, want to choose corresponding watch sheet.

After Deleting, go To: Finish after this deletes an operat ion, jump turn to which page, here we input Delok.asp. (do not forget build this page! )



5-6

If the result that the page after completing this operation shows pursues (5-7) be shown, the place that used server act can be indicated by different color.



5-7
　　<4> Check finally!

Let us see the record in the database first, if pursue (5-8) be shown.



5-8

The effect of give typical examples of homepage face pursues (5-9) .



5-9

Here we choose to delete the first record, click what ID is the record of 1 to go up to delete, can jump turn to delete child page, if indication effect pursues (5-10) be shown.



5-10

After referring, can jump turn to us a moment ago above in the Delok.asp page of the definition, see the record in the database again, if pursue (5-11) be shown.



5-11

Ah. . . Everybody also ought to see, the record already w as deleted.