Professional Web Applications Themes

How to Pull 1 word from a phrase in a table? - Coldfusion - Advanced Techniques

i need to be able to pull everything with the word Belcher from DEPO 1875 N. BELCHER, DEPO 1875 N. BELCHER STE. 102, etc... basically anything with the word Belcher in it i need to display from this table. do i do this in a query or in the output? and how do i do it?...

  1. #1

    Default How to Pull 1 word from a phrase in a table?

    i need to be able to pull everything with the word Belcher from DEPO 1875
    N. BELCHER, DEPO 1875 N. BELCHER STE. 102, etc... basically anything with the
    word Belcher in it i need to display from this table. do i do this in a query
    or in the output?

    and how do i do it?


    Greasy Guest

  2. #2

    Default Re: How to Pull 1 word from a phrase in a table?

    I found a great tag that can accomplish exactly what you want.

    [url]http://www.contentbox.com/claude/customtags/tagstore.cfm[/url]

    The tag cf_REextract works great. At $15 you can not go wrong.
    _andyK Guest

  3. #3

    Default Re: How to Pull 1 word from a phrase in a table?

    well is there a way to do it manually instead of paying.. im trying to do this on the free basis lol.
    Greasy Guest

  4. #4

    Default Re: How to Pull 1 word from a phrase in a table?

    what database are you using?
    arniebld Guest

  5. #5

    Default Re: How to Pull 1 word from a phrase in a table?

    By using substr and instr functions (Oracle) you'll manage to get the wanted result. Most databases have similar functions
    CF_fdk Guest

  6. #6

    Default Re: How to Pull 1 word from a phrase in a table?

    I am using SQLServer
    Greasy Guest

  7. #7

    Default Re: How to Pull 1 word from a phrase in a table?

    For SQL Server, perhaps you just want
    SELECT {your-list-of-columns}
    FROM {your-table}
    WHERE {your-search-column} LIKE '%belcher%'
    ?

    I don't think you can use LIKE on columns of type (N)TEXT though, only
    (N)(VAR)CHAR.

    cjeris Guest

  8. #8

    Default Re: How to Pull 1 word from a phrase in a table?

    Thanks that did the trick.
    Greasy Guest

Similar Threads

  1. Nested Style to exact "Word" or "Small Phrase"
    By SilverDollar@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 10
    Last Post: September 27th, 06:49 PM
  2. Pull from 1 table to enter into table 2..??
    By chipjohns in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 26th, 02:02 AM
  3. Search for all occurances of a word in a table
    By mattFlash in forum Macromedia ColdFusion
    Replies: 1
    Last Post: May 7th, 04:39 PM
  4. How to pull the data out from two table and bind to repeater
    By chng yeekhoon via DotNetMonster.com in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: March 28th, 05:06 PM
  5. Word Table of Contents
    By Jean_Hanson@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 4
    Last Post: May 19th, 07:20 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139