Elma
Posts: 1
|
| Posted: 02/23/2006, 11:53 AM |
|
I get this error when using the OLE DB provider for SQl Server and when I tried to paste Test—string
into a textarea .
When I changed the Provider to MSDASQL the same text was saved without a problem
I need to use the OLE DB provider , Cna you help me fix this issue
Tx
_________________
Elma |
 |
 |
Alistair
|
| Posted: 06/17/2006, 3:45 AM |
|
Elma
I'm having exactly the same problem when users paste content from word into a textarea - apostrophes seem to be the cause of the problem. Did you ever find the answer to this, or can anyone else help?
Thanks
|
|
|
|
marcwolf
Posts: 361
|
| Posted: 06/19/2006, 4:39 PM |
|
Hi..
I use MySQL but have had a similar issue.
I got around it either by 2 ways.
1. Writing a little filter to conver single ' to double '. Or I think that putting a forward slash brefore the ' will save it as a single ' in the db. Either way it a little conversion vb code.
2. Define the DB field as a memo rather than a string. That was CCS's internal ADO code will use a parameter rather than a string ans process it accordingly.
Hope this helps - have a look for escape codes for SQL for problemaic characters ' "
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
|
