On Tue, Oct 15, 2002 at 01:00:59PM -0700, Hastie, Christa wrote: > 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
Look closely: http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm#GETTING_HELP > 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. As you've probably discovered now, search.cpan.org is much much better than www.cpan.org. > 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! If you have perl installed then you should have the perldoc command installed so you can read the DBI docs by running "perldoc DBI". No need to use the web. Tim. > 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.
