www.webdeveloper.com
Results 1 to 8 of 8

Thread: How to search for a keyword in a text

  1. #1
    Join Date
    Apr 2011
    Posts
    4

    How to search for a keyword in a text

    Hello everyone, I have a DB here that has an attribute "Status" it's a text ... I wanna make a search field in the form application that when the user enters a certain key word the application displays all the records containing that keyword.
    Thanks in advance,
    D.

  2. #2
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    Hi,

    is a bit vague which part your stuck on.

    The string class provides IndexOf method that returns the location of the first match in a string.


    Code:
    Vb
    
    Dim Position as Integer = 0
    Dim StringtoSearch as string = "your text here.."
    Dim SearchFor as string = "text"
    
    Position = StringtoSearch.IndexOf(SearchFor, Position)
    That would return a integer if its found or -1 if its not found.


    To retrieve records based on a substring of text for a particular field then you would do the following SQL:

    Code:
    Select column1, column2 from table1 where column2 LIKE '%The Text%'
    That would retrieve records that have The Text anywhere in column2.

    regards

    Ribs
    ----------------------------------

  3. #3
    Join Date
    Apr 2011
    Posts
    4
    yes, but the problem is...instead of "The Text" , I want "The Text" is what the user want to search for (Take the string from the user and apply it in the sql statement)...and it's a c# application by the way but it doesn't matter

  4. #4
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    Code:
    C#
                int Position = 0;
                string StringToSearch = "your text here...";
                string SearchFor = TextBox.Text;
    
                Position = StringToSearch.IndexOf(SearchFor, Position);
    Code:
    Select column1, column2 from table1 where column2 LIKE '%' & Textbox.Text & '%'
    regards


    Ribs
    ----------------------------------

  5. #5
    Join Date
    Apr 2011
    Posts
    4
    the sql statement is not working :S

  6. #6
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    sorry but u ain't going to get much help with posts like that.
    If does help to show us what code u have tried.
    ----------------------------------

  7. #7
    Join Date
    Apr 2011
    Posts
    4
    This "@" is to take the value from the user:
    Code:
    SELECT * FROM Patient WHERE Patient_Status LIKE @disease
    it's working fine but to be a match...the user's inpout must be exactly=the text in the databse. what I have tried:
    Code:
    SELECT * FROM Patient WHERE Patient_Status LIKE '%' & @disease & '%'
    the above statement error: The datatypes varchar and text are incompatible in the '' operator
    Code:
    SELECT * FROM Patient WHERE Patient_Status LIKE '%' & '@disease' & '%'
    also error
    Code:
    SELECT * FROM Patient WHERE Patient_Status LIKE '%@disease%'
    this is working, no errors, but it assumed the text to search for is "@disease"
    Code:
    SELECT * FROM Patient WHERE Patient_Status LIKE @%disease%
    above statement error: error in WHERE clause near '%'

  8. #8
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    Not sure what u mean by @ takes the value from the user.

    You said the user inputs the search criteria in a textbox. So whatever you called ur textbox you get the value using:

    Code:
    String thevalue = Textboxname.text
    Then make sure ur single and double quotes are correct.

    Code:
    "select col1 from table where col1 LIKE '%" & thevalue & "%'"
    ----------------------------------

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center

"

"

X vBulletin 4.2.2 Debug Information

  • Page Generation 0.21795 seconds
  • Memory Usage 2,913KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (11)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (8)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (73):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates