Recordset Filter property and NULL
From: shadow123 (shadow123_at_discussions.microsoft.com)
Date: 02/23/05
- Next message: Royboy: "Returning Null value instead of contents of field"
- Previous message: Gabriel Mejía: "Re: sometimes it returns error message: Either BOF or EOF is true in my asp page and it has valid data"
- Next in thread: Mark J. McGinty: "Re: Recordset Filter property and NULL"
- Reply: Mark J. McGinty: "Re: Recordset Filter property and NULL"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Feb 2005 17:05:02 -0800
>From what I read about ADO's Recordset's filter property the Value of the
Filter criteria can not be NULL. Is there any way at all I could use the
filter to screen for NULL and non-NULL values or am I pretty much doomed to
modifying the WHERE clause.
Something I would like to do but can't. Any ideas are welcome
recordset.Filter = "FIELD1 IS NULL";
Thank you so much.
- Next message: Royboy: "Returning Null value instead of contents of field"
- Previous message: Gabriel Mejía: "Re: sometimes it returns error message: Either BOF or EOF is true in my asp page and it has valid data"
- Next in thread: Mark J. McGinty: "Re: Recordset Filter property and NULL"
- Reply: Mark J. McGinty: "Re: Recordset Filter property and NULL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
