Skip navigation
Currently Being Moderated

CFC returning multiple columns for an autosuggest

Jun 4, 2012 7:20 AM

Tags: #cfc #multiple_columns

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

 
Replies
  • Currently Being Moderated
    Jun 4, 2012 9:08 AM   in reply to helenmhudson

    Does your plan incorporate users who ignore the autosuggestions and do their own typing?

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points