barriau76
Messages postés
10
Date d'inscription
dimanche 20 juillet 2003
Statut
Membre
Dernière intervention
31 janvier 2008
31 janv. 2008 à 13:53
Premièrement, je voulais dire que j'allucine pour la vitesse avec laquelle vous répondez aux questions sur le forum. C'est super agréable. Vous assurez grave sur ce site. Voila, ça c'est dit ! ! !
Pour ce qui est de mon problème, je suis limité à deux caractères pour le marqueur, et le texte est composé de texte et des nombres.
lorsque je mets des ; j'ai ce message d'erreur :
Erreur Ligne 1 : Column count doesn't match value count at row 1
INSERT INTO biens VALUES ( 'VAI10009;AI1;T;108000,00;LES TROIS PIERRES;0;0;0;0,00;1200;;0;0;;0;0;<?XML:NAMESPACE PREFIX = SKYPE /??><skype:span onmouseup="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');return skype_tb_stopEvents();" class="skype_tb_injection" onmousedown="javascript:skype_tb_imgOnOff(this,2,'0',true,16,'');return skype_tb_stopEvents();" id="softomate_highlight_0" onmouseover="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');" title="Call this phone number in France with Skype: +33235216800" onclick="javascript:doRunCMD('call','0',null,0);return skype_tb_stopEvents();" onmouseout="javascript:skype_tb_imgOnOff(this,0,'0',true,16,'');" durex="0" context="02.35.21.68.00" iamrtl="0"><skype:span onmouseup="javascript:doSkypeFlag(this,'0',1,1,16);return skype_tb_stopEvents();" class="skype_tb_imgA" onmousedown="javascript:doSkypeFlag(this,'0',2,1,16);return skype_tb_stopEvents();" id="skype_tb_droppart_0" onmouseover="javascript:doSkypeFlag(this,'0',1,1,16);" title="Skype actions" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_a.compat.flex.w16.gif)" onclick="javascript:skype_tb_SwitchDrop(this,'0','sms=0');return skype_tb_stopEvents();" onmouseout="javascript:doSkypeFlag(this,'0',0,1,16);"><skype:span class="skype_tb_imgFlag" id="skype_tb_img_f0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\famfamfam/FR.gif)"></skype:span></skype:span><skype:span class="skype_tb_imgS" id="skype_tb_img_s0"></skype:span><skype:span class="skype_tb_injectionIn" id="skype_tb_text0"><skype:span class="skype_tb_innerText" id="skype_tb_innerText0">02.35.21.68.00</skype:span></skype:span><skype:span class="skype_tb_imgR" id="skype_tb_img_r0"></skype:span></skype:span>;FIN' )
lorsque je mets des , j'ai ce message d'erreur :
Erreur Ligne 1 : Column count doesn't match value count at row 1
INSERT INTO biens VALUES ( 'VAI10009,AI1,T,108000,00,LES TROIS PIERRES,0,0,0,0,00,1200,,0,0,,0,0,<skype:span onmouseup="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');return skype_tb_stopEvents();" class="skype_tb_injection" onmousedown="javascript:skype_tb_imgOnOff(this,2,'0',true,16,'');return skype_tb_stopEvents();" id="softomate_highlight_0" onmouseover="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');" title="Call this phone number in France with Skype: +33235216800" onclick="javascript:doRunCMD('call','0',null,0);return skype_tb_stopEvents();" onmouseout="javascript:skype_tb_imgOnOff(this,0,'0',true,16,'');" durex="0" context="02.35.21.68.00" iamrtl="0"><skype:span onmouseup="javascript:doSkypeFlag(this,'0',1,1,16);return skype_tb_stopEvents();" class="skype_tb_imgA" onmousedown="javascript:doSkypeFlag(this,'0',2,1,16);return skype_tb_stopEvents();" id="skype_tb_droppart_0" onmouseover="javascript:doSkypeFlag(this,'0',1,1,16);" title="Skype actions" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_a.compat.flex.w16.gif)" onclick="javascript:skype_tb_SwitchDrop(this,'0','sms=0');return skype_tb_stopEvents();" onmouseout="javascript:doSkypeFlag(this,'0',0,1,16);"><skype:span class="skype_tb_imgFlag" id="skype_tb_img_f0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\famfamfam/FR.gif)"></skype:span></skype:span><skype:span class="skype_tb_imgS" id="skype_tb_img_s0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_s.compat.gif)"></skype:span><skype:span class="skype_tb_injectionIn" id="skype_tb_text0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_m.compat.gif)"><skype:span class="skype_tb_innerText" id="skype_tb_innerText0">02.35.21.68.00</skype:span></skype:span><skype:span class="skype_tb_imgR" id="skype_tb_img_r0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_r.compat.gif)"></skype:span></skype:span>,FIN' )
lorsque je mets des , en séparateur et ' en délimiteur j'ai ce message d'erreur :
Erreur Ligne 1 : Erreur de syntaxe près de 'VAI10009','AI1','T','108000,00','LES TROIS PIERRES','0','0','0',' à la ligne 1
INSERT INTO biens VALUES ( ''VAI10009','AI1','T','108000,00','LES TROIS PIERRES','0','0','0','0,00','1200','','0','0','','0','0','<skype:span onmouseup="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');return skype_tb_stopEvents();" class="skype_tb_injection" onmousedown="javascript:skype_tb_imgOnOff(this,2,'0',true,16,'');return skype_tb_stopEvents();" id="softomate_highlight_0" onmouseover="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');" title="Call this phone number in France with Skype: +33235216800" onclick="javascript:doRunCMD('call','0',null,0);return skype_tb_stopEvents();" onmouseout="javascript:skype_tb_imgOnOff(this,0,'0',true,16,'');" durex="0" context="02.35.21.68.00" iamrtl="0"><skype:span onmouseup="javascript:doSkypeFlag(this,'0',1,1,16);return skype_tb_stopEvents();" class="skype_tb_imgA" onmousedown="javascript:doSkypeFlag(this,'0',2,1,16);return skype_tb_stopEvents();" id="skype_tb_droppart_0" onmouseover="javascript:doSkypeFlag(this,'0',1,1,16);" title="Skype actions" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_a.compat.flex.w16.gif)" onclick="javascript:skype_tb_SwitchDrop(this,'0','sms=0');return skype_tb_stopEvents();" onmouseout="javascript:doSkypeFlag(this,'0',0,1,16);"><skype:span class="skype_tb_imgFlag" id="skype_tb_img_f0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\famfamfam/FR.gif)"></skype:span></skype:span><skype:span class="skype_tb_imgS" id="skype_tb_img_s0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_s.compat.gif)"></skype:span><skype:span class="skype_tb_injectionIn" id="skype_tb_text0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_m.compat.gif)"><skype:span class="skype_tb_innerText" id="skype_tb_innerText0">02.35.21.68.00</skype:span></skype:span><skype:span class="skype_tb_imgR" id="skype_tb_img_r0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_r.compat.gif)"></skype:span></skype:span>','FIN'' )
lorsque je mets des ; en séparateur et ' en délimiteur j'ai ce message d'erreur :
Erreur Ligne 1 : Erreur de syntaxe près de 'VAI10009';'AI1';'T';'108000,00';'LES TROIS PIERRES';'0';'0';'0';' à la ligne 1
INSERT INTO biens VALUES ( ''VAI10009';'AI1';'T';'108000,00';'LES TROIS PIERRES';'0';'0';'0';'0,00';'1200';'';'0';'0';'';'0';'0';'<skype:span onmouseup="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');return skype_tb_stopEvents();" class="skype_tb_injection" onmousedown="javascript:skype_tb_imgOnOff(this,2,'0',true,16,'');return skype_tb_stopEvents();" id="softomate_highlight_0" onmouseover="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');" title="Call this phone number in France with Skype: +33235216800" onclick="javascript:doRunCMD('call','0',null,0);return skype_tb_stopEvents();" onmouseout="javascript:skype_tb_imgOnOff(this,0,'0',true,16,'');" durex="0" context="02.35.21.68.00" iamrtl="0"><skype:span onmouseup="javascript:doSkypeFlag(this,'0',1,1,16);return skype_tb_stopEvents();" class="skype_tb_imgA" onmousedown="javascript:doSkypeFlag(this,'0',2,1,16);return skype_tb_stopEvents();" id="skype_tb_droppart_0" onmouseover="javascript:doSkypeFlag(this,'0',1,1,16);" title="Skype actions" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_a.compat.flex.w16.gif)" onclick="javascript:skype_tb_SwitchDrop(this,'0','sms=0');return skype_tb_stopEvents();" onmouseout="javascript:doSkypeFlag(this,'0',0,1,16);"><skype:span class="skype_tb_imgFlag" id="skype_tb_img_f0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\famfamfam/FR.gif)"></skype:span></skype:span><skype:span class="skype_tb_imgS" id="skype_tb_img_s0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_s.compat.gif)"></skype:span><skype:span class="skype_tb_injectionIn" id="skype_tb_text0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_m.compat.gif)"><skype:span class="skype_tb_innerText" id="skype_tb_innerText0">02.35.21.68.00</skype:span></skype:span><skype:span class="skype_tb_imgR" id="skype_tb_img_r0" style="BACKGROUND-IMAGE: url(C:\DOCUME~1\MOI\LOCALS~1\Temp\__SkypeIEToolbar_Cache\e70d95847a8f5723cfca6b3fd9946506\static\inactive_r.compat.gif)"></skype:span></skype:span>';'FIN' ' )
Je ne comprends plus rien ! ! !