how to make a simple search engine??? [message #191171] |
Tue, 05 September 2006 01:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raizen_underground
Messages: 28 Registered: September 2006 Location: Manila, Phillipines
|
Junior Member |
|
|
hello experts,
please help me create a simple search engine for my project in oracle. the requirement needs to have a textfield that henever i type something it will sort the block and highlithened the data that has the same letter or number with the textfield...is it possible to make a search engine like this??
tnx guys!!!!
[Updated on: Sun, 10 September 2006 21:14] by Moderator Report message to a moderator
|
|
|
Re: how to make a simple search engine??? [message #192085 is a reply to message #191171] |
Sun, 10 September 2006 21:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
First - please do NOT press 'enter' at the end of each line. The forum sdoftware DOES know how to 'wrap text'.
Create a form, create a block and use the wizard to access a table in your database (you DO have to be signed in to a database for this to work), in the 'sort by' property add the name of the field(s) you wish to 'sort by', create another block (let's call it 'ctrl', it does NOT access a database table), add one item manually (call it 'srch_txt'), put this field on the canvas on which you placed the database populated block.
Now, using the form builder, move the 'ctrl' block higher up the hierarchy so that it is now the first block. Add a button to the 'ctrl' block and put it next to the 'srch_txt' field. Add a When-Button-Pressed trigger to this button. Put code into this trigger to go to the second block and perform an 'Execute_Query' command.
On your data block add a Post-Query trigger which tests the returned value against the data in 'srch_txt' and if they 'match' use a 'set_item_instance_property' command to change their Visual Attribute name (you will need to have defined a couple of visual attributes, eg. 'normal' and 'highlight').
David
Upd-Mod: Many typos. Sorry.
[Updated on: Tue, 12 September 2006 20:49] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: how to make a simple search engine??? [message #192838 is a reply to message #192654] |
Wed, 13 September 2006 18:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
In what way is | the sample code in the site that you have been suggested is not working
|
The site does not respond or you are using an educational institution's PC and they do not permit downloads by students?
David
|
|
|