Well Tim, how about you add a link on http://dbi.perl.org/ to the DBI doc: http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm
When you look for the DBI mod doc on CPAN by 'name' here http://www.cpan.org/modules/ And click on 'DBI', you get a list of several files..and none are too useful. However, if you click 'CPAN Search' on http://www.cpan.org/modules/ And enter 'DBI', you get the link to http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm Which was just what I was looking for reference to the info I need....that would probably take care of most stupid people's questions such as mine! Thanks! - christa -----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 12:53 PM To: Hastie, Christa Cc: '[EMAIL PROTECTED]' Subject: Re: :: delimiting apostrophes to insert data w/o errors :: 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.
