|
 |
activex_data_objects thread: Using Recordset.Filter to filter out records with null
Message #1 by "Norman Tse" <tse@p...> on Fri, 21 Dec 2001 21:53:01
|
|
Hi,
How can I use set Filter property in Recordset in order to retrieve all
records with null value in a particular fields? I have an error as below:
rs.Filter = "LastName='Smith' and hireDate is null"
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another
Regards,
Norman
Message #2 by "Ethan Selzer" <ethanselzer@m...> on Fri, 21 Dec 2001 14:41:48 -0800
|
|
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235892
-----Original Message-----
From: Norman Tse [mailto:tse@p...]
Sent: Friday, December 21, 2001 9:53 PM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] Using Recordset.Filter to filter out records
with null
Hi,
How can I use set Filter property in Recordset in order to retrieve all
records with null value in a particular fields? I have an error as below:
rs.Filter = "LastName='Smith' and hireDate is null"
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another
Regards,
Norman
$subst('Email.Unsub').
Message #3 by "Tomm Matthis" <matthis@b...> on Sat, 22 Dec 2001 09:36:49 -0500
|
|
You can on set a filter on one "condition" that is no ANDs ORs etc... only a
equality operator.
It would be better to compose the SQL WHERE statement to return what you need.
-- Tomm
> -----Original Message-----
> From: Ethan Selzer [mailto:ethanselzer@m...]
> Sent: Friday, December 21, 2001 5:42 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] RE: Using Recordset.Filter to filter out
> records with null
>
>
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235892
>
> -----Original Message-----
> From: Norman Tse [mailto:tse@p...]
> Sent: Friday, December 21, 2001 9:53 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] Using Recordset.Filter to filter out records
> with null
>
> Hi,
>
> How can I use set Filter property in Recordset in order to retrieve all
> records with null value in a particular fields? I have an error as below:
>
> rs.Filter = "LastName='Smith' and hireDate is null"
> ADODB.Recordset error '800a0bb9'
>
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another
>
> Regards,
> Norman
>
> $subst('Email.Unsub').
>
>
> $subst('Email.Unsub').
|
|
|
View Cart
