<br><div class="gmail_quote">On Thu, Oct 14, 2010 at 1:37 PM, scouic <span dir="ltr"><<a href="mailto:scouic@gmail.com">scouic@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> <br>"<p>My comment, visit <a href="<a href="http://www.example.com" target="_blank">www.example.com</a>">foo</a>, this is good</p>" it creates a paragraph with a link.<br> However, there is a big problem. I put this string into my sqlite database, and when i want to display it on the web page, it's via ,(post-display! a-blog a-post)<br>Into the database, < is a true <, but when it's written into the web page, < become &lt; and > become &gt; ... so I can't create links, put images ...<br> <br></blockquote><div><br></div><div>This is due to the file being stored as a string in the database and retrieved back out as a string, and strings in xexprs are automatically escaped for HTML markers. </div><div><br> </div><div>To avoid this issue you need to first convert the string into xexpr. You can use the combo of xml and html package to do so (the html package will allow you to handle html fragments that are not well-formed according to xml rules), and then convert it to xexpr. Something like below (sample only - non-working code): </div> <div><br></div><div>(require html xml) </div><div><br></div><div>`(your xexpr here ... ,(xml->xexpr (read-html-as-xml (open-input-string <your_string_here>)) ...)) </div><div><br></div><div>My bzlib/xml planet package wraps up the above so you can call (read-xexpr (open-input-string <your_string_here>)) if that's something you want to explore. </div> <div><br></div><div>Note - as you probably know, there are security issues with directly storing html fragments and render them out unescaped, so you will want to account for them eventually. </div><div><br></div><div>Cheers,</div> <div>yc</div><div><br></div></div>