DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Replace function in SQL

  1. #1
    Join Date
    Oct 2004
    Location
    Ottawa, Canada
    Posts
    1

    Lightbulb Replace function in SQL, or only PL/SQL

    Hello,

    We have a JSP application using ORACLE db and SQL. It runs on Tomcat 1.4. We were using NS 4.7 and made it compatible with IE 6.0.
    The biggest problem we've seen so far it that the archived HTML files don't look right in the newer browser because of its different interpretation of the input field size. We were thinking about using a parsing function in <body> tag, just to display the text without forms. My question is: how I can select the HTML file from the db and in the SQL query replace
    <body onLoad="calcTotal();"> with <body onLoad=" parseDoc(document);calcTotal();">.

    Or it will be better to update the table with all archived HTML files inside the database. Something like:
    UPDATE CLAIM_HISTORY SET HTML_FILE …?…WHERE …
    <body onLoad="calcTotal();"> with <body onLoad=" parseDoc(document);calcTotal();">.

    Ufortunately I missed inportant detail - the field that stores html is of type LONG.
    On client side it stores legacy data - html page with user input (there was some business case to do it that way)
    The question is - what would be the best way to edit field of datatype LONG - SQL, PL/SQL, dump it to the bunch of files and edit by Perl, ... ?
    Please, maybe you have another solution; thank you very much for any recommendations.

    Finaly, we found the way just by adding the parsing function in JavaScript code after <%= htmlFile %>.

    Caterina,
    Last edited by Caterina; 10-19-2004 at 02:31 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center