Hi Guys,
I was wondering if someone could help me with a problem that im having.
Basically i have a html editor control and im using this to allow my
colleague to create html documents. I want to save this html info as a
string into my database. the problem arises however due to quotation
marks both double and single within my html. I have seen html before
where it does not have the actual quotation mark but somethinp like
"&lquo" (this is probably wrong)
Is there a class in dotnet that will do this for me ?????
any help appreciated
Colin Graham 6 2022
What exactly is the problem? There is no reason why you can't store the HTML
in the database exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ k70g2000cwa.goo glegroups.com.. .
Hi Guys,
I was wondering if someone could help me with a problem that im having.
Basically i have a html editor control and im using this to allow my
colleague to create html documents. I want to save this html info as a
string into my database. the problem arises however due to quotation
marks both double and single within my html. I have seen html before
where it does not have the actual quotation mark but somethinp like
"&lquo" (this is probably wrong)
Is there a class in dotnet that will do this for me ?????
any help appreciated
Colin Graham
thanks kevin
do you think its just a matter of stripping out the double quotes with
some sort of replace method ???
im still curious on how to convert the html into the other html format
any ideas or pointers ???
thanks again
colin
Kevin Spencer wrote:
What exactly is the problem? There is no reason why you can't store the HTML
in the database exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ k70g2000cwa.goo glegroups.com.. .
Hi Guys,
I was wondering if someone could help me with a problem that im having.
Basically i have a html editor control and im using this to allow my
colleague to create html documents. I want to save this html info as a
string into my database. the problem arises however due to quotation
marks both double and single within my html. I have seen html before
where it does not have the actual quotation mark but somethinp like
"&lquo" (this is probably wrong)
Is there a class in dotnet that will do this for me ?????
any help appreciated
Colin Graham
You don't need to strip out anything. You can store the HTML in the database
exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...
thanks kevin
do you think its just a matter of stripping out the double quotes with
some sort of replace method ???
im still curious on how to convert the html into the other html format
any ideas or pointers ???
thanks again
colin
Kevin Spencer wrote:
>What exactly is the problem? There is no reason why you can't store the HTML in the database exactly as it is.
-- HTH,
Kevin Spencer Microsoft MVP Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with a man with a wooden leg named Smith who shot an elephant in my pajamas. So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message news:11******* *************** @k70g2000cwa.go oglegroups.com. ..
Hi Guys,
I was wondering if someone could help me with a problem that im having.
Basically i have a html editor control and im using this to allow my
colleague to create html documents. I want to save this html info as a
string into my database. the problem arises however due to quotation
marks both double and single within my html. I have seen html before
where it does not have the actual quotation mark but somethinp like
"&lquo" (this is probably wrong)
Is there a class in dotnet that will do this for me ?????
any help appreciated
Colin Graham
well that just wont work - it simply throws me an error in my SQL
string. i think this is because im using double quotes in my html. what
is the best way to do this ???
thanks again
Kevin Spencer wrote:
You don't need to strip out anything. You can store the HTML in the database
exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...
thanks kevin
do you think its just a matter of stripping out the double quotes with
some sort of replace method ???
im still curious on how to convert the html into the other html format
any ideas or pointers ???
thanks again
colin
Kevin Spencer wrote:
What exactly is the problem? There is no reason why you can't store the
HTML
in the database exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ k70g2000cwa.goo glegroups.com.. .
Hi Guys,
I was wondering if someone could help me with a problem that im having.
Basically i have a html editor control and im using this to allow my
colleague to create html documents. I want to save this html info as a
string into my database. the problem arises however due to quotation
marks both double and single within my html. I have seen html before
where it does not have the actual quotation mark but somethinp like
"&lquo" (this is probably wrong)
Is there a class in dotnet that will do this for me ?????
any help appreciated
Colin Graham
You need to use SQL parameters -- don't build the SQL statement by
hand, it's not safe.
dim ParmHTMLtext as new sqlparameter
....
command.paramet ers.add(ParmHTM L)
Steve
csgraham74 wrote:
well that just wont work - it simply throws me an error in my SQL
string. i think this is because im using double quotes in my html. what
is the best way to do this ???
thanks again
Kevin Spencer wrote:
You don't need to strip out anything. You can store the HTML in the database
exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...
thanks kevin
>
do you think its just a matter of stripping out the double quotes with
some sort of replace method ???
>
im still curious on how to convert the html into the other html format
>
>
any ideas or pointers ???
>
thanks again
>
colin
>
Kevin Spencer wrote:
>What exactly is the problem? There is no reason why you can't store the
>HTML
>in the database exactly as it is.
>>
>--
>HTH,
>>
>Kevin Spencer
>Microsoft MVP
>Ministry of Software Development
>http://unclechutney.blogspot.com
>>
>I just flew in from Chicago with
>a man with a wooden leg named Smith
>who shot an elephant in my pajamas.
>So I bit him.
>>
>>
>"csgraham74 " <cs********@gma il.comwrote in message
>news:11******* *************** @k70g2000cwa.go oglegroups.com. ..
Hi Guys,
>
I was wondering if someone could help me with a problem that im having.
>
Basically i have a html editor control and im using this to allow my
colleague to create html documents. I want to save this html info as a
string into my database. the problem arises however due to quotation
marks both double and single within my html. I have seen html before
where it does not have the actual quotation mark but somethinp like
"&lquo" (this is probably wrong)
>
Is there a class in dotnet that will do this for me ?????
>
any help appreciated
>
>
Colin Graham
>
>
Here's an article that explains how to do this: http://www.informit.com/articles/art...p?p=22676&rl=1
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"SteveO" <st************ @gmail.comwrote in message
news:11******** **************@ k70g2000cwa.goo glegroups.com.. .
You need to use SQL parameters -- don't build the SQL statement by
hand, it's not safe.
dim ParmHTMLtext as new sqlparameter
...
command.paramet ers.add(ParmHTM L)
Steve
csgraham74 wrote:
>well that just wont work - it simply throws me an error in my SQL string. i think this is because im using double quotes in my html. what is the best way to do this ???
thanks again
Kevin Spencer wrote:
You don't need to strip out anything. You can store the HTML in the
database
exactly as it is.
--
HTH,
Kevin Spencer
Microsoft MVP
Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with
a man with a wooden leg named Smith
who shot an elephant in my pajamas.
So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...
thanks kevin
do you think its just a matter of stripping out the double quotes
with
some sort of replace method ???
im still curious on how to convert the html into the other html
format
any ideas or pointers ???
thanks again
colin
Kevin Spencer wrote: What exactly is the problem? There is no reason why you can't store the HTML in the database exactly as it is.
-- HTH,
Kevin Spencer Microsoft MVP Ministry of Software Development http://unclechutney.blogspot.com
I just flew in from Chicago with a man with a wooden leg named Smith who shot an elephant in my pajamas. So I bit him.
"csgraham74 " <cs********@gma il.comwrote in message news:11******* *************** @k70g2000cwa.go oglegroups.com. ..
Hi Guys,
I was wondering if someone could help me with a problem that im
having.
Basically i have a html editor control and im using this to allow
my
colleague to create html documents. I want to save this html info
as a
string into my database. the problem arises however due to
quotation
marks both double and single within my html. I have seen html
before
where it does not have the actual quotation mark but somethinp
like
"&lquo" (this is probably wrong)
Is there a class in dotnet that will do this for me ?????
any help appreciated
Colin Graham
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jochen Stuempfig |
last post by:
hello,
i'd like to store text in an database and generate html files with the text
stored in the database. i use dom to generate an xml file and render it
using xsl. i use the following code to render the xsl file.
XmlTextWriter output = new XmlTextWriter("myHtmlFile.html",
System.Text.Encoding.Default);
XmlUrlResolver resolver = new...
|
by: Katie |
last post by:
So I am Microsoft Access User, learning as I go. I need to send a
database back to its author for some adjustments. For security and due
to the size of this database I need to send it as a winzip file. I have
attempted to send it via File, then send to email recipient but it
offers the following formats only: HTML, EXCEL, TEXT FILES, RICH...
|
by: MLH |
last post by:
GHudson has working procedures posted at
http://www.access-programmers.co.uk/forums/showthread.php?t=66320
They work. Relationships, however, and some minor default settings are
not preserved. Reestablishing some default settings and settings is a
small price to pay for a set of text files that may save your database
from total loss #AND#...
|
by: GM |
last post by:
Is it possible to display html stored in a database field into a textarea?
How can you display the html and allow editing?
thanks,
|
by: Merek |
last post by:
Hi all,
We need to allow the user to store, view and edit blocks of rich text
via an ASP.NET application.
After adopting one of the many rich text editors out there that
outputs HTML we are storing that HTML directly in the database. The
problem emerges when we try to feed this data to a reporting solution.
Our current platform,...
| |
by: SemiNoviceProgramer |
last post by:
Dear friends
I started a new project in Visual studio 2005, then I added a database
connection using the wizard (access database)
the problem that when I press the save button on the automatically
generated toolbar nothing saved to my database file, so each time I
restarted the project I found the original dat unmodified
what code should I...
|
by: abhinavjainpassion |
last post by:
is is possable to connact html with oracle database
|
by: palanidharma |
last post by:
hi,
i am new to php . i have creat 4 textbox i am entering value and store the value database.the same name not sotre in database.
reply me plz
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |