>we are having a problem with textarea input types where we try to insert the value into a vfp table in an asp.
>we get an error from the odbc driver saying the command contains and unrecognized phrase or keyword. we can paste the same sql into vfp and it works great.
>
>has anyone had similar problems or know a workaround? it works great with regular textboxes but we need to use a couple multiline textboxes.
>
>thanks

Gary,

You probably are trying to store some characters like carriage return thats hosing it up. You will need to scan for illegal charaters and replace them with some type of meta string value or remove.

I.E.
mesg=Replace(mesg,chr(13),"$e$")
mesg=Replace(mesg,chr(10),"")
etc.

If I understand what you are doing, getting an SQL statement then all you probably need to do is remove any linefeeds and replace the carriage returns with a space.

mesg=Replace(mesg,chr(13)," ")
mesg=Replace(mesg,chr(10),"")

I ran in to this developing a ASP based message board and had a huge routine converting back and forth. Also note that there is a limit of 256 characters per field (including Memo's) that can be passed through the ODBC driver (I do not know if this issue has been resolved yet with the latest ODBC release). I had to check for string length a split up strings over 256 bytes to multiple records (Oh what fun).

HTH,
Mike