help this search engine form

Thanks i got the solution already. Now got another problems.
Having input text problems.
I've created the search form, results form and frame form. When i input the text or number onto the textbox, it cannot show what is been expected instead it shows all the results from the database

table. What i want is that when i type anything be it an number or an alphbet that is related to the rows of fieldname(ie 350v221, 350v265cc etc..) inside the textbox, it will show the results of that

particular files only. My database table have fieldname like, DOC_NO (containing i.e 350v000, 350v2587, 350v226 etc... [IN ROWS] ), DESCRIBE, REMARKS and STATUS. Also i got some tables

that have many information(no of rows) that consist of more than 20,000 information. My database table's name are saved as the starting number/alphbet (ie. 335a, 335b, 335c, 360V, wei, ght,). So is

there any simple ways to query for these data? Also i created frames so as to show the resulting page on the right frame and the searching page on the left frame. How do i link it together so as the

results will show on right frame?

1) you do not upload files 'into the database' - you upload them to the
web server. the DESTINATION attribute of <cffile action="upload">
determines which folder on the server the file is going to be stored in
after it has been uploaded. #cffile.serverfile# variable returned by
<cffile action=uplaod"> tag contains the name of the uploaded file on
the server. you can then store this name, or actual file in binary
format, in the db.

2) what is this mysterious 'condition' that determines which folder the
file should be stored in? how to you decide which folder it should be
uploaded to?


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/