Fields including certain text

[RFH Reseller: s80wkr]

I have a field which contains comments, this will always include either ON HIRE or OFF HIRE

How can I filter the fields based on if it includes OFF HIRE or not

Thanks

[Staff: Warren Ashcroft]

I have a field which contains comments, this will always include either ON HIRE or OFF HIRE

How can I filter the fields based on if it includes OFF HIRE or not

Thanks

Create a boolean field in your database table (aka bool, aka bit) - this value should then be 1 or 0, true or false.

In your code (ASP) you would simply use:

If CBool(rsMyRecordset("HireStatus")) Then
 ' On Hire
Else
 ' Off Hire
End If

[RFH Reseller: Sol]

You'd be better off doing the filtering when getting records from the database:

SELECT col1, col2, HireStatus, col4 FROM tbl WHERE HireStatus = FALSE

Note: You need to replace colX to be the names of the columns you want to get, tbl to be the name of the table. You may also need to change FALSE to 0 depending on the database platform.

I listed the columns this way because it provides better performance than using the wildcard '*' to select all columns.

[Staff: Warren Ashcroft]

You'd be better off doing the filtering when getting records from the database:

SELECT col1, col2, HireStatus, col4 FROM tbl WHERE HireStatus = FALSE

I assumed that would go without saying, I just gave an example of how to do it in code, when you wish to show the hire status, but not filter the results by it.