?
Solved

HTML Generator for a form field

Posted on 2003-03-12
9
Medium Priority
?
471 Views
Last Modified: 2010-04-25
I have a database storing various informtaion that is displayed on the page, now for one line or so it is fine, but i want to give th use more flexibility over what the text looks like.

Is there an extension or something i can use to make the process easier.  I am running an access 2002 database with asp pages. I know it can be done because the web wiz guide guestbook and forums use it.  Even simple things like adding bold, center and underline italic would be start.

My clients have no knowledge of HTML at all and educating them is out of the question.  I can preserve whitespace ok, just this little extra i need, thanks for you help.

To get a better idea of what i mean check out the guestbook sign page here:

http://www.webwizguide.com/guestbook/sign.asp?PagePosition=1

or more complex:

http://www.wa.vanguardia.co.uk/images/forum.gif

Thanks for your time

Marc
0
Comment
Question by:ThrillSeeker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 2

Expert Comment

by:zombeen
ID: 8126443
log on to www.planet-source-code.com and search for "html formatters" or like .. i 'm sure you will find a number of scripts and you can use one according to your needs..

zombeen
0
 
LVL 19

Expert Comment

by:webwoman
ID: 8128858
Actually, you can't. Not with Access. It doesn't store the text in a field that way. You can't even make it bold/italic in Access.

Go ahead, try it. Anything you do for formatting is applied to the ENTIRE field, not particular characters.

So it's not a limitation of ASP (though it's a limition of the form fields to some extent), it's a limitation of ACCESS.

>>I know it can be done because the web wiz guide guestbook and forums use it.  

But I doubt they're using Access, and I'd bet $$$$ that they're using a formatting script BEFORE they store it in the database. I would.
0
 

Author Comment

by:ThrillSeeker
ID: 8129723
Dont meant to be rude, maybe my question was not clear enough.  

I need to find some sort of formating script. I know the limitations of the access database and know for a fact (as i use it) that the data is stored in the database as HTML.  What i need is the script that writes the html for you as my client has no HTML knowlegde at all.

The public domain HTML editor is a great extension but is far too complicated and invloved.

Thanks

Marc
0
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

 

Expert Comment

by:WebDevAng
ID: 8131440
ThrillSeeker,

If you add certain fields to your database tables such as:

fldBackgroundColor
fldFontSize
fldFontWeight

Then you can store information.

So if you have
fldBackgroundColor = "#000000"
fldFontSize="10"
fldFontWeight="bold"

Then you could add the following to your page:
(And assuming you can get the recordset from the db to the page)

<table bgcolor="<%=rsFormat("fldBackgroundColor")%>">
<tr>
<td style="font-size:<%=rsFormat("fldFontSize")%>pt;font-weight:<%=rsFormat("fldFontWeight")%>">This is the text</td>
</tr>
</table>


A better example would probably be:

<%
'Get your recordset here
DIM fldBackgroundColor, fldFontSize, fldFontWeight
'If no background was set then assures it is set to white eliminating nulls and errors
IF LEN(rsFormat("fldBackgroundColor")) > 0 THEN
fldBackgroundColor = rsFormat("fldBackgroundColor")
ELSE
fldBackgroundColor = "#FFFFFF"
END IF
'If font size is null then sets it to 10
IF LEN(rsFormat("fldFontSize")) > 0 THEN
fldFontSize= rsFormat("fldFontSize")
ELSE
fldFontSize= "10"
END IF

'If fldFontWeight is null then sets it to normal
IF LEN(rsFormat("fldFontWeight")) > 0 THEN
fldFontWeight= rsFormat("fldFontWeight")
ELSE
fldFontWeight= "normal"
END IF
%>
<table bgcolor="<%=fldBackgroundColor%>">
<tr>
<td style="font-size:<%=fldFontSize%>pt;font-weight:<%=fldFontWeight%>">This is the text</td>
</tr>
</table>
0
 

Author Comment

by:ThrillSeeker
ID: 8132381
Again off track.

What i want is the ability to use something along the lines of the PhBB code generator for one form field only.  What i want the user to be able to do is click on the bold button and the <B></B> tags are inserted into the the field so the user only has to put the text they want in bold in between the tags.  Same for italics, font and alignment.  Also the ability to add hyperlinks, imagae tags and colour would be nice.  I dont want to format the whole page, just the text that is going into the field.  Which will then be stored and retrieved to be displayed on part of another page.

Marc
0
 
LVL 19

Expert Comment

by:webwoman
ID: 8133823
That's all well and good, but there ISN'T any form input that will do this. NONE. If you have a standard form field, which is what you NEED to have, you can only have straight ASCII text. NO formatting at all.
0
 
LVL 5

Expert Comment

by:zenlion420
ID: 9907863
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: webwoman {http:#8128858}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

zenlion420
EE Page Editor
0
 

Author Comment

by:ThrillSeeker
ID: 9907922
I have found the answer to my question!!  Its an online WYSIWIG HTML editor!!   There is an asp.NET one that can store its HTML in a database field and upload any pictures necessary.

A search for online wysiwig HTML editor will bring up loads of options!

Thanks

Marc
0
 
LVL 1

Accepted Solution

by:
GhostMod earned 0 total points
ID: 9952912
PAQed, with points refunded (125)

GhostMod
Community Support Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question