2. ASPRunnerPro General questions
  3. Filter default 'list' page
This topic is locked

Filter default 'list' page

 		1/2/2007 16:14:06
ASPRunnerPro General questions
B
 bangia author

I've used ASPRunner to create some pages so our group can search an inventory database. The database contains hardware/software information on all machines in our domain. I've made it so that the '_list.asp' page only shows a subset of information (easier to see on the screen) however it seems that it is returning both 'workstations' and 'servers'. There is a field in the database called 'OSType' and it is populated by 'Workstation' or 'Server'.
How can I change the list.asp page so ONLY 'OSType' of 'Servers' shows by default?
Sergey Kornilov admin 1/2/2007

You can add a WHERE clause to SQL query in ASPRunnerPro.
Check "SQL query guildelines" in manual if you need more help with syntax.

select ...

from ...

WHERE OSType='SERVER'
B
 		bangia author 1/3/2007

You can add a WHERE clause to SQL query in ASPRunnerPro.

Check "SQL query guildelines" in manual if you need more help with syntax.

select ...

from ...

WHERE OSType='SERVER'


Thanks worked great!