[thelist] SQL Server smalldatetime field problems

[Norman Beresford]

Cheers Steve

Thanks a lot, you hit the nail straight on the head!  Wahooo etc etc, pints
and much kudos to you!  I was so wrapped up in my lack of knowledge about
the datetime type that I didn't think about the cause of the error being
something else like that.

Norman

<tip author="Norman Beresford" type="accessability">
Betsie is mana from heaven if you're looking to achieve WAI compliance for
large sites.  Developed by the BBC it's a peice of CGI scripting that takes
referring URLs and strips out formatting.  As well as generating accessable
pages on the fly, it also allows you to see exactly how a page is going to
be heard by a screen reader.

http://www.bbc.co.uk/education/betsie/

</tip>



----- Original Message -----
From: "Steve Cook" <steve.cook at evitbe.com>
To: <thelist at lists.evolt.org>
Sent: Tuesday, July 10, 2001 4:50 PM
Subject: RE: [thelist] SQL Server smalldatetime field problems


> Looks like a different problem to me this time. Checking the code for
values
> longer than the space defined for them ("String or binary data would be
> truncated.") I found this:
>
> motiveContactMethod char 4 0 0 0  0   0
> The value being added to this is 'Email' - 5 characters. I've not used the
> "char" datatype myself, but I guess it's much the same as a varchar. You
> probably want to change that.
>
> Hope it helps.
>
> .steve