Skip to main content
Known Participant
January 8, 2010
Question

Search help needed! select box with 2 variables? is it possible

  • January 8, 2010
  • 2 replies
  • 386 views

Using coldfusion 8 and MySQL.  I need to make a search form that has a drop select that displays the department and category together in the drop select.

Is it possible? what would the form and search query look like. any help would be appreciated. thanks in advance.

example: each is a line item for the drop select. then when one is selected it returns the results if records are found.

mens/shoes

mens/clothing

mens/accessories

womens/shoes

womens/clothing

    This topic has been closed for replies.

    2 replies

    AdamPresley
    Participating Frequently
    January 11, 2010

    With MySQL use the CONCAT function. Eg.

    (CONCAT(firstName, ' ', lastName)) AS fullName
    Inspiring
    January 8, 2010

    Gee, what a coincidence, my current project has one of those.  My approach is to include a concatonated field in the query and use it for the desired attribute of cfselect.

    The details of the contcatonated field depend on the db.  I don't use mySql but if I wanted to know badly enough, I would google "mySql concatonate"