Large TextArea to SQL 7

Results 1 to 2 of 2

Thread: Large TextArea to SQL 7

  1. #1
    Join Date
    Dec 1969

    Default Large TextArea to SQL 7

    Hi,<BR>I have a large textarea box that holds user comments in an ASP page and I would like to save those in my SQL7 DB. I have the type set to "Text" and the datalength defaults to 16. Unfortunately I get the error: "Application uses a value of the wrong type for the current operation." I&#039;ve tried converting the variable to string, changing the datatype to varchar(8000), but it still doesn&#039;t work. If I only have a few sentences in the textarea it works with maybe three lines in a box of 6 rows x 77 cols. Anything larger than that and it blows up.<BR><BR>Ideas?<BR><BR>Thanks,<BR>Scott<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Large TextArea to SQL 7

    any chance that the textarea contains a single quote ( &#039; )?<BR><BR>this might cause that the query ends up strange which might have caused that error<BR><BR>do a replace(request("comment"),"&#039;","&#039;&#039;" ) before inserting/updating and see if that solves your problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts