Ultradev example tutorial: 3.7 founds a simple inquiry

The 3rd chapter: Applied database founds dynamic webpage

The 7th: Found a simple inquiry

The principle that actually inquiry establishs and we above acquired data editor principle is same, it is deliver a value to give the 2nd page from the first page first, next the cost that the 2nd page passes the past according to this takes out corresponding record, redo with corresponding processing, if show, editor, delete. What what differ is to transfer pattern. On one we are to pass address join to pass a cost, and we know general inquiry is to pass sheet of a watch to fill in data refers next.

Good, let us look to establish a procedure specificly.

Above all the page that we want to found an user to be able to input inquiry content. If pursue, why does the region expressing sheet that we insert a type that the name is Search to be Text refer pushbutton. Should be used at the back of the name that notices this region that expr ess sheet, the name is informal you were taken. Next the page that we express Chan Yutian to add to carry out for this. cursor fixed position is in red line place, the attribute face plate of occurrence Form. In Action fill in one column on the page address that you should have inquiring handling, we are handled here with Searchdo.asp. This page we are founded at the back. After the setting was over, these store this page for Search.asp, the first our page that delivers a value to use has been done.



Next we found the 2nd page, namely Searchdo.asp. Old pattern, open the face plate that founds record volume, if pursue. Everybody saw the place that what differs. Was opposite, appeared in Filter Form Variable. Make me fine fine line comes. The range that Username of the choice in Filter represents to we want to search is this field of user name. Condition we choose one column Contain, state the database will show Username this field data, want the content that user input contains in this field only. Next content A are like in Username for instance, aac, aaac, if the user uses A to search, criterion 3 data can be shown to come, if the user uses Ac to search, criterion Aac, aaac can be shown to come. Form Variable is to state record volume accepts delivered cost come over through expressing sheet to deliver. The word of the domain name that express sheet that Search is us, if name of your the region that express sheet is Searchstring, corresponding here also should change Searchstring. Click Ok, our record volume has been founded.



The thing that after record volume has been founded, we should do is only according to above the method of over indication record shows the record come just.

Open browser window, look carefully at the output result of the program.



This is the Sql code that the Ultradev that clicks Advanced pushbutton to see generates for us. Saw that Request.Form("search") ? Be l ike ever was acquainted. *_ '



A few basic skill of DreamweaverUltradev can tell about here, see these, friend you should can do a few basic data to show browse, edit the function that delete. Next, we tell the plug-in unit of Ultradev to use a function first, next program of government of tiring-room of a simple website comes to our repass the content that consolidates we learn.

Why should tell plug-in unit to use first, because of a lot of moment we can use the implementation with very convenient plug-in unit of a few functions, and in next a few plug-in unit also should be used in tiring-room government program, use a method basically what so we say plug-in unit first. Please advertent.