Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 1st, 2007, 08:21 AM
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to store and retrieve formatted strings in db

I have to display chemical equations and algebric equations on html page.
These equations are the part of the questions in an online examination.
i don't want to use images for performance considerations.
The questions are being composed offline and uploaded to offline database-SQL Server.

My Problem is:

How can i store formatted strings in database involving special characters and superscript and subscript?

How can we retrieve the string from database along with formatting to display them correctly?



 
Old March 1st, 2007, 08:48 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Encode speical chars as their HTML equivelant. For example an: & would become &amp

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
 
Old March 9th, 2007, 07:27 AM
Authorized User
 
Join Date: Jan 2007
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to saurabhj Send a message via Yahoo to saurabhj
Default

Yes dparsons. It is called Escape Sequences..

-Saurabh





Similar Threads
Thread Thread Starter Forum Replies Last Post
Store and Retrieve Images in SQL Database derekl ASP.NET 1.0 and 1.1 Professional 4 December 19th, 2007 03:16 AM
How to store image in oracle database and retrieve y.suresh JSP Basics 1 February 28th, 2005 07:01 AM
Storing and Displaying Formatted Strings anubhav.kumar Classic ASP Professional 17 October 26th, 2004 10:17 PM
Retrieve and store the images from server URL ccc_storage Classic ASP Professional 13 August 19th, 2004 07:28 AM
How do you store and retrieve a hierachy Hubman Pro VB.NET 2002/2003 0 August 4th, 2003 09:37 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.