Multiple parameters in advanced search

This topic is locked

Multiple parameters in advanced search	4/16/2007 4:20:36 AM
ASPRunnerPro General questions
L leesayer author I have a database that I would like to use multiple (wildcard or not) parameters in an advanced search. For example in a particular field can I enter in the seach textbox, something like the following (assuming the field label is Model), corolla (or) civic, and have the results show both corolla AND civic models? I know that I can write a query directly in SQL for seperate results, but I am trying to do this from a central results page if possible.


	Alexey admin 4/16/2007
	Hi, I recommend you to add an alias for your field on the Edit SQL query tab in ASPRunner. Modify SQL query this way: select ... Model, Model as Model1, ... Then display both Model and Model1 on Advanced Search page. Type in "corolla" into Model, "civic" into Model1 and run search. Also you'll need to select ANY condition mode on Search page.