Hi;
My code was working fine then I must have inadvertently screwed something
up. The result is a mysql insert/update statement that looks something like
the following:

update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, pic3=%s,
pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
'1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 'Furnished',
'ÿØÿàJFIFÿÛC     ""
$(4,$&1'-=-157:::#+?D?8C49:7ÿÛC
7%%77777777777777777777777777777777777777777777777777ÿÀy|"ÿÄÿÄM
 !1AQa"qs³27Bbc‚#46Rrt‘¡±²$'3C’%5DTUƒ“¢£ÑñÿÄÿÄÿÚ
?œ*‹RP’¥¨%
d’pªÔcµkä«”øZÂáîjXêxö,...@$ýô¨2mÒžÚ¦ÚrÑ¥¬ògud|!%bO:ðç’Z…æµËÚvsM¡·¢&T‘œ¬ºâ“ñâ1Ò¶¶KT[%¦-²{‘£6Ô÷“âNI=äÒfÓø/RhËîR”³q1QüÇ“ƒŸƒEŠŠ(
(¢ŠŠ( (¢ŠŠ( ×ê ´{–mÒYü VTâ†pUŽI$àQvÃ
ɼÜ/ZÒì{IrÝ,´£Èxß#¸$Š·÷F_Ëë}……áRTdHóÁ#ÐU“ö*DÙõ¨Yt]žîêÑ+p}5ùêÿ¹F†vã
Êöy5Ô‚\ˆëO Žc 'ö(Óõku-´^4õÊÚÚ£8Ðð%$ì84Ú*øG¥­·TVû#µc
æ·uÏ;Ö"Óusn\\Ü‹5{Ñʸvoò�...@é¼×cpu¤¡%kpjr2i8t+´½¨®{ß{:)kzD‡;&2~1'¤“ïÙßa¶Õº®íª5Ñúaimçá’o’8•tÆphânÇuºl¤Ûmë¸é«ÝÙøéíû’7�...@gucqÓŠhÙ¶cfØÍ\çðäLJÎ^8$}äí=i²aj©ôœ
«‰J_u/¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü
dÂsæ–Ýhq...@m5ÐqeebÜîíp]›q’Üx̧yn8pÿ߇3ip5–¨¿´©úgl2å©k)aéÒû¼5ã‚s8žTæÕæ*ýµ)Q’­ä4óp›¦0?ÌU]Br+ç\»]_"韍pTŒŸXU<dÂsæ–Ýhqb%...@m5Ð%14qe%01ebÜî%10íp]›q’Üx̧yn8pÿ߇3ip5–¨¿´©úgl2å©k)aéÒû%15¼%075%04ã‚s8žT%10æÕæ*ýµ)Q’­ä4óp›%07¦0%14?ÌU]Br+ç\»]_"韍pTŒŸXU>]
Èò ­“¬gK®tTxò^i‰É4‡ Rè ¤à8Y«›`üM]ߊ󌼀ÑK,¥Iü29ƃž6™iU‡]Ý£ 
È/²G5~xÇ£8öT۱͡§SÀ›«¿éˆÈà¥Æ[;ô‡Qן~4»vÒOܬðu”ëÐÙ Ë
%®ad“Ÿg¨Ãe1.õõœÛæû2ëËG$4>9' )$xçh3ö‰´Ë®­ôHî.%œ,†ã
ຐxSׇŽ3NûÐËAûêº5Œ‚ˆ ¨qÁৈÓÜh±ìËOÏÚV¢‰
>`ÛTíÅß«.¤¨¥Gžè<€ãŽg½ãP<ìM£h¸1[ÌÄ®;J)mA- ÐR8:g•ãXjû>‚™W‡Ô
„†Xho8é÷G‡yÀâ8ñ‡¤õ5ëQ¥‰Ÿ{žCjxo7"LÑÚ­à
ØG#Ú‡‘ž¨t–›-LjFžhÈÂXy¥(…\8)ŽJð}-ÜKp¬’T–PÔuœî€“Œ”ôTc¢ö…§íZÒ«õùµMìh‚µ<öwŽ7€É1Î’šÛ2­7
ó";=&b*Sê eÆ7xž|p
è:@Ö[YÓÚq.1Ñs¸'€b2BOÓ_!è>¡¦²Özòbm©}÷ƒêÂ`ÂFâ¤$õŠ•vq±è–bÍÏR†æ\ˆÃÎiƒãùê°tÏA‡§4Þ
Ú<ÆoÚíkfÐ…õ¤%ÁÑE<Â|oœ¯ŒÌm4Û-!¦”6€”$...@‚½t¢ƒˆ_bš}Æ×ä(¥Yçk®vqyM÷DÚf…ï9äéiîþÑj³é#>‚+™ö‘lU§]^¢)
'Ê”êüÅùéýÊñ÷?jÔÛ®¯iÙ®nÇœ­øÅg‚^�...@j@ëA#럔ú̯všÈÛGɝë†|Ö½ò*θÇßö„â3å2º}ZjþÙ¾M/_
ß½Et_Ä™õiþ°ÖZogV÷m q޾´¤¼:°2zð律¿‰³êÓü)/bC7¶Ë´ß.€Ò
ÿJ:ÛÕÀ÷J«ZÍái:9ò•(5ಔŽ' ƒŠ½¥‡ö¡­x‡Ž>©UMT3µ-×ðSýÐ 5†Ñ5«.³6YfÕ‘
ºØ‚ꬽԱ"T‰Kß’û¯+½Å•ßSVÕö[c´YnŠÔãñ”…¡F
š󖔝ީvq“ÝÀVÝÓp!?"D«„·ajkJ¼xà óñ çÆvC¨e†Öë‹8J’¢£à:~Ùö˦ê‰Ó¹H6æ
8–ä6¤öñÝð:ž]ƦMZíñ´%®lxqÛ”ûJ/>†ÀZüõsW3Ê«³ÒF©Öé<…Ñ'ö¢ƒki[6•…äÖhik{£ªóœt÷©\Ï£ènv´¡%...@ÉrŽ«sfgÙs^c1Ùi[Ž,à$¦¢ØÓåm_Pöl¡Ö4m¹à§wI¸:8„Ÿ£Èîôø‘ºÍt¢‚û¢t–˜š–*2ix†r…i)ÏèÔË®0òejmÆÔ…¤à¤Ž
ƒß]«rëE¾sIz4†Ën¶z¤ÿMr¶Ñtýr)XSö×T|šVïôUÜ¡ûù‘lÚÑ:Æû ]x¡7Ò¤·1±Ù
,C>ÐGJzÛÎÍoCêÛ<¾µl‡åÇë•üŠ©ûlc;6½z¶ýê(bþ&Ï«O𤽉üœ[}cþùtç b
‡ÓËÐ)7bß'vÿ[#ß.€ÒÃûQÖ¼?ÇVªóªømOCäsn~?é ®™9Úž²çýÄŸVkΫùTÐÞ®¹
÷¶¿“k¯¥Ÿ|Šm›Ÿ‚_#ýÝXéóiOm_&·ù>ùËw—†Có$µ ÁÇVJxq4
û9ÙµýRýâézϪ-V÷®fÞ%%¤ü$žÍ´ñqÓ¹É)êpêE$Z6·÷¹
íÖK4NÖâÓKH|a¶‰ZˆÂ~qÁëéåKÚ;J^v“¨dJ’ú».Ð9:jÀញTqÀr
^[¨öÏ}òV·íÚr2œJx„þ‘ùý¤Î–[L+²=¶ØÂYŠÂwP‘ûÉ=I™­ŒÍ!aÓ»IÑŒZ-­0ÓÞZ§BŠœß)g)'xžGˆ©1‹d(÷7c6‰’’„¾ðrÂF
Ud[aIsñ›rTMÿ'uCÎo|aXôŽ [iù5¼qèÏ·ðȦ¹ꇿWWòÕÉðb\¢9á™1œÆû/ )*Ád²¯) R
jH(#$pÇunÇ3ýÙsŸîÜçëWVtF±×‰^Ñâ>¬Ó¾kd6áÛã...@„4Òwrœ’n¤“í¢-ºideŒÓojp[î!8sЍõáa“epqeh»qÙëÒ^Œ[bï$0ò‡Ïq~âboy§ª(8®óg¸Øç.Ú#±d
ñCƒŸˆ<ˆñ*FûŸ, ŸªÝ»¸Ùò{sGu];UÐ?˾eH»vü¦¯å5]~@'õ§?‚h$Š(¢€¢Š( (¢€¢©U (ªUh
(¢ƒÿÙ', '', '', '', '', '', '')

MySQL complains about the image in string form. I'm sure the solution is
simple, but I don't know what it is.
TIA,
Victor
-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to