If you have any records in your listings table with City or PropertyAddress1 equal to NULL, advanced search will throw the following error:

Conversion from type 'DBNull' to type 'String' is not valid. at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value) at ASP.desktopmodules_real_estate_listing_module_listing_ascx.__DataBinding__control14(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.BaseDataList.DataBind() at RealEstateModules.DNN.RealEstateListing.Listing.BindAdvaneSearchGrid() Max: Min: IsFeatured DESC, PropertyID ASC

Hello Tracy,

Can you please setup an example on our test environment, www.betasprings.com that reflects what you're trying to accomplish??

Login credentials:

Host      /    dnnhost

Then please paste the URL into this forum thread. In order to paste in our forums you will need to click the HTML tab in this editor and paste this way.

If you have any questions please let me know.

Thanks,

Ryan