Urgently need help on building search engine

Get new comments by email
You can cancel email alerts at anytime.
Comments (2)

alex in Singapore, Singapore

38 months ago

Having input text problems.
I've created the search form, results form and frame form. When i input any alphabet or number onto the textbox and click search, the outcome is not what i 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 same to the data of a fieldname in rows(i.e 350v221, 350v265cc, a135vod etc..) inside the textbox, it will show the results of that particular files only. My database table have fieldnames like, DOC_NO (containing data of [i.e 350v000, 350v2587, 350v226 etc..]) [IN ROWS] ), DESCRIBE, REMARKS and STATUS. Also i got some tables that have many data (in number of rows) that consist of more than 20,000 information. My database table's name are saved as the starting number/alphbet (ie. 335a.dbm, 335b.dbm, 335c.dbm, 360V.dbm, wei.dbm, ght.dbm etc...). So is there any simple ways to query for these data? I've 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 only on right frame even it get refresh

<b><!---Search_results.cfm---></b>

<CFset index="1">

<cfif not IsDefined("Form.txtNumberInput")> <!---If there's no input been type onto textbox, it will do the following code--->

<cfquery name="get_FirstNo" datasource="DSN_db1_IWS">
select *
from 335v where doc_no like '%#form.txtNumberInput#%'
order by doc_no
</cfquery>

<cfelseif IsDefined("form.txtNumberInput")>
<cfquery name="get_FirstNo" datatsource="DSN_db1_IWS">
select *
from 335v where doc_no like '%#form.txtNumberInput#%'
order by doc_no
</cfquery>

<cfquery name="get_total" datatsource="DSN_db1_IWS">
select *
from 335v where doc_no not in ('abc')
</cfquery>
</cfif>

<cfif not IsDefined("form.ddlnumber")>
<cfquery name="get_FirstNo" datasource="DSN_db1_IWS">
s

- Was this comment helpful? Yes / No Reply - Report abuse

alex in Singapore, Singapore

38 months ago

oops! post wrong.

- Was this comment helpful? Yes / No Reply - Report abuse

Your Reply

change location - create a profile
User Name
 in Beverly Hills, California
Your Comment
Your Email Address
Enter the numbers you see in the box
CAPTCHA Image

Be Reasonable! Be Polite! Please read our Terms of Service and Forum Rules, where it notes that you are responsible for your own comments. You may post anonymously - but we reserve the right to remove inappropriate comments at any time.

RSS Feed Icon Subscribe to this discussion as an RSS feed.