3 Replies Latest reply on Jun 4, 2012 1:22 PM by helenmhudson

    CFC returning multiple columns for an autosuggest

    helenmhudson Level 1

      Hi experts

      Spent all day trying to think of a nice way of doing this and I'm sure one of you must have come across something similar.

      I want an input text box with autosuggest which gets its suggestions from a CFC query.

      All good and well and I've conquered that beastie.

      In an ideal world the VALUEs of that text box will be an id while the autosuggestions display will be a list of nice text things.

      Obviously I know that I can't do that with an input text box... WYSIWYG and the value=display.

      But the alternative with typing in one field and then the autosuggestions come up in another field is a bit cumbersome.

      I "could" make the "nice text" incorporate the unique id and then manage to pull back the information uniquely later on, but this is also not ideal.

      Is there a way of allocating an id  to a textbox like this?  Or am I smoking something?

       

      And if so, how on earth do I pass back the results from the "select id, description" query in the CFC so that I can use them (and remember that there are multiple values) in the CFM.  So far I've only needed (and therefore) mastered the art of passing back 1 column of data from a CFC so I'm still on page 1 of the Hitchhikers Guide so far.

      Thanks HUGELY in advance!

      Helen