Search function

I have a search box on my site that populate based on a column in my database. I'm looking to get it to search more than one column to get results. Is that an easy adjustment or do I need premier support?

It should be easy as long as you have Data Bridge... Just use the DataAssist search server behavior and you can multi-select columns to search using the keyword search option.

To the existing search box or do I need to create a new one?

You can apply the server behavior from the server behaviors panel on the page that has the results and use the existing search box.

Thanks did that but I'm still not getting results from the new column.

I'd have to take a look at the page(s) to see what you did wrong.

See PM

Open up the Data Assist search server behavior on the results page. Remove the SKU and Long Description comparisons. Then edit the Product Name one... Multi-select the three fields using control+click when editing the product name comparison and bind it to the <?php echo(isset($_GET['ProductName'])?$_GET['ProductName']:""); ?> value.

When you apply the search it should only have one row in the search fields, but that field should search across the three columns.

That did it!

Thanks Ray