This topic is locked

Filter default 'list' page

1/2/2007 4:14:06 PM
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!