MySQLdb insert HTML code error
Anatoli Hristov
tolidtm at gmail.com
Mon Dec 10 19:46:52 EST 2012
> Brilliant, I think your problem is in line 97 of the code that you *HAVEN'T
> QUOTED*. Please go here, read and inwardly digest before you say anything
> else http://www.sscce.org/
:) I thought it was clear. the "spec" is the description and when the
str"spec" contains the html code I'm getting an error, if you don't
want to help then just don't become an..........
This is the str spec:
<html>
<head>
<title>Icecat.biz ProBook 4540s Notebook PC </title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="Keywords" content="ProBook 4540s Notebook PC HP" />
<meta name="Description" content="" />
<link href="http://prf.icecat.biz/css/openicecat-url.css"
rel="stylesheet" type="text/css" />
<style type='text/css'>
.tooltip-text, #tooltip-containeer{display:none;
max-width:/*420*/300px; z-index:100;}
#tooltip-containeer
#tooltip-left-border{background:url('http://prf.icecat.biz/imgs/tip-border-left.png')
repeat-y left; padding-left:18px;}
#tooltip-containeer
#tooltip-right-border{background:url('http://prf.icecat.biz/imgs/tip-border-right.png')
repeat-y right; padding-right:18px;}
#tooltip-containeer #content{padding:0
5px;background:url('http://prf.icecat.biz/imgs/tip-background.png')
repeat; }
#tooltip-containeer #tooltip-top{height:25px; width:100%;}
#tooltip-containeer #tooltip-top .left{height:25px; width:25px;
background:url('http://prf.icecat.biz/imgs/tooltip-top-left.png')
no-repeat top left; position:absolute; left:0;}
#tooltip-containeer #tooltip-top .center{height:25px;
background:url('http://prf.icecat.biz/imgs/tooltip-top-center.png')
repeat-x; position:absolute; left:25px; right:25px;}
#tooltip-containeer #tooltip-top
.right{background:url('http://prf.icecat.biz/imgs/tooltip-top-right.png')
no-repeat top right; height:25px; position:absolute; width:25px;
right:0; }
#tooltip-containeer #tooltip-bottom{/*height:50px;*/ height:25px; width:100%;}
#tooltip-containeer #tooltip-bottom .left{/*height:50px;*/
height:25px; background:url('http://prf.icecat.biz/imgs/tooltip-bottom-left.png')
no-repeat top left; position:absolute; width:25px; left:0;}
#tooltip-containeer #tooltip-bottom .right { /*height:50px;*/
height:25px; background:url('http://prf.icecat.biz/imgs/tooltip-bottom-right.png')
no-repeat right top; position:absolute; width: 25px; right:0;}
/*#tooltip-containeer #tooltip-bottom div:first-child{ height:50px;
background:url('../imgs/tooltip-bottom-center.png') no-repeat center;
position:absolute;width:auto; left:25px; right:25px;}*/
#tooltip-containeer #tooltip-bottom div.center{ height:25px;
background:url('http://prf.icecat.biz/imgs/tooltip-bottom-center-noarrow.png')
repeat-x top; position:absolute;width:auto; left:25px; right:25px;}
</style>
<style type="text/css">
td.ds_header{ background: #D2E6FF }
td.footer { background: #D2E6FF }
.raised .b1 { background: #D2E6FF }
.raised .b2 { background: #D2E6FF }
.raised .b3 { background: #D2E6FF }
.raised .b4 { background: #D2E6FF }
.raised { width: 750 }
td.ds_label {background: #CCCCCC}
td.price_label{background: #CCCCCC}
td.ds_data {background: #FFFFFF}
td.price_data {background: #FFFFFF}
td.image {background: #FFFFFF}
a.footer{color: #1450A0}
.link {color: #1450A0}
.vlink {color: #1450A0}
</style>
<script type="text/javascript">
<!--
function large_img(){
var delta=document.body.scrollWidth-document.body.clientWidth;
var img=document.getElementById("large").width;
document.getElementById("large").width=img-delta;
}
function collect(pr){
var j=0,par=pr;
var product="",coma="";
while(document.forms[par].elements[j]){
if(document.forms[par].elements[j].value>0 &&
/aantal__/.test(document.forms[par].elements[j].name)){
product= product+coma+document.forms[par].elements[j].name;
product= product+"|"+document.forms[par].elements[j].value;
coma=",";
}
j++;
}
if (product){
document.forms[par].elements['product'].value=product;
document.forms[par].submit();
}else{
return;
}
}
function feedback()
{
window.open("http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW;menu=feedback;product_id=15984359;prod_id=C4Z28EA;name=ProBook%204540s%20Notebook%20PC;supp_name=HP;",
"feedback", 'menubar=no,directories=no,location=no,resizable=auto,scrollbars=yes,width=630,height=550');
}
function reg_exp(id){
var re1 = new RegExp("alle");
var re2 = new RegExp("minder");
var str = document.getElementById(id).innerText;
var newstr=str.replace(re1,"minder")
if(str==newstr){
document.getElementById(id).innerText=str.replace(re2,"alle")
}else{
document.getElementById(id).innerText=newstr;
}
}
function reg_exp_rev(id){
if(document.getElementById(id+'l').style.display == 'none'){
document.getElementById(id+'a').style.display = 'none' ;
document.getElementById(id+'l').style.display = '' ;
}else{
document.getElementById(id+'l').style.display = 'none' ;
document.getElementById(id+'a').style.display = '' ;
}
}
function open_send_to_friend()
{
window.open("http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW;mi=start;smi=product_send;shopname=openicecat-url;product_id=15984359;lang=nl",
"send", 'menubar=no,directories=no,location=no,resizable=auto,scrollbars=auto,width=780,height=625');
}
function printWindow(){
bV = parseInt(navigator.appVersion)
if (bV >= 4) window.print()
}
function openimage (url, w, h) {
w += 50;
h += 50;
if(w > 800){ w = 800}
if(h > 600){ h = 600}
window.open(url, "image",
'menubar=no,directories=no,location=no,resizable=auto,scrollbars=yes,width='+w+',height='+h);
}
function show_comments()
{
document.getElementById("hidden_comments").style.display="";
document.getElementById("show_comments").style.display="none";
document.getElementById("hide_comments").style.display="";
}
function hide_comments()
{
document.getElementById("hidden_comments").style.display="none";
document.getElementById("show_comments").style.display="";
document.getElementById("hide_comments").style.display="none";
}
function show_alter(id){
;
reg_exp(id);
}
function show_alters (c){
var alternatives = document.getElementById('alternatives');
if(alternatives.innerText=="Toon alle alternatieven>>"){
alternatives.innerText="Toon minder alternatieven>>";
}else{
alternatives.innerText="Toon alle alternatieven>>";
}
if(document.getElementById(c).style.display==""){
document.getElementById(c).style.display="none";
}else{
document.getElementById(c).style.display="";
}
}
function show_options (c){
if(document.getElementById(c).style.display==""){
document.getElementById(c).style.display="none";
}else{
document.getElementById(c).style.display="";
}
}
function swap_options (opt){
if(opt.innerText=="Toon alle alternatieven>>>>"){
opt.innerText="Toon minder alternatieven>>";
}else{
opt.innerText="Toon alle alternatieven>>";
}
}
function changeTab(tab){
var i;
var t;
for(i=1;i<6;i++){
t="t"+i;
var tabls=document.getElementById(i);
var tabs=document.getElementById(t);
if(i==tab){
tabls.style.display="block";
tabs.className="tab_active";
}else{
tabls.style.display="none";
tabs.className="tab_inactive";
}
}
}
function show_more()
{
document.getElementById("long_desc_more").style.display='none';
document.getElementById("long_desc_less").style.display='';
document.getElementById("more_text").style.display='';
}
function hide_more()
{
document.getElementById("long_desc_more").style.display='';
document.getElementById("long_desc_less").style.display='none';
document.getElementById("more_text").style.display='none';
}
-->
</script>
<script src="http://prf.icecat.biz/js/jquery.js"
type="text/javascript" charset="utf-8"></script>
<script src="http://prf.icecat.biz/js/tooltip_prf.js"
type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
jQuery(document).ready(function() {
jQuery('.tip-anchor').tooltip({
tip: '#tooltip-containeer',
onBeforeShow: function(){
jQuery('#tooltip-containeer #content').empty();
var tipHtml= this.getTrigger().siblings('.tooltip-text').html();
jQuery('#tooltip-containeer #content').append(tipHtml);
},
delay: 50,
offset: [0, -10],
position: 'bottom right'
});
});
</script>
</head>
<!-- <body bgcolor="#FFFFFF" text="#000000" leftmargin="0"
topmargin="0" onload="large_img();"> -->
<body onload="large_img();">
<div id="tooltip-containeer" style="position: absolute; top: 569px;
left: 504px; display: none; ">
<div id="tooltip-top">
<div class="left"></div>
<div class="center"></div>
<div class="right"></div>
</div>
<div id="tooltip-left-border">
<div id="tooltip-right-border">
<div id="content" style="font-size: 11px;font-family: Arial,
Helvetica;"></div>
</div>
</div>
<div id="tooltip-bottom">
<div class="left"></div>
<div class="center"></div>
<div class="right"></div>
</div>
</div>
<br />
<table align="center" cellpadding="0" cellspacing="0"
class="mainTable"><!-- Outer table -->
<tr>
<td>
<table width="100%" cellpadding="0" cellspacing="0"><!-- Inner table -->
<tr><!-- TR1 -->
<td>
<form method="post" name="buy"
action="http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW">
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="70%" valign="top" height="100%">
<table cellpadding="0" cellspacing="0" align="left"
width="100%" > <!-- valign="top" height="100%" -->
<tr>
<td height="20px" bgcolor="#ebebeb" colspan="2">
<table cellpadding="0" cellspacing="0">
<tr>
<td><img src="http://prf.icecat.biz/imgs/marker.gif"
width="17px" height="20px" alt=""/></td>
<td class="main"><!--<a
href="http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW;mi=start"
class="bc">Productvergelijking</a> > -->notebooks</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2">
<table cellpadding="0" cellspacing="0">
<tr>
<td align="left"> <img
src="http://images.icecat.biz/thumbs/SUP1.jpg" width="75px"
height="75px" alt=""/> <!-- valign="center" --></td>
<td class="titlegev" width="100%"><h1>HP ProBook 4540s
Notebook PC</h1></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#ebebeb" height="5px">
<img src="http://prf.icecat.biz/imgs/0.gif" width="5px"
height="5px" alt=""/>
</td>
</tr>
<tr>
<td height="36px" class="vendor" style="line-height:20px">
<!-- <b>Datasheet-kwaliteit:</b> aangemaakt door
HP<br/>--><b>Merk:</b> HP <br /><b>Artikelcode:</b>
C4Z28EA<br/><b>Categorie:</b> notebooks<span style="display:
none"><br/><b>%%lang_extra_info%%:</b> </span><span
style="display:"><br /><b>EAN/UPC-nummer:</b> 0887111545718,
0887111590787, 0887111545725, 0887111736246<br/></span>
</td>
<td align="right" width="40%">
<input type="hidden" name="clickthrough_statistic" value="1" />
<input type="hidden" name="shop_buy_url"
value="http://www.openicecat.org?" />
<input type="hidden" name="action" value="cpq_add_to_cart" />
<input type="hidden" name="shopname" value="openicecat-url" />
<input type="hidden" name="customer" value="" />
<input type="hidden" name="icecat_id" value="15984359" />
<input type="hidden" name="product" value="C4Z28EA" />
<input type="hidden" name="sessid"
value="Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW" />
<table style="display:" cellpadding="0" cellspacing="0">
</table>
</td>
</tr>
<tr>
<td bgcolor="#ebebeb" colspan="2" height="5px">
<img src="http://prf.icecat.biz/imgs/0.gif" width="5px"
height="5px" alt=""/>
</td>
</tr>
<tr>
<td colspan="2" style="padding-left: 10px">
<p style="padding: 0px"></p>
<p style="padding: 0px"></p>
<p style="padding: 0px"></p>
<!-- <p style="padding: 0px"></p> -->
</td>
</tr>
</table>
</td>
<td width="30%" height="100%" valign="top">
<table cellpadding="0" cellspacing="0" align="right"
valign="top" width="100%" height="100%"
style="display:%%show_image%%">
<tr>
<td class="image" align="center" valign="middle">
<table cellpadding="5px" cellspacing="0"
bgcolor="#ffffff" align="center" valign="middle">
<tr>
<td align="center"> <a
href="javascript:openimage('http://images.icecat.biz/img/norm/high/15984359-HP.jpg',400,400)"
class="main"> <img
src="http://images.icecat.biz/img/norm/low/15984359-HP.jpg" vspace="0"
hspace="0" border="0" width="200" id="large"
alt=""/><br/>34k</a><br/></td>
<td align="center"></td>
</tr>
<tr>
<td align="center"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="main" width="100%" colspan="2" style="font-size:
11px; padding-left: 10px;">
<div style="font-size: 90%;display:none;border:solid green 1px;">
<table cellspacing=0 cellpadding=0 border=0 width="100%"
style="border:solid #efefef 2px">
<tr>
<td class="ds_data"
style="display:none;vertical-align:middle;padding:5px;">
<a href="http://"><img
src="http://icecat.biz/imgs/empty.gif"></a>
</td>
<td colspan="2" class="ds_data"
style="font-size:70%;padding-left:5px;" align="left" width="99%">
<a href="http://"><b> </b></a>
<!-- -->
<div style="display:none"><br><b>Campagneperiode
:</b></b> 01 Jan 1970 - 01 Jan 1970</div>
<div style="display: none ;"><br></div>
<a href="http://">Meer informatie</a>
</td>
<td align="left" valign="top">
<img src="http://icecat.biz/imgs/attention_trans.gif">
</td>
</tr>
</table> </div>
<br/>
<p class="main"></p>
HP ProBook 4540s Notebook PC
<img src="http://prf.icecat.biz/imgs/tip-anchor.png"
class="tip-anchor" alt="">
<div class="tooltip-text">This is an auto-generated long
summary based on the first three features of the first five feature
groups.</div>
<br/><br/>
</td>
</tr>
</table>
</form>
</td>
</tr> <!-- TR1 end -->
<tr>
<td>
<br/>
</td>
</tr>
<tr><!-- TR3 -->
<td align="center" colspan="2">
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td align="left">
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><img height="22px"
src="http://prf.icecat.biz/imgs/tabs.gif" alt="" /></td>
<td width="12%" valign="bottom" style="display:"><div
onclick="changeTab(1)" style="display:block" class="tab_active"
id="t1">Specs</div></td>
<td width="12%" valign="bottom" style="display:none"><div
onclick="changeTab(2)" class="tab_inactive"
id="t2">Alternatieven</div></td>
<td width="12%" valign="bottom" style="display:none"><div
onclick="changeTab(3)" class="tab_inactive" id="t3">Opties</div></td>
<td width="12%" valign="bottom" style="display:none"><div
onclick="changeTab(4)" class="tab_inactive" id="t4">Video</div></td>
<td width="12%" valign="bottom" style="display:none"><div
onclick="changeTab(5)" class="tab_inactive" id="t5">Reviews</div></td>
<td background="http://prf.icecat.biz/imgs/tabs.gif"
width="100%"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" class="specs">
<table align="center" valign="top" cellspacing="0"
cellpadding="0" id="1" style="display:block" width="97%">
<tr>
<td colspan="2" >
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td width="48%" valign="top">
<table cellpadding="0" cellspacing="0" width="100%">
</table>
</td>
<td width="48%" valign="top">
<table cellpadding="0" cellspacing="0" width="100%">
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 0; text-align: center;">
<img src="http://prf.icecat.biz/imgs/0.gif" height="10px" alt="" />
</td>
</tr>
<tr>
<td align="center" style="padding-bottom: 10px;
padding-right: 5px;" valign="middle">
<form method="post"
action="http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW">
<input type="hidden" name="clickthrough_statistic" value="1" />
<input type="hidden" name="shop_buy_url"
value="http://www.openicecat.org?" />
<input type="hidden" name="action" value="cpq_add_to_cart" />
<input type="hidden" name="shopname" value="openicecat-url" />
<input type="hidden" name="customer" value="" />
<input type="hidden" name="icecat_id" value="15984359" />
<input type="hidden" name="product" value="C4Z28EA" />
<input type="hidden" name="sessid"
value="Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW" />
<span style="display: ">
<input type="hidden" value="Bestel" class="bt"
style="width:160; height: 30; color: #ff0000; border-color: #ff0000"
/>
</span>
<input type="button" class="bt" value="Print deze
datasheet" onClick="printWindow()" />
<input type="button" class="bt" value="Mail deze
datasheet" onClick="open_send_to_friend()" />
</form>
</td>
</tr>
</table>
<div id="2" style="display: none; padding: 5px">
<table width="97%" align="center" valign="top"
cellspacing="0" cellpadding="0" style="padding: 5px">
<tr><td></td></tr>
</table>
</div>
<div width="100%" id="3" style="display: none; padding: 5px">
<table width="97%" align="center" valign="top"
cellspacing="0" cellpadding="0" style="padding: 5px">
<tr><td></td></tr>
</table>
</div>
<div width="100%" id="4" style="display: none; padding: 5px">
<table width="97%" align="center" valign="top"
cellspacing="0" cellpadding="0" style="padding: 5px">
<tr><td></td></tr>
</table>
</div>
<div width="100%" id="5" style="display: none; padding: 5px">
</div>
<div id="6" style="display:none">
</div>
</td>
</tr>
</table>
</td>
</tr><!-- TR3 end -->
<tr>
<td>
<br />
</td>
</tr>
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<form method="post"
action="http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW">
<table align="center" cellpadding="0" cellspacing="0"
valign="top" style="display: none" >
<tr>
<td>
<input type="hidden" name="mi" value='start' />
<input type="hidden" name="smi" value='product' />
<input type="hidden" name="product_id" value="15984359" />
<input type="hidden" name="sessid"
value="Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW" />
<table width="100%" align="center" valign="top"
cellspacing="1" cellpadding="0" bgcolor="#ffffff" style="display:
none">
<tr bgcolor="#ffffff" style="display:none">
<td align="center"><font color="red" class="titlegev"></font></td>
</tr>
</table>
</td>
</tr>
</table>
<table align="center" cellpadding="0" cellspacing="0"
style="display: none" >
<tr>
<td class="ds_header" >%%lang_user_comments%%</td>
</tr>
<tr>
<td class="ds_label" >Neem voor productvragen contact op
met <a href="mailto:info at icecat.biz" class="mainbold"
style="font-size: 100%">support</a>.</td>
</tr>
<tr>
<td>
<table width="100%" cellpadding="0" cellspacing="0"
style="display: none">
<tr>
<td width="30%" class="ds_label" >Uw emailadres</td>
<td><input class="ds" type="text" name="email" /></td>
</tr>
<tr>
<td class="ds_label" >Reactie:</td>
<td><textarea class="ds" name="comment" cols=""
rows=""></textarea></td>
</tr>
<tr>
<td class="ds_label" colspan="2"><font
color=red>*</font>Neem a.u.b. de grote cijfers of letters over in het
invoerveld</td>
</tr>
<tr>
<td class="ds_label">
<img
src="http://icecat.biz/imgs/pict.cgi?d465f14a648b3d0a1faa6f447e526c60"
alt="" >
<input type="hidden"
value="d465f14a648b3d0a1faa6f447e526c60" name="id_anti_robot_code">
</td>
<td class="ds_label">
<input class="ds" type="text"
name="anti_robot_code">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 0"><img
src="http://prf.icecat.biz/imgs/reviews_line.gif" alt=""/></td>
</tr>
<tr>
<td align="center">
<input type="submit" class="bt" name="post_comment"
value="%%lang_send_comments%%" align="center" />
</td>
</tr>
</table>
</form>
</td>
<td style="padding-left: 10px;display:none;" valign="top">
<table cellpadding="0" cellspacing="0" style="display:none;" >
<tr>
<td class="ds_header" style="display:none">Productdemo</td>
</tr>
<tr>
<td class="ds_label" align="left">
<table cellpadding="0" cellspacing="0"><tr><td></td></tr></table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table><!-- Inner table end-->
</td>
</tr>
</table><!-- Outer table end -->
<!-- This Icecat template is used for creation of footer and finishing HTML-->
<center>
<div class="raised" >
<!-- <b class="b1"></b>
<b class="b2"></b>
<b class="b3"></b>
<b class="b4"></b> -->
<div class="boxcontent" >
<table width="100%" align="center" height="22px" cellpadding="0"
cellspacing="0" >
<tr>
<td width="2px" class="footer" style="padding-left:0;"><img
src="http://prf.icecat.biz/imgs/foot_left.gif" alt=""/></td>
<td align="center" width="100%" class="footer">
Copyright © 2002-2012 <a target="_blank" class="bc"
style="font-size: 100%" href="http://www.icecat.biz">Icecat.biz</a> |
<a target="_blank" class="bc"
href="http://prf.icecat.biz/index.cgi?sessid=Yeg7EzDPOLQri2cKoC4vbnXi8UfV9MRVwhZkmLBLXMiyGQRW;mi=icecat"
style="font-size: 100%">Disclaimer</a>
<a href="#" onclick="feedback()" class="bc"
style="font-size: 100%">Meld redactionele fout aan Icecat</a>
</td>
<td class="footer" width="2px" style="padding-left:0;"><img
src="http://prf.icecat.biz/imgs/foot_right.gif" alt="" /></td>
</tr>
</table>
</div>
<!-- <b class="b4"></b>
<b class="b3"></b>
<b class="b2"></b>
<b class="b1"></b> -->
</div>
</center>
</body>
</html>
More information about the Python-list
mailing list