468,544 Members | 1,815 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,544 developers. It's quick & easy.

insert special characters into ms acess database ?

how to insert special characters into ms acess database along with text below is my example
Expand|Select|Wrap|Line Numbers
  1. <!--#include file="common.asp"-->
  2. <!--#include file="header.asp"-->
  3. <%
  4. CheckAdminLogin
  5. if request("submit")="Save" then
  6. OpenDataBase conn
  7. newshead=request("newshead")
  8. newsdes=request("newsdes")
  9.  
  10. if newshead="" or newsdes="" then er=er & "<font color='red' size=4>Headline Cannot be blank</font>"
  11. if er="" then
  12. sql="insert into news(news_titile,news_description) values('" & cstr(newshead) & "' , '" & cstr(newsdes) & "')" 
  13. 'sql="insert into news(news_titile,news_description) values('" & Cstr(newshead) & "','" & Cstr(newsdes) & "' ) "
  14. conn.execute sql
  15. response.write("<font color='green' size=4>News and Top News is Stored Sucessfully</font>")
  16. response.Redirect("addheadlineimage.asp")
  17. else 
  18. response.write er
  19. end if 
  20. end if
  21. if request("submit")="addmore images to previous headlines" then
  22. response.Redirect("listnewsheadline.asp")
  23. end if
  24.  
  25. %>
  26. <form name="addleftnews" action="addleftnews.asp" method="post">
  27. <table align="left"  >
  28. <tr>
  29. <td><a href="listnewsheadline.asp">Add More Images to Previous Headlines</a></td>
  30. </tr>
  31. </table>
  32.  
  33. <table align="center">
  34. <tr><td> HeadLine </td><td><textarea name="newshead" cols="50" rows="2"></textarea></td></tr>
  35. <tr><td> Description</td><td><textarea name="newsdes" cols="50" rows="15"></textarea></td></tr>
  36. <tr><td></td>
  37. <td align="center" bgcolor="#FFFFFF">
  38. <input type="submit" name="submit" value="Save">
  39. </td>
  40.  
  41. </tr>
  42. </table>
  43.  
  44. </form>
Apr 8 '10 #1
1 2648
jhardman
3,405 Expert 2GB
which special characters are giving you trouble? Is it that you are saving HTML encoding?

Jared
Apr 10 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Barry Olly | last post: by
4 posts views Thread by jcsnippets.atspace.com | last post: by
6 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.