problem with 0000-00-00 in 'Date' field ?

[David]

Hi,

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

In my .asp pages I am trying to test against this empty field.

i.e.

If RS("ShipDate") = 0000-00-00
or
If RS("ShipDate") = 00/00/0000

The only thing that seems to work is if I am testing for records with
a date in that field,

If RS("ShipDate") > 0000-00-00
How can I test if that field is empty ?, nothing seems to work ?
Thanks
David

[BDR]

Try testing against a string value instead of a numeric one...

If RS("ShipDate") = '0000-00-00'

http://www.mysql.com/doc/en/Using_DATE.html
David wrote:

Hi,

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

In my .asp pages I am trying to test against this empty field.

i.e.

If RS("ShipDate") = 0000-00-00
or
If RS("ShipDate") = 00/00/0000

The only thing that seems to work is if I am testing for records with
a date in that field,

If RS("ShipDate") > 0000-00-00
How can I test if that field is empty ?, nothing seems to work ?
Thanks
David

[BDR]

Try testing against a string value instead of a numeric one...

If RS("ShipDate") = '0000-00-00'

http://www.mysql.com/doc/en/Using_DATE.html
David wrote:

Hi,

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

In my .asp pages I am trying to test against this empty field.

i.e.

If RS("ShipDate") = 0000-00-00
or
If RS("ShipDate") = 00/00/0000

The only thing that seems to work is if I am testing for records with
a date in that field,

If RS("ShipDate") > 0000-00-00
How can I test if that field is empty ?, nothing seems to work ?
Thanks
David

[Toshi1873]

In article <c1**************************@posting.google.com >,
da***@scene-double.co.uk says...

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

Just a personal preference... but for a field that has an unknown value,
I prefer to use NULL in the field.

If IsNull(RS("ShipDate")) Then

[Toshi1873]

In article <c1**************************@posting.google.com >,
da***@scene-double.co.uk says...

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

Just a personal preference... but for a field that has an unknown value,
I prefer to use NULL in the field.

If IsNull(RS("ShipDate")) Then

[swdev1]

you did not mention the column/field type for ShipDate

if character type ->
IF RS("ShipDate") = "00/00/0000"
if date type [not datetime]
IF RS("ShipDate") = {00/00/0000}

see if that works for you - your examples below were kinda weird to me.
hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...

Hi,

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

In my .asp pages I am trying to test against this empty field.

i.e.

If RS("ShipDate") = 0000-00-00
or
If RS("ShipDate") = 00/00/0000

The only thing that seems to work is if I am testing for records with
a date in that field,

If RS("ShipDate") > 0000-00-00
How can I test if that field is empty ?, nothing seems to work ?
Thanks
David

[swdev1]

you did not mention the column/field type for ShipDate

if character type ->
IF RS("ShipDate") = "00/00/0000"
if date type [not datetime]
IF RS("ShipDate") = {00/00/0000}

see if that works for you - your examples below were kinda weird to me.
hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...

Hi,

I have a field in a table called 'ShipDate'.
This particular field has allow null set to no. So by default this
sets all the records to show 00/00/0000 in the field for each record
that has no data entered.

In my .asp pages I am trying to test against this empty field.

i.e.

If RS("ShipDate") = 0000-00-00
or
If RS("ShipDate") = 00/00/0000

The only thing that seems to work is if I am testing for records with
a date in that field,

If RS("ShipDate") > 0000-00-00
How can I test if that field is empty ?, nothing seems to work ?
Thanks
David