Hi,

My question is that can i enter a link to a page like
<a href= "page.htm"> page </a> as a value into access database?



<%
  dim objConn
  Set objConn = server.CreateObject("ADODB.Connection")

  objConn.connectionstring = strConnect
  objConn.open

sqlquery = "INSERT INTO searchtable (search_results)
values ('<a href= "page.htm"> page </a>')
objconn.execute(sqlquery)
objconn.close
%>

and if i can, i dont know if the values should be in single quotes or double quotes. thanks.

Well, it is possible to insert HTML in to a database; after all it is just a string.

However you are right one has to be very carefull with the quotes, but that is not only when inserting HTML. I have had problems myself when typing single quotes into the database. You probably have to escape the quotes before inserting, and possibly also upon retrieval.

Hope this helps!?

Jacob.

...ohhh.

I forgot to say that the quotes problem is more an issue of the construction of the sql string, than it is an issue of the actual insertion in the database.

Jacob.