List:General Discussion« Previous MessageNext Message »
From:Chris Lott Date:June 19 1999 4:03pm
Subject:Re: Storing HTML text
View as plain text  
> Since you are (apparently) going to be using a script to retrieve your
> data and generate the HTML pages, why don't you also use a script to
> read your data and insert it in the first place?  There's no reason
> you have to use LOAD DATA to put in your data.

I'm going to use PHP to build the pages and retrieve the data. I can use PHP
to insert the data... but I am looking for a way to convert a large amount
of legacy data that has been, up to now, stored in Microsoft Access db's
using a combination of fields including memo fields for the pages of text.
My first thought was to dump them into some delimited format and import them
via LOAD DATA, but this fails because of the variable length of the memo
fields...

I will look into using PHP to read the files and insert the data... or
perhaps find a Perl guru to help do something if that is the direction I
have to take.

c
--
@whois: Chris Lott | chrisl@stripped | p907.474.6350 | fx.x.6841
@title: IT Specialist | University of Alaska
@quote: Philosophy n. A route of many roads leading from nowhere to nothing


Thread
Storing HTML textChris Lott19 Jun
  • Re: Storing HTML textPaul DuBois19 Jun
    • Re: Storing HTML textChris Lott19 Jun
      • Re: Storing HTML textPaul DuBois19 Jun
    • Re: Storing HTML textGarrick Staples19 Jun
    • Re: Storing HTML textJay J19 Jun
    • Re: Storing HTML textJay J19 Jun
  • Re: Storing HTML textRobert Hazeltine20 Jun
Re: Storing HTML textTomas Garcia Ferrari21 Jun
Re: Storing HTML textPinkeshP21 Jun
Re: Storing HTML textTomas Garcia Ferrari22 Jun