|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Re: Replace problemHi,
Actually I think I have an idea what AZNewsh is doing. He is using a familiar technique to clean up his HTML before it enters the database. Something similar to preventing SQL Injection, I think. So, he is converting a single quote to 2 single quotes, and when retrieving data back from the database, he is converting the 2 single quotes back to a single quote. Though I have no idea why he could be getting an "inverted question mark" (Yes, that's what it's called, according to Charmap.) Regards, Cerebrus. Correct that is exactly what I am trying to do, it works fine in so far
as it cleans up the quotes before entering the database. I have since been informed that it doesn't actually replace with 2 single quotes, just fools Oracle somehow, so i actually don't need to reverse it, it does however even look like a an inverted question mark even in the database when viewed through Toad, haven't tried SQL Plus but expect the same, I did put a replace in place that will now convert the inverted question mark back to an apostrophe, when selecting and this works but seems like a rather none elegant solution Any thoughts? AZNewsh
Show quote
Hide quote
"AZNewsh" <g*@dana.ucc.nau.edu> wrote in message ISTR that Oracle has weird notions about some characters, including news:1144105532.700634.283530@i39g2000cwa.googlegroups.com... > Correct that is exactly what I am trying to do, it works fine in so far > as it cleans up the quotes before entering the database. I have since > been informed that it doesn't actually replace with 2 single quotes, > just fools Oracle somehow, so i actually don't need to reverse it, it > does however even look like a an inverted question mark even in the > database when viewed through Toad, haven't tried SQL Plus but expect > the same, I did put a replace in place that will now convert the > inverted question mark back to an apostrophe, when selecting and this > works but seems like a rather none elegant solution > > Any thoughts? wildcards. It also has optional character map pages. Don't know if it helps. 
Other interesting topics
Derived TextBox
adding items to a listbox that are null problem Folder size in VB.NET? Financial.Rate Cannot calculate rate using the arguments provided which is better Problem with - Edit Item of Collections.Generic.List(Of SearchAreaListItem) Shell to DOS Abstract/Base Class Best Practices - Help Instance of derived class does not show public methods or properties that are not in the inherited c How to read S.M.A.R.T. attributes in vb ? |
|||||||||||||||||||||||
