Zero length strings

[William E Hatto]

Hi All,

What is the best way to handle zero length variables when inserting data
into a table. I have text field and date fields, both of which have no data
in them from time to time.

I have been using this for the text fields.

If myData="" then myData=" "

I have used the same for dates.

Is this OK to use or is there a better way.


Thanks in advance,

Bill.

[Evertjan.]

William E Hatto wrote on 13 jun 2004 in
microsoft.public.inetserver.asp.db:

> What is the best way to handle zero length variables when inserting
> data into a table. I have text field and date fields, both of which
> have no data in them from time to time.
>
> I have been using this for the text fields.
>
> If myData="" then myData=" "
>
> I have used the same for dates.
>
> Is this OK to use or is there a better way.
>

A string text field can have an empty string

A date field must be set to null or a valid date.

[depending on the type of database engine?]

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[William E Hatto]

Thanks Evertjan,

I am using an Access Database.
I get an error if I try to insert a zero length string in to the database.
Is there something I am missing?

I have got around it so far using the code in my OP.

Is threr a better way?

Cheers, Bill.


"Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message
news:Xns9507975A5B5A6eejj99@194.109.133.29...

> William E Hatto wrote on 13 jun 2004 in
> microsoft.public.inetserver.asp.db:
>

> > What is the best way to handle zero length variables when inserting
> > data into a table. I have text field and date fields, both of which
> > have no data in them from time to time.
> >
> > I have been using this for the text fields.
> >
> > If myData="" then myData=" "
> >
> > I have used the same for dates.
> >
> > Is this OK to use or is there a better way.
> >

>
> A string text field can have an empty string
>
> A date field must be set to null or a valid date.
>
> [depending on the type of database engine?]
>
> --
> Evertjan.
> The Netherlands.
> (Please change the x'es to dots in my emailaddress)

[Bob Barrows [MVP]]

For Jet database Text fields, there as an Access-defined property called
"Allow zero-length string" which you need to set in the table design view in
Access.

For Date/Time fields, you have to insert a Null, not a string.

Bob Barrows

William E Hatto wrote:

> Thanks Evertjan,
>
> I am using an Access Database.
> I get an error if I try to insert a zero length string in to the
> database. Is there something I am missing?
>
> I have got around it so far using the code in my OP.
>
> Is threr a better way?
>
> Cheers, Bill.
>
>
> "Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message
> news:Xns9507975A5B5A6eejj99@194.109.133.29...

>> William E Hatto wrote on 13 jun 2004 in
>> microsoft.public.inetserver.asp.db:
>>

>>> What is the best way to handle zero length variables when inserting
>>> data into a table. I have text field and date fields, both of which
>>> have no data in them from time to time.
>>>
>>> I have been using this for the text fields.
>>>
>>> If myData="" then myData=" "
>>>
>>> I have used the same for dates.
>>>
>>> Is this OK to use or is there a better way.
>>>

>>
>> A string text field can have an empty string
>>
>> A date field must be set to null or a valid date.
>>
>> [depending on the type of database engine?]
>>
>> --
>> Evertjan.
>> The Netherlands.
>> (Please change the x'es to dots in my emailaddress)

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[William E Hatto]

Thankyou....


"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eTP5H2UUEHA.3540@TK2MSFTNGP11.phx.gbl...

> For Jet database Text fields, there as an Access-defined property called
> "Allow zero-length string" which you need to set in the table design view

in

> Access.
>
> For Date/Time fields, you have to insert a Null, not a string.
>
> Bob Barrows
>
> William E Hatto wrote:

> > Thanks Evertjan,
> >
> > I am using an Access Database.
> > I get an error if I try to insert a zero length string in to the
> > database. Is there something I am missing?
> >
> > I have got around it so far using the code in my OP.
> >
> > Is threr a better way?
> >
> > Cheers, Bill.
> >
> >
> > "Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message
> > news:Xns9507975A5B5A6eejj99@194.109.133.29...

> >> William E Hatto wrote on 13 jun 2004 in
> >> microsoft.public.inetserver.asp.db:
> >>
> >>> What is the best way to handle zero length variables when inserting
> >>> data into a table. I have text field and date fields, both of which
> >>> have no data in them from time to time.
> >>>
> >>> I have been using this for the text fields.
> >>>
> >>> If myData="" then myData=" "
> >>>
> >>> I have used the same for dates.
> >>>
> >>> Is this OK to use or is there a better way.
> >>>
> >>
> >> A string text field can have an empty string
> >>
> >> A date field must be set to null or a valid date.
> >>
> >> [depending on the type of database engine?]
> >>
> >> --
> >> Evertjan.
> >> The Netherlands.
> >> (Please change the x'es to dots in my emailaddress)

>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>