Guy,
I'd double check your column definition to make sure it's set to 300
and not 30...I've been known to do things like this from time to time.
-joe
On Fri, 29 Oct 2004 10:12:56 -0400, Guy McDowell <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Having trouble with this one.
>
> SQL 2000 and the field datatype is nvarchar set to 300 chars.
>
> Insert Statement:
> INSERT INTO tblMyTable (txtField)
> VALUES ('#frmTxtField#')
>
> '#frmTxtField#' comes from a textarea form element.
> Sometimes I get a "truncate data" error from the database. Sometimes it does the
> insert but only the first 30 or so characters.
>
> I feel like I'm missing something obvious.
>
> ~Guy
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Protect your mail server with built in anti-virus protection. It's not only good for
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182924
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
