Cfgrid to display search results

Ask a Question related to Coldfusion Flash Integration, Design and Development.

  1. #1

    Default Cfgrid to display search results

    I'm using Cfform format = flash. I have 2 search fields, and a button. When a
    user enters their search query, and hit submit, I want to populate my cfgrid
    with the results. Can anyone give me some insight on how to pull this off?
    Thanks -GR

    grice Guest

  2. Similar Questions and Discussions

    1. Display search results from Flash Form to CFGrid
      Yet another CF flash form question: I'm not sure if this is possible, but, I would like to display search results using flash forms and display...
    2. Sending search results to a results page..with asp
      Please help.. very :confused; Ive setup 4 dynamic drop down boxes which populate themselves from my database, this all works fine..The last box...
    3. Query results don't display properly in results table.IGNORE PREVIOUS
      :disgust; I need to display the results of a query. The query runs properly. My problem is having specific results display in specific locations in...
    4. Query results don't display properly in results table.
      :disgust; I need to display the results of a query. The query runs properly. My problem is having specific results display in specific locations in...
    5. cfgrid-flash- search
      I would like to have 3 possible search fields that on submit it will search the database and display the results in the cfgrid in flash format. Is...
  3. #2

    Default Re: Cfgrid to display search results

    I did this piece of code really quick, i hope it can help you.

    -Diego Benitez


    <cfform action="#cgi.SCRIPT_NAME#" name="search" method="post">
    <cfformgroup type="vertical">
    <cfformgroup type="horizontal">
    <cfinput name="fiel1" label="Field1: "><cfinput name="field2" label="Field2: ">
    </cfformgroup>
    <cfinput name="Search" type="submit" value="Search">
    <cfif isdefined('form.search')>
    <cfquery name="LookUp" datasource="datasource">
    SELECT * FROM table WHERE column1 LIKE '%#form.field1#%' and column2 LIKE
    '%#form.field2#%'
    </cfquery>
    <cfgrid query="LookUp" name="SrchGrid"></cfgrid>
    </cfif>
    </cfformgroup>
    </cfform>

    dbenitez Guest

  4. #3

    Default Re: Cfgrid to display search results

    that was what I was lookin for, thanks a ton for the help.
    grice Guest

Posting Permissions

  • You may not post new threads
  • You may 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