Hi !

My guess it that you SQL statement that you send is wrong.
Try to execute the same statement directly in Database. In your case it
would
be FoxPro I guess.

Limitation problem can appear when you submit 1000 characters for example
and in database you see only 255.
I have this problem too. Its related to database driver etc'.
However there are solution in my case but yours can be different.

Oleg.

-----Original Message-----
From: J [mailto:greatjax@h...]
Sent: April 18, 2002 12:55 PM
To: javascript
Subject: [javascript] SQL 255 limitation problem (i am guessing)


My form contains a text area.  The contents I am trying to place into a
Foxpro memo field.

I receive this error when I enter more than 255 characters.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized
phrase/keyword.

Here is the command text that I am using:

update speaker set biography = 'Brian is one of the .......' where
speakerno
= '1 '

Does anyone have any ideas?  I am using ASP/Javascript.

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20