On Tue, Oct 15, 2002 at 11:44:54AM -0700, Hastie, Christa wrote:
> Hello!
> I bet there is some really simple DBI function/reg ex that delimits the
> apostrophes like such (\') so data can be inserted into the db without
> errors.
>
> i.e. this string:
> INSERT INTO db (SomeColumn) VALUES ('John's car is cool!')
>
> becomes:
> INSERT INTO db (SomeColumn) VALUES ('John\'s car is cool!')
>
> Anybody know the function/reg ex for this?
Others have answered your question, so I'll ask you some...
Do you have the DBI documentation?
Have you read it?
Was there a problem finding the answer in the documentation?
Was it unclear? Too hard to read/search?
I'm honestly curious and I don't mean to pick on you. I'm always
puzzled by the number of people who ask questions clearly (hopefully)
answered by the documentation. So I'd like to understand why it's
easier to ask several thousand people (on dbi-users) to help you
rather than help yourself. If it's because there's a problem with
the documentation, either the text of the documentation being
unclear, or getting access to it, then that needs to be fixed so
we can make life easier for many others.
Tim.
