Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Store HTML document in TextField
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01278994
Message ID:
01279000
Vues:
12
Use parameters
INSERT INTO NoteCab(pk, Notes) VALUES (?lnPk, ?lcDataToStore)
>Our system is uses a control, that allows for the data to be exported to HTML. I need to store the HTML document in the database once it is produced. I have a table called NoteCab with a field called NoteData which is a text field. I thought I could just use the:
>
>lcDataToStore=FileToStr('myDocument.HTM')
>
>and insert that. But because the HTML document has quotation marks and such, it fails on the insert. Is there a way to store the actual document into the database. We can't just have a file pointer stored, we have to have the actual document.
>
>Thanks for any pointers
>
>Kirk
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform