Have you counted the characters of whatever text it is you're trying to
insert into the SQL field? And can you insert this same text into Access,
but not a SQL ntext field?
---mark
=========================================
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=========================================
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 9:29 AM
To: CF-Talk
Subject: RE: SQL 7.0
I have this now and there is a field of text I need to place into this
field and it complains that the size is to small!!!
> -----Original Message-----
> From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, 28 July 2001 2:02 AM
> To: CF-Talk
> Subject: RE: SQL 7.0
>
> I believe that's NTEXT (16).
>
> You can verify that by exporting an Access database with a memo field
into
> SQL.
>
> ---mark
>
> =========================================
> Mark Warrick - Fusioneers.com
> Personal Email: [EMAIL PROTECTED]
> Business Email: [EMAIL PROTECTED]
> Phone: 714-547-5386
> Efax: 801-730-7289
> Personal URL: http://www.warrick.net
> Business URL: http://www.fusioneers.com
> ICQ: 125160 / AIM: markwarric
> =========================================
>
>
> -----Original Message-----
> From: Andrew Scott [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 27, 2001 8:28 AM
> To: CF-Talk
> Subject: SQL 7.0
>
>
> What is the equivalent to memo in ms SQL 7.0, for the life of me my
mind
> has gone to the fairies on this one!
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
