I have a textarea that is inserted to database(via ado). Sometimes, the insert statement doesn't get executed. I wonder if it has something to do with weird characters such as "'%$. So I use Server.URLEncode the textarea content. But it doesn't solve all situations.

Any other reason can be the cause ? Thank you.

;;;Sometimes, the insert statement doesn't get executed
What exactly are the behaviours, error??

;;;I wonder if it has something to do with weird characters
If you are not handling wierd charcters, then yes probably. Trial and error will tell you, have you tryed this?

Try this function on insert:
  Function StoreText(theText)
    StoreText = ""
    on error resume next
    StoreText = CStr(theText)
    if (len(StoreText) > 0) Then
      StoreText = Replace(StoreText, """", """, 1, -1, 1)
      StoreText = Replace(StoreText, "'", "''", 1, -1, 1)
      StoreText = Replace(StoreText, vbCrLf, "<BR>", 1, -1, 1)
    end if
  End Function

Use it like so:
storeText(trim(request.form("yourFieldName")))

Wind is your friend
Matt

I tried that function. But it does not solve the issue.
If the input is a double quote, how to handle that?

When I pass that sql statement(with quote), it does not work.

dbConn.Execute sqlStatement ' this won't work

As I said - "What exactly are the behaviours, error??"

;;If the input is a double quote, how to handle that?
This part of the function handles that (yes it does work):
StoreText = Replace(StoreText, """", "&quot;", 1, -1, 1)

comment out the execute line, print your statement to the browser and post it for a solution. Do you use SQL Server? If so open query analyser, run your query - what is the error?

Wind is your friend
Matt