Trying to BIND data from Oracle

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

  1. #1

    Default Trying to BIND data from Oracle

    This should be very simple, but it is giving me a lot of problems. I am
    returning data from Oracle into a datagrid, then I am trying to use the BIND
    attribute on the CFINPUT tag to display the data. The data will not display,
    if I change the datasource to something else (MS Access), it works. Has anyone
    seen any problems binding data from Oracle in a CFINPUT tag? Here is my code:

    <cfform name="AFSContactInfo" format="flash" width="800" height="350">

    <cfformgroup type="panel" label="Contacts">
    <!--- grid with contact names --->
    <cfgrid name="contactGrid" query="getAFSInfo" height="220"
    rowheaders="false">
    <cfgridcolumn name="obg_no" header="Obligor" />
    <cfgridcolumn name="name" header="Name" />
    <cfgridcolumn name="addr_3" header="Address" />
    <cfgridcolumn name="city" header="City" />
    <cfgridcolumn name="st" header="State" />
    <cfgridcolumn name="zip" header="Zip" />
    </cfgrid>

    <cfformgroup type="horizontal">


    <cfinput type="text" name="sel_name" bind="{contactGrid.selectedItem.name}"
    label="Sel Name:" SIZE="20">

    <cfinput type="submit" name="submitBtn" value="Submit"/>
    </cfformgroup>
    </cfformgroup>
    </cfform>

    slider6 Guest

  2. Similar Questions and Discussions

    1. ActionScript to bind XML data to components
      How can I use ActionScript to bind XML data to a comboBox component instead of using the component inspector? (I have done the latter, successfully,...
    2. Use Bind Data as link within CFFORMITEM
      I am having a problem displaying some bind data as a link within a <cfformitem> tag. The link works fine, however I want the data from the grid...
    3. Formatting Data in BIND
      :D The BIND part of cfinput is great. Now I need to format the number calculated so I only see two decimal places. Tried our DecimalFormat...
    4. how to bind data to checkbox in datagrid
      hi i have a datagrid and one colume is a bool if i use a normal asp:BoundColumn is shows as true or false and i want it to show as a checkbox but...
    5. Using Bind Variables with Cold Fusion and Oracle
      <OakRogbak_erPine@yahoo.com> wrote in message news:13fdc9b4.0307020959.79a7c322@posting.google.com... well the sql_text column holds the actual...
  3. #2

    Default Re: Trying to BIND data from Oracle

    I figured it out. I trying to reference the Oracle column as
    contactGrid.selectedItem.name
    and it should have been
    contactGrid.selectedItem.NAME

    Oracle is case sensitive
    slider6 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