Textarea input issue

[oaklandar]

I have a form that uses a memo field (using a textarea) to populate my Access 2000 database. The form works great but if someone copies from an Internet Browser page into my form memo field it doesnt insert the data into my Access database and gives me a sql error. The Cold Fusion sql errors shows the data that is copied from an internet browser and it has weird characters that look like greek characters. Is this a translation problem that can be fixed somehow??

It does this with both my Netscape 7 and IE 6 Browser.

Please advise if there is something I can do to fix this?

 

[inlandpac]

not 100% sure, but the passed content needs to be cleansed before attempting to insert it into the database.

The problem here is that when someone copies content from a web page, there is very good chance that hidden characters will be present which when translated on the server side come back in strange ways.

Just pass the posted text through a filter to make sure it is text only.

ICQ: 54380631