Cleaning html-code

  • Thread starter Thread starter mogens
  • Start date Start date
M

mogens

I have a database (oscommerce) where html-code is being stored in some
of the database fields. When printing for instance an invoice using
MS-Access, as an alternative to the build in invoice report, I get this
html-code included in the report output. Therefore I would like to know
if there is an automatic procedure to clean this out?

Mogens
 
mogens said:
I have a database (oscommerce) where html-code is being stored in some of
the database fields. When printing for instance an invoice using MS-Access,
as an alternative to the build in invoice report, I get this html-code
included in the report output. Therefore I would like to know if there is
an automatic procedure to clean this out?
Click to expand...

No, you need to prevent the erroneous values from getting to some control on
the Report. You can be sure it is not Access sitting there, trying to figure
out ways to complicate your life, and deciding that "it would be interesting
to see mogens squirm if I replaced some valid data with HTML". The first
step is to determine why/how the HTML is getting into the database records
that you are reporting.

Could you clarify just what, specifically, you mean by, "When printing for
instance an invoice using MS-Access, as an alternative to the build in
invoice report, I get this html-code included in the report output."?

Larry Linson
Microsoft Access MVP
 
Larry said:
No, you need to prevent the erroneous values from getting to some control on
the Report. You can be sure it is not Access sitting there, trying to figure
out ways to complicate your life, and deciding that "it would be interesting
to see mogens squirm if I replaced some valid data with HTML". The first
step is to determine why/how the HTML is getting into the database records
that you are reporting.

Could you clarify just what, specifically, you mean by, "When printing for
instance an invoice using MS-Access, as an alternative to the build in
invoice report, I get this html-code included in the report output."?

Larry Linson
Microsoft Access MVP
Click to expand...

The database I'm using is a MySQL database for an oscommerce website. In
oscommerce there are printout routines for the invoices on a per order
basis.

What I need to produce is a daily set of packing lists and invoices for
my warehouse (for pick/pack and despatch purposes). So I will make my
own version of the invoice report using MS-Access in stead of using the
php-code normally generating these invoices. Then I can also batch
produce invoices as this is quite timeconsuming to do otherwise.

For various reasons, the oscommerce programmers have chosen to put some
html-code around the text, or to be more precise: There are in some text
strings a "<b>" and "</b>" at beginning/end. No other types of
html-codes. Of course this is fine for oscommerce intended use, but for
my purpose it's a "pain in the ass" ;-)

Mogens
 
Back
Top