HI ,
Im creating html code string for saving to a database. An example of a strBody is shown below :

This is a test. Color check <font color="#ff6600">Orange </font><font color="#ff0000">Red </font><font color="#ffff00">Yellow </font>And then <strong>bold</strong>

My problem, is how to I write this to a database field. When I perform the update to table, the only data written in This is a test. Color check <font color=Any help on this would be much appreciated.

cheers
Steve

The problem looks like the quotes. What's your code like?
Personally, I use parameters to pass values to the database - that way you don't run into quoting problems and it also helps protect against SQL Injection attacks.

I can pass html in parameters though can I. Parameter s as I understand are fine with stored procedures. This is html code I want to store in a table and thus replicate later.

My code simply can be

strBody="This is a test. Color check <font color="#ff6600">Orange </font><font color="#ff0000">Red </font><font color="#ffff00">Yellow </font>And then <strong>bold</strong>"

SQL Parameters aren't restricted to Stored Procedures. I use them in SQL statement strings all the time. Not sure how they work in classic ASP, but this is an example of how I'd do it in .NET:

publicDataSet GetMessagesByDate(int UserID, DateTime MyDate)
{
string SQL = "SELECT Messages.Msg_ID, Messages.Msg_DateTime, Messages.Msg_Read, InternalUsers.User_FirstName, InternalUsers.User_LastName, ExternalUsers.User_ID, Messages.Msg_Message FROM (Messages INNER JOIN ExternalUsers ON Messages.Msg_MessageFor = ExternalUsers.User_ID) INNER JOIN InternalUsers ON Messages.Msg_AgentID = InternalUsers.User_ID WHERE ExternalUsers.User_ID = @MessageFor AND Messages.Msg_DateTime BETWEEN @DateTime AND @DateTime1 ORDER BY {0} {1}";
SqlParameter pSearchDate = newSqlParameter("@DateTime", SqlDbType.DateTime, 8);
pSearchDate.Value = MyDate;
SqlParameter pSearchDate1 = newSqlParameter("@DateTime1", SqlDbType.DateTime, 8);
pSearchDate1.Value = MyDate + newTimeSpan(23, 59, 59);
SqlParameter pMessageFor = newSqlParameter("@MessageFor", SqlDbType.Int, 4);
pMessageFor.Value = UserID;
returnSqlHelper.ExecuteDataset(
ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString,
CommandType.Text,
SQL,
pMessageFor, pSearchDate, pSearchDate1);
}

(The SqlHelper is a class provided by Microsoft for handling common SQL tasks. Internally, it would create a new SqlConnection object, and an SqlCommand object, then add the parameters to the SqlCommand's parameter list, then call the SqlCommand's ExecuteDataset() method)

I imagine the steps would be simular for ASP, just different syntax and objects.

im sorry but htis doesnt help at all. I understand all this even in .net.
MY problem is transfering physical html code to a field in a table. The problem will still arise if i put into a parameter as that doesnt deal with the double quote.

ok i seem to have got over that. I think my problem was having servevr.htmencoded my strBody twice as I have a check form on the same page. This was confusing me as encoding twice gave weird results.
I have posted another post though becuase although i have written to the file, getting it out rendered seems not to be working.
cheers for your help though